[Case 74793] Internal Server Error 500 - Remote MySQL for one user

jamesterror

Member
Feb 28, 2013
22
0
1
cPanel Access Level
Root Administrator
Hi,

Our environment is setup whereby we have web servers, and a standalone MySQL server that we use for Remote MySQL connectivity. One user is experiencing a problem when accessing phpMyAdmin, getting the error message Error in Process Request - Error Code: 500 - Error text: Internal Server Error, please see - http://puu.sh/3ZhBs.png

This issue is only occurring for one user, we have tried the following - Cross checked the permissions with other users and chown'd and reset the permission, deleted the account and restored from a backup.

There are no errors showing for the user under /var/log/messages as well as the .err file under /var/lib/mysql/

Edit: To clarify, both servers are running WHM 11.38.2, operating MySQL 5.1

Any suggestions with re-mapping or fixing this issue would be fantastic.

Kind Regards,
James
 
Last edited:

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,910
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
Our environment is setup whereby we have web servers, and a standalone MySQL server that we use for Remote MySQL connectivity. One user is experiencing a problem when accessing phpMyAdmin, getting the error message Error in Process Request - Error Code: 500 - Error text: Internal Server Error, please see - http://puu.sh/3ZhBs.png
Please try updating the account password via:

"WHM Home » Account Functions » Password Modification"

Ensure that "Allow MySQL password change" is selected. Note that internal case number 74793 is open to address an issue similar to what you have reported.

Thank you.
 

jamesterror

Member
Feb 28, 2013
22
0
1
cPanel Access Level
Root Administrator
Please try updating the account password via:

"WHM Home » Account Functions » Password Modification"

Ensure that "Allow MySQL password change" is selected. Note that internal case number 74793 is open to address an issue similar to what you have reported.

Thank you.
Perfect! This has now worked. The user had changed the password themselves but I guess it needed root to do this?

Thanks for your help Michael.