Plesk panel mysql yada mariadb uzak erişim aktif etme - SONMEZ

Plesk panel mysql yada mariadb uzak erişim aktif etme - SONMEZ

<style>/*<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=8736831156475766463&zx=a754e411-adae-4c34-839d-aa67e2dee9f7' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=8736831156475766463&zx=a754e411-adae-4c34-839d-aa67e2dee9f7' rel='stylesheet'/></noscript>
<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

</head><body>
*/</style>

Yönetici

8 Şub, 2025

2184

Admin

SVIP Member

Verified

Şubat 08, 2025

New
#1

Dışarıdan plesk mysql sunucunuza erişmek istiyorsanız bir kaç işlemde sql sunucunuzu dışarı açıp bağlantı sağlayabilirsiniz.

İlk öncelikle sunucunuzda firewall onu kapatmamız gerekecektir. Sunucunuzda firewallı kapatmak için aşağıdaki komutları işletim sistemi seçeneklerinize göre uygulayınız.

Centos işletim sistemi için

systemctl stop firewalld

systemctl disable firewalld

Ubuntu işletim sistemleri için

ufw disable

Şimdi ise mysql yapılandırma dosyamız olan my.cnf dosyasını ssh(putty) programı ile açın.

Centos ise

nano /etc/my.cnf

Ubuntu yada debian ise

/etc/mysql/my.cnf

Şimdi ise aşağıdaki satırı kendi plesk ip adresinize göre düzenleyip [mysqld] altına ekleyin eğer varsa sunucunuzun IP adresi 0.0.0.0 ile değiştirin.

bind-address = 0.0.0.0

Son olarak SQL sunucunuzu resetleyin.

service mariadb restart || service mysql restart

Yanıtlamak için burayı tıklayın.

Paylaş:

Giriş Yap

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/2806328968-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY4fgg3FwlQF2JeCrtgXlQaR5A3omQ:1743800050465';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d8736831156475766463','//www.sonmezz.com.tr/2025/02/plesk-panel-mysql-yada-mariadb-uzak.html','8736831156475766463');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '8736831156475766463', 'title': 'SONMEZ ', 'url': 'http://www.sonmezz.com.tr/2025/02/plesk-panel-mysql-yada-mariadb-uzak.html', 'canonicalUrl': 'http://www.sonmezz.com.tr/2025/02/plesk-panel-mysql-yada-mariadb-uzak.html', 'homepageUrl': 'http://www.sonmezz.com.tr/', 'searchUrl': 'http://www.sonmezz.com.tr/search', 'canonicalHomepageUrl': 'http://www.sonmezz.com.tr/', 'blogspotFaviconUrl': 'http://www.sonmezz.com.tr/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'tr', 'localeUnderscoreDelimited': 'tr', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22SONMEZ  - Atom\x22 href\x3d\x22http://www.sonmezz.com.tr/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22SONMEZ  - RSS\x22 href\x3d\x22http://www.sonmezz.com.tr/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22SONMEZ  - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/8736831156475766463/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22SONMEZ  - Atom\x22 href\x3d\x22http://www.sonmezz.com.tr/feeds/1217962882763884996/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/c4ef6ff9ae7c94eb', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Ba\u011flant\u0131y\u0131 al', 'key': 'link', 'shareMessage': 'Ba\u011flant\u0131y\u0131 al', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Facebook platformunda payla\u015f', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'X platformunda payla\u015f', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Pinterest platformunda payla\u015f', 'target': 'pinterest'}, {'name': 'E-posta', 'key': 'email', 'shareMessage': 'E-posta', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27tr\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Devam\u0131n\u0131 oku \xbb', 'pageType': 'item', 'postId': '1217962882763884996', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7MzdFb3JMVNV9RlInYKzTz-AMXySK4mlCt7guKQioq_uMJqPqoIMdNFtlieSTddt7jxnRM7t_p0_g_LzYb4pMNmCwIBltHaTLNz7cQV9K5fzORoKlhv5_bgJu-_vZ7OiKyL7PoE1KjaINB6cyknHUr4sbg6VkBjK6WIHxQLDISvVk87hjKVlZlYLRAvO_/s72-c/image.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7MzdFb3JMVNV9RlInYKzTz-AMXySK4mlCt7guKQioq_uMJqPqoIMdNFtlieSTddt7jxnRM7t_p0_g_LzYb4pMNmCwIBltHaTLNz7cQV9K5fzORoKlhv5_bgJu-_vZ7OiKyL7PoE1KjaINB6cyknHUr4sbg6VkBjK6WIHxQLDISvVk87hjKVlZlYLRAvO_/s320/image.png', 'pageName': 'Plesk panel mysql yada mariadb uzak eri\u015fim aktif etme', 'pageTitle': 'SONMEZ : Plesk panel mysql yada mariadb uzak eri\u015fim aktif etme', 'metaDescription': ''}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'D\xfczenle', 'linkCopiedToClipboard': 'Ba\u011flant\u0131 panoya kopyaland\u0131!', 'ok': 'Tamam', 'postLink': 'Yay\u0131n Ba\u011flant\u0131s\u0131'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': '\xd6zel', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Plesk panel mysql yada mariadb uzak eri\u015fim aktif etme', 'description': 'Sonmezz.com.tr Ziyaret\xe7ilerimizin ruhsal sa\u011fl\u0131klar\u0131 \xfczerindeki potansiyel etkiler g\xf6z \xf6n\xfcnde bulundurularak, sorumluluk kabul edilmemektedir.', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7MzdFb3JMVNV9RlInYKzTz-AMXySK4mlCt7guKQioq_uMJqPqoIMdNFtlieSTddt7jxnRM7t_p0_g_LzYb4pMNmCwIBltHaTLNz7cQV9K5fzORoKlhv5_bgJu-_vZ7OiKyL7PoE1KjaINB6cyknHUr4sbg6VkBjK6WIHxQLDISvVk87hjKVlZlYLRAvO_/s320/image.png', 'url': 'http://www.sonmezz.com.tr/2025/02/plesk-panel-mysql-yada-mariadb-uzak.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 1217962882763884996}}, {'name': 'widgets', 'data': [{'title': 'Upload Image', 'type': 'Image', 'sectionId': 'upload-image', 'id': 'Image10'}, {'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML10'}, {'title': 'Icons, Search', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList10'}, {'title': 'Menu', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList11'}, {'title': 'Hero', 'type': 'LinkList', 'sectionId': 'hero', 'id': 'LinkList19'}, {'title': 'Duyuru Alan\u0131', 'type': 'HTML', 'sectionId': 'notice', 'id': 'HTML1'}, {'title': '#Contact Form', 'type': 'ContactForm', 'sectionId': 'contact-from', 'id': 'ContactForm1'}, {'title': 'Sayfalar', 'type': 'PageList', 'sectionId': 'pages-sticky', 'id': 'PageList1'}, {'title': 'Blog Kay\u0131tlar\u0131', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog1', 'posts': [{'id': '1217962882763884996', 'title': 'Plesk panel mysql yada mariadb uzak eri\u015fim aktif etme', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7MzdFb3JMVNV9RlInYKzTz-AMXySK4mlCt7guKQioq_uMJqPqoIMdNFtlieSTddt7jxnRM7t_p0_g_LzYb4pMNmCwIBltHaTLNz7cQV9K5fzORoKlhv5_bgJu-_vZ7OiKyL7PoE1KjaINB6cyknHUr4sbg6VkBjK6WIHxQLDISvVk87hjKVlZlYLRAvO_/s320/image.png', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'by'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'Comment'}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': 'Tags'}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'by'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'labels', 'label': 'Tags'}]}, {'title': 'Pop\xfcler G\xf6nderiler', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts10', 'posts': [{'title': 'Linux sunucularda clamav kurulumu ve komutlar\u0131', 'id': 6798880073538714844}, {'title': 'Plesk SSH Backup \u0130mport Etmek', 'id': 5280364136010178731}, {'title': 'Plesk panel ossav lisans kald\u0131rma', 'id': 5648528847503749367}, {'title': 'Plesk panelde tek t\u0131kla t\xfcm veritabanlar\u0131n\u0131 yedekleme', 'id': 4948261494897055108}, {'title': 'The storage engine for the table doesn\u2019t support check hatas\u0131', 'id': 3062279281305769624}]}, {'title': 'Etiket Bulutu', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML4'}, {'title': 'Son Yorumlar', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML2'}, {'title': 'An \u0130tibariyle', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML3'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML23'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'xen-options', 'id': 'HTML24'}]}]);
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image10', 'upload-image', document.getElementById('Image10'), {'resize': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML10', 'header-main', document.getElementById('HTML10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList10', 'header-main', document.getElementById('LinkList10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList11', 'header-main', document.getElementById('LinkList11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList19', 'hero', document.getElementById('LinkList19'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'notice', document.getElementById('HTML1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm1', 'contact-from', document.getElementById('ContactForm1'), {'contactFormMessageSendingMsg': 'G\xf6nderiliyor...', 'contactFormMessageSentMsg': '\u0130letiniz g\xf6nderildi.', 'contactFormMessageNotSentMsg': '\u0130leti g\xf6nderilemedi. Daha sonra tekrar deneyin.', 'contactFormInvalidEmailMsg': 'Ge\xe7erli bir e-posta adresi gerekli.', 'contactFormEmptyMessageMsg': '\u0130leti alan\u0131 bo\u015f b\u0131rak\u0131lamaz.', 'title': '#Contact Form', 'blogId': '8736831156475766463', 'contactFormNameMsg': 'Ad', 'contactFormEmailMsg': 'E-posta', 'contactFormMessageMsg': 'Mesaj', 'contactFormSendMsg': 'G\xf6nder', 'contactFormToken': 'AOuZoY4Ii72uN3CCYsyk-U-yqgs87QOWMA:1743800050466', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages-sticky', document.getElementById('PageList1'), {'title': 'Sayfalar', 'links': [], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'blog-post', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/1104177993-lbx__tr.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts10', 'sidebar-static', document.getElementById('PopularPosts10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML4', 'sidebar-static', document.getElementById('HTML4'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML2', 'sidebar-static', document.getElementById('HTML2'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'sidebar-static', document.getElementById('HTML3'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML23', 'copyright', document.getElementById('HTML23'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML24', 'xen-options', document.getElementById('HTML24'), {}, 'displayModeFull'));
</script>
</body>*/</style>