The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Database Discussions' started by jamesterror, Aug 11, 2013.

  1. jamesterror

    jamesterror Member

    Joined:
    Feb 28, 2013
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    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
     
    #1 jamesterror, Aug 11, 2013
    Last edited: Aug 11, 2013
  2. rasa

    rasa Active Member

    Joined:
    Feb 17, 2013
    Messages:
    44
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Helo
    i have similar issue on websites not phpmyadmin just after migrating databases to remote database server !
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    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.
     
  4. jamesterror

    jamesterror Member

    Joined:
    Feb 28, 2013
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page