MySQL Access problem from Aqua Data Studio
I have installed MySQL on Linux and want to access my database through Aqua Data Studio. I have set up the approriate privileges for two user. I can't login in okay using the command line
mysql -u <user> -p
However when I try to connect to the database supplying the same information through Aqua Data Studio I get a "Connection Failed: Invalid Authorization specification: Access denied for user........"
This is for both root and my newly create user. Can anyone help???