Change the mysql host.

[koko92_national]

How can i change mysql host because a client wanted to connect from his desktop with SQL manager program and he didn't managed to. I would like the config of the host to be based on ip address

127.0.0.1 -> localhost
MY.SRV.IP -> hostname of the server

Can this be done?

[kurgans]

You must delete the line that forces mysql server to connect only local

bind-address = 127.0.0.1
to
# bind-address = 127.0.0.1

/ Etc / mysql / my.cnf

Restar mysql

You may connect to mysql server by your server ip

I feel my English I only speak Spanish

[koko92_national]

Thank you very much!!!!