Current time: 11-06-2024, 10:29 AM Hello There, Guest! (LoginRegister)


Post Reply 
Change the mysql host.
Author Message
koko92_national Offline
Junior Member
*

Posts: 70
Joined: Jul 2008
Reputation: 0
Post: #1
Change the mysql host.
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?
04-13-2010 03:15 AM
Find all posts by this user Quote this message in a reply
kurgans Offline
Moderator
*****
Moderators

Posts: 1,565
Joined: Feb 2008
Reputation: 23
Post: #2
RE: Change the mysql host.
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
(This post was last modified: 04-13-2010 03:46 AM by kurgans.)
04-13-2010 03:37 AM
Visit this user's website Find all posts by this user Quote this message in a reply
koko92_national Offline
Junior Member
*

Posts: 70
Joined: Jul 2008
Reputation: 0
Post: #3
RE: Change the mysql host.
Thank you very much!!!! Smile Smile Smile
04-13-2010 04:49 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)