GUI tools 5.0 not connecting to MySQL Server - Parul Jain - com.mysql.lists.gui-tools

1 message in com.mysql.lists.gui-toolsGUI tools 5.0 not connecting to MySQL...

From	Sent On	Attachments
Parul Jain	07 Feb 2007 14:53

Subject:	GUI tools 5.0 not connecting to MySQL Server
From:	Parul Jain (pxj0...@utdallas.edu)
Date:	02/07/2007 02:53:01 PM
List:	com.mysql.lists.gui-tools

I have the following setup 5.0 Gui tools : Need to use QB and Administrator ( On Windows) Server 4.1.11 : On Linux

I have the root user and pwd to log into the server and I can see that the server is running. Mysqladmin ping -u root -p => Server is alive. Also I can log into the server with "mysql -u root -p " and execute queries.

Now, when trying to connect from Gui tools ( with the root user and pwd, port 3306 ) it gives me error # 1130 HY000 Host 'dyna090236.....' is not allowed to connect to this MySQL server. (Checked Server Variables on the server machine and the port variable = 3306)

Read the docs for this error - Says credentials not ok but my user pwd is same as root and working ok on server side.

Please suggest what is it that I am doing wrong? Any help is greatly appreciated.

thanks -parul

I have to manage a mysql server (on linux) while users will connect to it through query browser ( on windows XP mainly). I read (mysql.com )that its okay and QB can connect to server in such setup.

Now, I want to use mysql administrator to create user accounts etc easily. And I have 2 questions about it :-

1. If I download MySQL Administrator software for windows, will it be able to connect to my server ( which is on linux).

2. Also is it mandatory to download Adminstrator softwrae on same machine as the server or is it okay to keep adminstrator software on a third computer which is windows XP. ( Reason : Not well versed with linux..)

Any pointers/suggestions are appreciated. thanks -parul