[he mings]

I checked the username and password using a trial version of sqlyog loaded onto one of the laptops. I then used the connection window to connect to the localhost mysql server.

not use what you mean by can i connect from another client.

like you say i do know the passwords for the root user, it is this user i am try to log on with. I still haven't set up any additional users, because i can't get it connect properly and i didn't want to confuse matters.

I'm connecting using a windows machine inside the lan. The lan consists of one router two hubs. The machines i trying to connect (for want of a better word) are connected to the same hub.

I found this in the link you sent over;

“There is no need to configure another port than the standard 3306. You practically only do that when you are running more than one MySQL servers behind one and the same router. You have a my.ini file somewhere (older versions in windows directory, newer versions in mysql drictory). Here you can read the port that is used. But I'm 99.999 % sure that t is 3306! You should take the time to understand some of the most important settings in the my.ini file”

This is the position i am in multiple mysql servers behind the same router do i need to change the port settings? If so were do i start……..

Thanks again for all the help

mings

[he mings]

Evening,

Thanks for you help but I am still unable to connect. I have all the servers plugged into the same hub which is conected to a router which in turn is conneted to the web. I have tried to use the server local ip address and am getting the error no. 2003 Can't connect to Mysql server on '***.***.*.* (10060). I have checked and double checked tha the username and password I'm using are correct, but still no joy.

Any ideas?

[Author]

Posts