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:
    45,760
    Likes Received:
    1,995
    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:
    45,760
    Likes Received:
    1,995
    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:
    45,760
    Likes Received:
    1,995
    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:
    45,760
    Likes Received:
    1,995
    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,630
    behinam
    Dec 28, 2017
  2. Direct Web Solutions

    New Thread phpmyadmin Operations tab formatting lost

    Direct Web Solutions, Jan 21, 2019 at 9:41 AM, in forum: User Experience
    Replies:
    7
    Views:
    63
    Infopro
    Jan 22, 2019 at 12:30 PM
  3. chengkinhung

    In Progress [UPS-89] SQL is missing from table export options in phpMyAdmin 4.8.4

    chengkinhung, Jan 20, 2019 at 1:54 AM, in forum: Database Discussion
    Replies:
    1
    Views:
    90
    cPanelMichael
    Jan 21, 2019 at 1:42 PM
  4. malik imran

    Database not displaying in phpMyAdmin

    malik imran, Jan 2, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    127
    cPanelLauren
    Jan 4, 2019
  5. rpvw

    SOLVED [CPANEL-24366] phpMyAdmin version 4.8.4

    rpvw, Dec 11, 2018, in forum: Security
    Replies:
    2
    Views:
    375
    cPanelMichael
    Jan 21, 2019 at 1:10 PM

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