Find the answer to your Linux question:
Results 1 to 3 of 3
Like Tree1Likes
  • 1 Post By atreyu
Hi there I am using red hat enterprise 5.6 as the main (local) DB server, currently I am trying to access MySQL using MySQL query browser from a windows machine. ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Aug 2011
    Posts
    13

    Can't login to MySQL remotely !


    Hi there I am using red hat enterprise 5.6 as the main (local) DB server, currently I am trying to access MySQL using MySQL query browser from a windows machine.

    I keep getting an error as follows when I try to log in:
    MySQL Error number 1045

    I know the username and password is correct as I use these locally, also I can ping the RHEL server.

    The port 3306 is also open and I have also issued the command:

    Code:
    GRANT USAGE ON *.* To 'root' at '<ipaddress>' IDENTIFIED BY '<root password>'
    But this doesn't seem to work and I am now running out of ideas help me please !

    Thanks in advanced.

  2. #2
    Trusted Penguin
    Join Date
    May 2011
    Posts
    4,353
    Can you temporarily try a wildcard definition, to see if that is your problem? e.g.:

    Code:
    GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY 'password';
    Is there anything helpful in the mysqld.log?
    titley100 likes this.

  3. #3
    Just Joined!
    Join Date
    Aug 2011
    Posts
    13
    Quote Originally Posted by atreyu View Post
    Can you temporarily try a wildcard definition, to see if that is your problem? e.g.:

    Code:
    GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY 'password';
    Is there anything helpful in the mysqld.log?

    Thanks mate the wildcard definition seems to have worked much thanks have been looking for a solution for this for a while thank you !!!

  4. $spacer_open
    $spacer_close

Posting Permissions

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