Hello
A new server has been set up. MySQL was given a new - longer - root password.
Now PHPMyAdmin does not connect to the database and does not load properly.
I have attempted to force reset the password using MySQL :: MySQL 5.6 Reference Manual :: B.5.3.2 How to Reset the Root Password as quoted from cPanelLauren here: Problem after mysql root password change and I have failed to find the .pid file ( and cpanel forum for the same doesn't help; mysql...mysql....No mysqld pid file found )
So I did kill mysql and did add a text file with the SQL to set the new root password, and I have restarted the MySQL system.
- User accounts on Phpmyadmin are working fine. Root account only is not connecting.
- Restarting services makes no difference.
- Changing the password via the MySQL documentation makes no difference (maybe due to possible failure to close the .pid file properly).
- Changing the password via the WHM interface caused this issue.
- WHM 74.0.10
- PHPMyAdmin version 4.7.7
- MySQL version 5.7.24
- PhpMyAdmin works correctly on user databases, this issue only effects root phpmyadmin connections.
I have also viewed the PhpMyAdmin config file but this doesn't provide any further help.
I have read several cpanel forum topics; the one referencing this issue is here: Problem after mysql root password change but as mentioned in this thread, I can't find the .pid file to correctly close down the Mysqld instance.
So:
Where is the pid file located so that I can close down and then reset the MYSQL root password as per the official MySQL documentation, and then enable phpmyadmin to load as the root user?
instruction:
> mysqld --init-file=/var/lib/mysql/newpass --user=root &
A new server has been set up. MySQL was given a new - longer - root password.
Now PHPMyAdmin does not connect to the database and does not load properly.
I have attempted to force reset the password using MySQL :: MySQL 5.6 Reference Manual :: B.5.3.2 How to Reset the Root Password as quoted from cPanelLauren here: Problem after mysql root password change and I have failed to find the .pid file ( and cpanel forum for the same doesn't help; mysql...mysql....No mysqld pid file found )
So I did kill mysql and did add a text file with the SQL to set the new root password, and I have restarted the MySQL system.
- User accounts on Phpmyadmin are working fine. Root account only is not connecting.
- Restarting services makes no difference.
- Changing the password via the MySQL documentation makes no difference (maybe due to possible failure to close the .pid file properly).
- Changing the password via the WHM interface caused this issue.
- WHM 74.0.10
- PHPMyAdmin version 4.7.7
- MySQL version 5.7.24
- PhpMyAdmin works correctly on user databases, this issue only effects root phpmyadmin connections.
I have also viewed the PhpMyAdmin config file but this doesn't provide any further help.
I have read several cpanel forum topics; the one referencing this issue is here: Problem after mysql root password change but as mentioned in this thread, I can't find the .pid file to correctly close down the Mysqld instance.
So:
Where is the pid file located so that I can close down and then reset the MYSQL root password as per the official MySQL documentation, and then enable phpmyadmin to load as the root user?
instruction:
> mysqld --init-file=/var/lib/mysql/newpass --user=root &
Last edited: