mySQL administrator not connecting

tnrooster · 07-14-2008, 05:53 PM

Trying to run mySQL Adminstrator on my machine.

I keep getting a connect error

Quote:

Could not connect to host '192.168.0.40'.
MySQL Error Nr. 1045
Access denied for user 'root'@'192.168.0.162' (using password: YES)

Click the 'Ping' button to see if there is a networking problem.

It pings fine.

Not a connection problem. I'm using the same computer to admin the server where the database is installed. Just cant remote admin the mysql, have to vnc into server and run admin services from there.

I have the IP of the connecting computer listed in "root" in the user setup.

williebens · 07-14-2008, 09:03 PM

Hello tnrooster:

You need to create a mysql account on the box running the msyql server. Log into the mysql server, and do it:

mysql>grant all on name_of_db.* to root@'192.168.0.162' identified by 'password';

Then try connecting.
This should work.

Thanks.
--Willie

tnrooster · 07-15-2008, 07:52 AM

I did that with mysqladmin on the installed machine under root, I assigned another host-192.168.0.162-.

For what ever reason it connects remotely with no password. With password it fails.

On the installed machine it requires the root password to connect as root.

trickykid · 07-15-2008, 10:24 AM

Quote:

Originally Posted by tnrooster

I did that with mysqladmin on the installed machine under root, I assigned another host-192.168.0.162-.

For what ever reason it connects remotely with no password. With password it fails.

On the installed machine it requires the root password to connect as root.

Did you set it up with a password like described? Look in the users table and do you see an encrypted password for the root user at the specified host?