Phpmyadmin and mysql trouble

lordnight666

Registered
Feb 6, 2014
4
0
1
cPanel Access Level
Root Administrator
Mysql give me : The mysql server is offline. But I can connect on it and everythings is working.
I think it's the mysql.sock but it's where he need to.

Phpmyadmin : [2014-02-06 10:08:10 -0500] die [cpsrvd-ssl] Attempting to drop privileges to root. at /usr/local/cpanel/Cpanel/AccessIds/ReducedPrivileges.pm line 141
Cpanel::AccessIds::ReducedPrivileges::_prevent_dropping_to_root(0, 0) called at /usr/local/cpanel/Cpanel/AccessIds/ReducedPrivileges.pm line 43
Cpanel::AccessIds::ReducedPrivileges::new('Cpanel::AccessIds::ReducedPrivileges', 'admin') called at /usr/local/cpanel/Cpanel/MysqlUtils/MyCnf/Basic.pm line 98
Cpanel::MysqlUtils::MyCnf::Basic::_getmydbparm('pass') called at /usr/local/cpanel/Cpanel/MysqlUtils/MyCnf/Basic.pm line 112
Cpanel::MysqlUtils::MyCnf::Basic::getmydbpass() called at cpsrvd-ssl line 5916
main::getuids_whostmgrd() called at cpsrvd-ssl line 1319
main::handle_one_connection() called at cpsrvd-ssl line 995
Internal Server Error: "GET /cpsess5919590757/3rdparty/phpMyAdmin/index.php HTTP/1.1" 500 exit level [die] [pid=69296] (Attempting to drop privileges to root.)

Working for user but not for root .. Anyone can help me ?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Hello :)

Verify that MySQL is able to start successfully and is running without error:

Code:
service mysql restart
mysqladmin processlist
tail -f /var/lib/mysql/$hostname.err
You can also force an update of phpMyAdmin via:

Code:
/usr/local/cpanel/bin/updatephpmyadmin --force
Thank you.
 

lordnight666

Registered
Feb 6, 2014
4
0
1
cPanel Access Level
Root Administrator
Hi Michael, i've restarted mysql and no error found, i've try to update phpmyadmin too and I got the same error when i click on phpmyadmin in the whm panel.

Internal Server Error

500

exit level [die] [pid=116451] (Attempting to drop privileges to root.)

Mysql running great but i can't access phpmyadmin for root only.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Could you 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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
To update, we were unable to reproduce this issue due to a lack of authentication details. Feel free to respond to the ticket with those details if you want us to investigate further.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
To update, here is a brief snippet from one of our support analysts:

I found an extra user with UID 0 which is the 'root' UID. It is not standard practice to have more than one user with the same UID, even for administration purposes. Other administration users should have a different UID and they should then use "sudo" or "su" to gain root privileges. If you continue to have problems with the backups, please try removing the "admin" user.
Thank you.