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?
I haven't used this particular tool, but I'll take a guess that it reads from
Try creating a file in your home directory, named
Replace USERNAME and PASSWORD accordingly and give it another shot.
To check it's working, you should then be able to run the
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