Allow remote connections to mysql server

Here, we are going to discuss about allowing remote connections to our local MYSQL server. To do this just edit the MYSQL server configuration file my.cnf which you can found in /etc/mysql/my.cnf (Ubuntu 12.04). Check for the configuration variable called bind-address. Just comment that line by using # and then restart the MYSQL server. These steps you can do via Terminal. See below for more details:

i) Open your terminal

ii) Type sudo gedit  /etc/mysql/my.cnf and hit the ENTER

iii) Comment the bind-address line as discussed above

iv) Restart MYSQL server by typing the command sudo /etc/init.d/mysql restart. Hit the ENTER.

Once you have completed the above steps, check the remote connection to the MYSQL server.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">