user270398 user270398 - 6 months ago 48
MySQL Question

MySQL server remote connection?

I am trying to setup MySql 5.5 server for remote access from Ubuntu host, so
I added line: bind-address= to the server's config file: /etc/mysql/
When i tried to restart mysqld, i've got the following error:

[Note] Server hostname (bind-address): ''; port: 3306
[Note] - '' resolves to '';
[Note] Server socket created on IP: ''.
[ERROR] Can't start server: Bind on TCP/IP port: Cannot assign requested address
[ERROR] Do you already have another mysqld server running on port: 3306 ?

Can anyone help with the problem cause? And how can i open MySQL server for connection from any host/user , e.g. what should be the syntax for that in

Al_ Al_

bind-address is for your local IP addresses or network interfaces. You cannot bind to a remote address. You'll need to set up rules in a firewall in order to do such limitations. Run ifconfig to see what are your network interfaces. Use

bind-address =

to allow connections to any interface. I recommend you this post