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 Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,009
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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 Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,009
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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 Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,009
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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 Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,009
    Likes Received:
    2,123
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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:
    1,872
    behinam
    Dec 28, 2017
  2. asdcxz@1239

    SOLVED phpMyAdmin redirect loop

    asdcxz@1239, May 17, 2019, in forum: Database Discussion
    Replies:
    2
    Views:
    115
    asdcxz@1239
    May 18, 2019
  3. cPanelResources

    Tutorial How to increase the maximum upload limit in PHPMyAdmin

    cPanelResources, May 7, 2019, in forum: Database Discussion
    Replies:
    0
    Views:
    173
    cPanelResources
    May 7, 2019
  4. daemoncesar

    phpMyAdmin in a loop

    daemoncesar, Apr 23, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    223
    cPanelMichael
    Apr 24, 2019
  5. KuTtY

    SOLVED cPanel phpMyAdmin logins fail when accessing cPanel via WHM

    KuTtY, Mar 24, 2019, in forum: Database Discussion
    Replies:
    3
    Views:
    573
    cPanelMichael
    Apr 2, 2019

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