mysql administrator

Joe_Zhu · 06-20-2005, 09:48 PM

I download the mysql administrator windows version. but after i installed it, i found it can't connect to my mysql server in my linux box .... since i can't find any document saying that it can only connect to the local mysql only, i would like to make sure does it really the case .....
thanks!

Joseph

stefan_nicolau · 06-20-2005, 10:26 PM

The MySQL administrator can connect to any MySQL server, local or not.
Make sure that MySQL listens on the correct network interfaces, and that the linux firewall is open on the right port. Can you connect to the server from the Windows machine with another program? Can you connect to the server from another remote host?

Joe_Zhu · 06-22-2005, 04:08 AM

what i should do in the my.conf so mysql can be connected from the network ?
thanks!!

stefan_nicolau · 06-22-2005, 04:23 AM

Comment the following line:

Code:

bind-address            = 127.0.0.1

or any other bind-address line

Joe_Zhu · 06-22-2005, 04:51 AM

now i can reach the mysqld from the window mysql adminstrator, but i can't login to the server. it result with a error number 1405. i am using the root user to login and in the error mesage, it show the login user is "root@mynotebook" ......
what happend ??
thanks!!

stefan_nicolau · 06-22-2005, 04:55 AM

It is ok. MySQL only allows root login from localhost. You should not disable this, but create a new user instead.