Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    47

    Unanswered: remote connection problem

    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 …

  2. #2
    Join Date
    Jul 2004
    Posts
    69
    be sure to grant all priv (if you want to grant all priv on all users) and then dont forget to flush priveleges...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •