{"id":6842,"date":"2022-08-19T23:26:44","date_gmt":"2022-08-19T17:56:44","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=6842"},"modified":"2022-08-19T23:28:50","modified_gmt":"2022-08-19T17:58:50","slug":"how-to-add-proxy-pass-rule-to-access-phpmyadmin-without-port-number-in-url-plesk","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/how-to-add-proxy-pass-rule-to-access-phpmyadmin-without-port-number-in-url-plesk\/","title":{"rendered":"How to add Proxy pass rule to access PHPMyAdmin without port number in URL -Plesk"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">Prerequisites<\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li> Credentials to access the Plesk panel<\/li><li> SSH root access&nbsp;<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><br><strong>Implementation<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Follow the below steps to install MySQL,  Enable remote access to the local MySQL server, and Proxy rule setup in the Plesk panel<br><strong>I. MySQL installation<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Log into Plesk with the credentials<\/li><li>Go to Tools &amp; Settings &gt; Database Servers &gt; Add database server .<br><img fetchpriority=\"high\" decoding=\"async\" width=\"624\" height=\"327\" src=\"https:\/\/lh5.googleusercontent.com\/8aVX3PFlQuL8XxrJGd0zGMsCl98-JPrI5HrKSBKP_816mBAslCKyDJSOjHnArudmtDFdZu7cp0EBjVNYioUktFRvPqFk8-XTLW8udass8E7brBSvvLjDlg1rK9-2UVDey99DTL8gx9XVe_QXw0OWKog\"><\/li><li>Select MySQL in Database server type, specify a Hostname or IP address, Port number, and Authentication data of another MySQL server.<br>Click on OK.<br>Note: By default, the Administrator\u2019s username for the additional MySQL server is root.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/q7ANQcZg-2fSnbewKevIaO5NAapXkxALbcLiDihuRSXxZhKRHpbfGnv-Hc4NNxR54bSRwdDmiIRTmPuYX_SttttooumqIPThjdv7sUsMP_1WPtgHMr5CuDtLNX9S9vmxVnp9gWzFrSISoKZWv82vWQE\" alt=\"\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\"><li>Verify the MySQL successful&nbsp; installation in Tools &amp; Settings &gt; Database Servers&nbsp;<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/h-8DXDlX9sLW1BjSBHLk6f8LdJ2ZIpEU8_ZJ9BACdy1zbK-CsyQjNttYSJ_215RKbTlSAPOHQHCfd9dNKl6Yos99_ou6uHkBXldd6V-EuUU_xutmY41TySDZPIZtrGW1nPhujrq6-GWk-2bC1dUs99Y\" alt=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>II. Enable remote access to the local MySQL server<\/strong><br><br>1. Go to Tools &amp; Settings &gt; Database Servers &gt; Settings &gt; click Local MySQL Settings<strong><br><br><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2. Select the Allow local MySQL server to accept external connections checkbox, and then click OK<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/_Ho6AflF_k3_c_5sQmcFNWROIgTDb8XKq0V9rqIFOOwz_Ew5YsXObjkiH7BmaPdgqJV6_ENc0vWnozGO5Gn1jBFhOi-yWxjG7yYooQMnXWeuwxoUjMn1Al9WEheraHJpcZX3pthpnX9FQlgP2e7m8iU\" alt=\"\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">3. Connect to a Plesk server via <a href=\"https:\/\/support.plesk.com\/hc\/en-us\/articles\/115000172834\" target=\"_blank\" rel=\"noopener\">SSH<\/a> and open the MySQL configuration file in any text editor. Location of this file is<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">For CentOS\/RHEL-based distributions:<br>\/etc\/my.cnf<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For Debian\/Ubuntu-based distributions:<br>\/etc\/mysql\/my.cnf<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4. Change the bind-address parameter to:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">bind-address = 0.0.0.0<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Note: 0.0.0.0 means every IP address on the server. If it is required to bind to a specific IP address, specify this particular IP instead of 0.0.0.0<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Also, make sure that the skip-networking parameter is not defined.<\/p>\n\n\n\n<ol class=\"wp-block-list\" start=\"5\"><li>After that, restart the MySQL server<br>For CentOS\/RHEL-based distributions:<br># service MariaDB restart<br>For Debian\/Ubuntu-based distributions:<br># service mysql restart<\/li><\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"6\"><li>Login to the Mysql server with the credentials that you have created in the previous steps<\/li><\/ol>\n\n\n\n<ol class=\"wp-block-list\" start=\"7\"><li>Grant access to remote IP address and login to MySQL. <br>For example, if it\u2019s required to&nbsp; allow access to the database called database for user with password and remote IP address<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>GRANT ALL ON database.* TO user@&#8217;%&#8217; IDENTIFIED BY &#8216;password&#8217;;<br>CONFIG_TEXT: FLUSH PRIVILEGES;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><br><\/strong>Note: Replace the % with specific IP if needed.<br><strong><br><\/strong>To create a user that has access to all databases, execute the following query:<br>GRANT ALL PRIVILEGES\u2026<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>III. Proxy rule setup&nbsp;<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>Login to the Plesk panel<\/li><li>Navigate to Domain, select the domain which needs to add a proxy pass<\/li><li>Select Hosting &amp; DNS &gt; Apache &amp;nginx settings<br><\/li><li>&nbsp;Add the rules in the section Additional directives for HTTP &amp; Additional directives for HTTPS. Click on OK<br><br>Additional directives for HTTP<br><\/li><\/ol>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>SSLProxyEngine on<br>ProxyPass \/ http:\/\/hostname.plesk.page:8880\/phpMyAdmin\/<br>ProxyPassReverse \/ http:\/\/hostname.plesk.page:8880\/phpMyAdmin\/<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><br><\/strong><strong>Additional directives for HTTPS<\/strong><strong><br><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td>SSLProxyEngine on<br>ProxyPass \/ http:\/\/hostname.plesk.page:8880\/phpMyAdmin\/<br>ProxyPassReverse \/ https:\/\/hostname.plesk.page:8880\/phpMyAdmin\/<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">5. We can access the phpMyAdmin with the URL mentioned below<br>https:\/\/domainname<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Prerequisites Credentials to access the Plesk panel SSH root access&nbsp; Implementation Follow the below steps to install MySQL, Enable remote [&hellip;]<\/p>\n","protected":false},"author":495,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1019],"tags":[339,959],"class_list":["post-6842","post","type-post","status-publish","format-standard","hentry","category-cloud-aws","tag-phpmyadmin","tag-pleak","psol-cat-cloud-aws"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/phn2x7-1Mm","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6842","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/495"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=6842"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/6842\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=6842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=6842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=6842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}