MySQL Administrator asks for password every time

I have instlaled MySQL Administrator and it works fine, except one annoying thing. Every time i select a table and click 'Edit Table Data' from context menu, it prompts for password.

Any idea how to fix this?

2 Answers

I haven't used this particular tool, but I'll take a guess that it reads from ~/.my.cnf like most utilities that talk to MySQL do.

Try creating a file in your home directory, named .my.cnf, with the following:

[client]
user = USERNAME
password = PASSWORD

Replace USERNAME and PASSWORD accordingly and give it another shot.

To check it's working, you should then be able to run the mysql client program from the terminal and it should log right in with no prompt.

Are you logging in from root account ? create a root account by using MYSQL Administrator with debian-sys-maint account whose username and password are present in /etc/mysql/debian.cnf

see if it helps