PHPMyAdmin blank screen after logging in

jdowen

• September 30, 2014 03:50

When accessing PHPMyAdmin in one of the cPanel accounts on our VPS - it prompts us to login again on the PHPMyAdmin login screen (which also has no frame, CSS assets, etc). I enter my login details and it takes me to a blank screen. So I can't access PHPMyAdmin to do work on live websites. Also, when clicking on the MySQL databases option in cPanel (to create a new database for etc) it says "The MySQL server is currently offline." and the following error shows up:
Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 136 Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Access denied for user 'root'@'localhost' (using password: YES) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 136 ...caught
I have also attempted signing into MySQL via command line to flush privileges, etc - but it says access is denied for the root user. I'm not sure why this is happening. MySQL is working perfectly fine on the frontend all websites are still functional.

• 

  cPanelMichael

  • September 30, 2014 16:17

  Hello :) Please check to see if the following file exists under the account: /home/$username/.my.cnf If so, please remove this file to see if the issue persists. Or, update the account password using: "WHM Home " Account Functions " Password Modification" This will sync the account password with the MySQL password for the user. Thank you.

  0
• 

  jdowen

  • October 20, 2014 10:05

  Hi there, Thank you for your reply. I've tried both of them and the error still persists.

  0
• 

  cPanelMichael

  • October 20, 2014 16:37

  Have you tried updating the MySQL root password? You can do so via: "WHM Home " SQL Services " MySQL Root Password" Thank you.

  0
• 

  jdowen

  • October 21, 2014 08:01

  I tried to do that and got the following: MySQL password change failed!! A forced reset will now be attempted. Attempting MySQL Root Password Reset Waiting for mysql to restart.....finished. mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/677137.vps-10.com.pid) running as root with PID 17834 (process table check method) mysqld (/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/677137.vps-10.com.err --pid-file=/var/lib/mysql/677137.vps-10.com.pid) running as mysql with PID 17985 (pidfile check method)

  0
• 

  cPanelMichael

  • October 21, 2014 14:14

  It looks like the forced MySQL root password reset completed successfully. Does the issue with phpMyAdmin persist? If so, please open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome. Thank you.

  0
• 

  jdowen

  • October 21, 2014 15:01

  Well when I enter login details on PHPMyAdmin, it takes me to a blank page. I then refresh the page then I'm signed in - so I can live with that. But I cannot create any new MySQL databases as it comes up the the error in my first post in this thread. I've tried resetting the password. What else can you suggest?

  0
• 

  cPanelMichael

  • October 21, 2014 16:29

  Please open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome. Thank you.

  0

Please sign in to leave a comment.