Mysql Control Center Connection Problems

[dwhalen]

Hello,

I have a problem when I try to connect to a database through Mysql Control Center.

If I run the control center as root, I can connect to any database on my localhost, and any mysql databases on any other server. However, when I run it as a normal user, I get an error every time I connect! The error is: Error Connecting....a very descriptive message

Has anyone seen this before? Is there a preference file that is stored anywhere for root that I can copy to my home directory?

I am using RedHat 9,mysql Ver 11.18 and control center is .09 beta...I think.

Thanks

 

[DRJ478]

Have you read the manual's chapter about the MySQL privilege system?

http://www.mysql.com/doc/en/Privilege_system.html

You have to make sure that the user you connect has the proper access privileges to:
1. connect from the specified host
2. access the desired database
3. have proper privileges for that database

root has all privileges on all databases by default.

 

[dwhalen]

Hey,

Thanks for your reply. I know what you are saying, however, I can connect from the command line using devin and the correct password (devin is my username). I don't know if you have ever used the Mysql Command Center before, but you run it and then you select a database to connect to using a username,password and the ip for the server. Of course this user must be given permissions to connect up from their ip address.

So what is happening is, I run the command center as root and then connect up to my local database using devin and my password. I do the same for a database on a remote server. Everything works fine. However, when I run the command center as devin and then try to connect up, I get errors using the same username and password that I did with the root user....I don't know what is going on here. I don't want to have to run the command center as root all the time. Any suggestions? Thanks for your time.

Later