ispCP - Board - Support
Change the mysql host. - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: Change the mysql host. (/thread-10376.html)



Change the mysql host. - koko92_national - 04-13-2010 03:15 AM

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?


RE: Change the mysql host. - kurgans - 04-13-2010 03:37 AM

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


RE: Change the mysql host. - koko92_national - 04-13-2010 04:49 AM

Thank you very much!!!! Smile Smile Smile