Phpmyadmin and mysql trouble

[lordnight666]

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]

Hello

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

service mysql restart
mysqladmin processlist
tail -f /var/lib/mysql/$hostname.err

You can also force an update of phpMyAdmin via:

/usr/local/cpanel/bin/updatephpmyadmin --force

Thank you.

 

[lordnight666]

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]

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.

 

[lordnight666]

Your Request id is: 4542565.

 

[cPanelMichael]

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.

 

[lordnight666]

Hey Micheal, can you check my ticket now ? I can't do backup from about 2 week ..

 

[cPanelMichael]

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.