Missing password on MySQL users

bdeivid

Member
Jun 1, 2009
16
0
51
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
 

bdeivid

Member
Jun 1, 2009
16
0
51
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.
 

bdeivid

Member
Jun 1, 2009
16
0
51
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
 

bdeivid

Member
Jun 1, 2009
16
0
51
Solved

Hello,

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

br