{"id":201,"date":"2020-06-07T09:26:42","date_gmt":"2020-06-07T09:26:42","guid":{"rendered":"https:\/\/lookouthost.com\/?p=201"},"modified":"2020-06-07T09:27:59","modified_gmt":"2020-06-07T09:27:59","slug":"open-remote-connection-port-on-mysql","status":"publish","type":"post","link":"https:\/\/lookouthost.com\/blog\/open-remote-connection-port-on-mysql\/","title":{"rendered":"Open Remote Connection Port on MySQL \/ MariaDB"},"content":{"rendered":"

By default, MySQL is not listening for external connections. This means you will get error when trying to establish remote connection to your MySQL. The MySQL options file needed to configure for this to work. <\/p>

Please follow steps.<\/p>

  1. Open your MySQL configuration file. MySQL config file is normally at \/etc\/my.cnf<\/strong>. You need to open it using the nano or any other editor:<\/li><\/ol>
    nano \/etc\/my.cnf<\/code><\/pre>
    bind_address = 127.0.0.1 # Change to 0.0.0.0 to allow remote connections<\/code><\/pre>
    2. Note that you have to replace YOUR.SERVER.IP<\/strong> with your actual dedicated IP address OR 0.0.0.0 in my case and then start your MySQL daemon by running this command:<\/p>
    systemctl restart mysqld<\/code><\/pre>
    Check your port using any tool like for instance you can go to this website https:\/\/www.yougetsignal.com\/tools\/open-ports\/<\/a><\/p>
    \"\"<\/figure>
    Or you can download any MySQL tool like <\/p>
    • Navicat for MySQL<\/li>
    • MySQL Workbench<\/li>
    • Heidi SQL<\/li><\/ul>
      Here is the screenshot of MySQL Workbench which is free tool:<\/p>
      \"\"
      Remote MySQL Connection Working<\/figcaption><\/figure>
       Note: Your connecting ip must be added under the Cpanel Remote MYSQL Access Host list. Also check your firewall\/CSF that default MySQL remote port i.e. 3306 is opened or not. <\/p>","protected":false},"excerpt":{"rendered":"
      By default, MySQL is not listening for external connections. This means you will get error when trying to establish remote connection to your MySQL. The MySQL options file needed to configure for this to work. Please follow steps. Open your MySQL configuration file. MySQL config file is normally at \/etc\/my.cnf. You need to open it using the nano or any other editor: 2. Note that you have to replace YOUR.SERVER.IP with your actual dedicated IP address OR 0.0.0.0 in my case and then start your MySQL daemon by running this command: Check your port using any tool like for instance you can go… <\/p>\n","protected":false},"author":1,"featured_media":37,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-201","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-whm-cpanel"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/lookouthost.com\/blog\/wp-json\/wp\/v2\/posts\/201","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lookouthost.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lookouthost.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lookouthost.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lookouthost.com\/blog\/wp-json\/wp\/v2\/comments?post=201"}],"version-history":[{"count":0,"href":"https:\/\/lookouthost.com\/blog\/wp-json\/wp\/v2\/posts\/201\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lookouthost.com\/blog\/wp-json\/wp\/v2\/media\/37"}],"wp:attachment":[{"href":"https:\/\/lookouthost.com\/blog\/wp-json\/wp\/v2\/media?parent=201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lookouthost.com\/blog\/wp-json\/wp\/v2\/categories?post=201"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lookouthost.com\/blog\/wp-json\/wp\/v2\/tags?post=201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}