Accessing MySQL (Running on RH9) via MySQL control centre
I have spent just about all day trying to connect a windows 2000 pc via Mysql control centre to my Redhat linux 9.0 box, running mysql.
I can view the tables from the linux boxes command shell, I have set a temp password "password".
When I try to access the mysql database / server from windows via the mysql control centre, it returns a message "[mysqlcctmp_1] ERROR 1045: Access denied for user: 'firstname.lastname@example.org' (using password: YES).
I am using the root account + its admin password (the same username / password that I use to access Mysql in the command shell on the linux box.
I have read about granting permissions to the root password on other domains than localhost, I have done alot of searching around the net and I cant seem to find anything relivant.
Its MySQL v. 3.23.54 running on the RH9.0 linux box, the MySQL control centre is v.0.9.3-beta running on my windows 2000 machine.
The linux box has no firewall and I can access shares on it via samba and copy files etc.
Any input would be appreciated.
Thanks for reading. :-)