Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

PHPMyAdmin blank screen after logging in

Discussion in 'Database Discussion' started by jdowen, Sep 30, 2014.

  1. jdowen

    jdowen Registered

    Joined:
    Sep 30, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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:

    Code:
    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.
     
    #1 jdowen, Sep 30, 2014
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Sep 30, 2014
  3. jdowen

    jdowen Registered

    Joined:
    Sep 30, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi there,

    Thank you for your reply.

    I've tried both of them and the error still persists.
     
    #3 jdowen, Oct 20, 2014
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Have you tried updating the MySQL root password? You can do so via:

    "WHM Home » SQL Services » MySQL Root Password"

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Oct 20, 2014
  5. jdowen

    jdowen Registered

    Joined:
    Sep 30, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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)
     
    #5 jdowen, Oct 21, 2014
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelMichael, Oct 21, 2014
  7. jdowen

    jdowen Registered

    Joined:
    Sep 30, 2014
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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?
     
    #7 jdowen, Oct 21, 2014
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 cPanelMichael, Oct 21, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - PHPMyAdmin blank screen
  1. SupraMario

    User mysql grant permission error + phpmyadmin blank screen

    SupraMario, Dec 11, 2017, in forum: Database Discussion
    Replies:
    10
    Views:
    823
    behinam
    Dec 28, 2017
  2. whipworks

    User Level phpmyadmin not loading

    whipworks, May 14, 2018, in forum: Database Discussion
    Replies:
    17
    Views:
    184
    cPanelLauren
    May 25, 2018
  3. Bui Anh Tuan

    Input to database without phpMyAdmin?

    Bui Anh Tuan, Apr 29, 2018, in forum: Database Discussion
    Replies:
    1
    Views:
    72
    Infopro
    Apr 29, 2018
  4. gildas

    Error during auto-login on phpmyadmin

    gildas, Apr 6, 2018, in forum: General Discussion
    Replies:
    1
    Views:
    173
    cPanelMichael
    Apr 6, 2018
  5. sinai

    Hide Remote MySql server IP address in phpmyadmin

    sinai, Jan 30, 2018, in forum: Security
    Replies:
    5
    Views:
    284
    cPanelMichael
    Feb 13, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice