We have a MYSQL Server DB and we tried to establish a remote connection (using a GUI tool).

The connection is OK if the root account is used but there is a problem with the other accounts …

The error message is the following : Access denied for user ‘mysql’@’mymachine_name’ …

This is the rows in the table user :

HOST USER PASSWORD SELECT_PRIV ...
localhost root Y Y
% root Y Y
% mysql mysql Y Y

A solution ?

Thanks in advance …

be sure to grant all priv (if you want to grant all priv on all users) and then dont forget to flush priveleges...