Enable Remote Connection

Hi
I am running mysql on Ubuntu server.

I am trying to enable remote connection, however all the tutorials I have found apply to a config file that I am assuming has changed in the latest versions.

Basically the instuctions is to change the bind address and the comment out the skip-networking.

However in my config file there is no line to skip-networking. There is instead only a bind address and a comment explaining that skip-networking is no longer used.

I tried to simply change the bind address from 127.0.0.1 to the the outside ip. When I tried to restart I got some kind of socket error and would not stop/start/ or restart mysql because of this.

I had to revert the changes I made in the config file and reboot the system.

Does anyone know how to enable remote access in this version of mysql?

 

Could you put here the error what you get?

 

You need to create a user which can connect from a remote host e.g.

GRANT ALL ON mydb.* TO 'someuser'@'somehost' IDENTIFIED BY 'password';

Code (markup):

Or give only specific permissions

GRANT SELECT, INSERT ON mydb.* TO 'someuser'@'somehost' IDENTIFIED BY 'password';

Code (markup):

Replace somehost with the IP or hostname from where the user is connecting.

 

A belated thank you

This work perfectly

 

You are welcome.