The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Missing password on MySQL users

Discussion in 'Database Discussions' started by bdeivid, Sep 5, 2010.

  1. bdeivid

    bdeivid Member

    Joined:
    Jun 1, 2009
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    I have upgraded MySQL to the latest 5.1 on my local WHM and remote WHM which is acting as Remote MySQL.
    After that I have recompiled easyapache and php.

    I'm facing very strange problem:

    When creating a new account in WHM(new site) everything works fine.
    When I login into cpanel as newly created account I can not access phpmyadmin, it says WRONG USERNAME OR PASSWORD.
    When I look at the remote server what has been written into USER table of MYSQL db, I found new user created with apropriate host, but there is no PASSWORD ???
    It seems like cpanel is creating users on remote MySQL without passwords ??

    I can log in into PHPMyAdmin from WHM and from all old users, but not with the new one ???

    Please advise.

    br
     
  2. bdeivid

    bdeivid Member

    Joined:
    Jun 1, 2009
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Very strange situation

    Hello again,

    when ssh to remote server and log into mysql with
    mysql -u root -p
    and type the password I can login to mysql and run selects, insert updates etc..

    But if I wish to run this:

    grant all privileges on *.* to 'root'@'IPADDRESS'; under IPADDRES I mean IP of the server which is using this one as remote server

    I get this error:
    Access denied for user 'root'@'localhost' (using password: YES)


    I have tested logging on to remote MySQL from the WHM, using SSH and mysql and it works ???

    Please advise.
     
  3. bdeivid

    bdeivid Member

    Joined:
    Jun 1, 2009
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Some logs

    Hello,

    I have tested creating new MySQL user and databases from cpanel when loged in as new account, and everything works fine.
    Mysql users are created, grants are there and passwords for mysql users.

    It appears that WHM is not able to create passwords and grants for mysql user when creating NEW SITE(account in whm).

    Here are some err_logs of cpanel when creating when creating new account:

    DBD::mysql::db do failed: Access denied for user 'root'@'xxx.xxx.xxx.xxx' to database 'abcdmysq' at /usr/local/cpanel/Cpanel/Mysql.pm line 1080.
    DBD::mysql::db do failed: Access denied for user 'root'@'xxx.xxx.xxx.xxx' to database 'abcdmysq\_%' at /usr/local/cpanel/Cpanel/Mysql.pm line 1080.


    Please advise
     
  4. bdeivid

    bdeivid Member

    Joined:
    Jun 1, 2009
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Solved

    Hello,

    to everyone who experience same issues - I solved mine by disabling IPV6 on the MySQL remote server.

    br
     
Loading...

Share This Page