trouble connecting to MySQL server on local computer from MySQL Control Center
I'm fairly new to MySQL. I have it installed on my Win 2k Prof. machine. the mysql-nt.exe process is running. i also have winmysqladmin.exe installed and running. It gives the server ip address 172.24.34.8 . now, I install MySQL Control Center and EMS MySQLManager. Now, when I try to connect to the server using Host 172.24.34.8 ,root@% as username ... I get two errors . Access denied for 'user root@%' or that Host 'PHL012530 is not allowed to connect to this MySQL Server - 'PHL012530' is the name of my computer.
Really ultimately, what I'm trying to do is copy over a MySQL database from a remote server (accessible by me through a WAN connection) onto my local machine - so that I can see it, edit it, without affecting the stuff on the remote server...
What is the cause of this error? You help will be greatly appreciated.
Thanks
Subject
Written By
Posted
trouble connecting to MySQL server on local computer from MySQL Control Center
August 11, 2004 05:45PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.