Hi,

I'm new to mysql, I've installed MYSQL on our unix server and started MYSQL on this server.

I've now downloaded MYSQL Query Browser, when I try to connect to MYSQL server, I get the following error "could not connect to the specified instance" - MySQL Error Number 1130.

From the unix server where MYSQL is running, I've entered the following command - bin/mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';

But I still get the same error message with the Query Browser.

Please could someone help and advise.

regards

venhart

How do you specify which instance, and are you sure it's running where you specified?

On the unix server, were I installed MYSQL I typed the following command to start the MYSQL :
bin/mysqld_safe --user=mysql &

I imagine there is a place where you configure where the query browser tries to connect. This needs to be the same as where the server is expecting connections -- probably localhost and 3306 are useful defaults, but if you have something else, it needs to be the same in both places. Also, check that you don't have firewall rules which block access to this port, etc.