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.

phpMyAdmin Displaying Users and Databases in Hexidecimal

Discussion in 'Database Discussions' started by jimhermann, Aug 10, 2013.

  1. jimhermann

    jimhermann Active Member

    Joined:
    Jan 20, 2008
    Messages:
    42
    Likes Received:
    1
    Trophy Points:
    8
    Folks,

    phpMyAdmin has started displaying Users and Databases in Hexidecimal. Also, at least one customer reported that the could not see their databases.

    The problem started within the last week. Did we have an upgrade to phpMyAdmin? the Interface looks different. The left menu is collapsed.

    The mysql database contains tables db and user, which have collation utf8_bin.

    Database server
    •Server: Localhost via UNIX socket
    •Server type: MySQL
    •Server version: 5.1.70-cll - MySQL Community Server (GPL)
    •Protocol version: 10
    •User: root@localhost
    •Server charset: UTF-8 Unicode (utf8)

    Web server
    •cpsrvd 11.38.2.0
    •Database client version: libmysql - 5.0.96
    •PHP extension: mysql

    phpMyAdmin
    •Version information: 4.0.4
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    phpMyAdmin version 4 is included in cPanel version 11.38.2. Are you experiencing any issues besides the one account not being able to see their databases? Does that issue persist, and if so, are there any specific errors?

    Thank you.
     
  3. jimhermann

    jimhermann Active Member

    Joined:
    Jan 20, 2008
    Messages:
    42
    Likes Received:
    1
    Trophy Points:
    8
    Yes. Two accounts have reported problems with phpMyAdmin now. They can't view databases and get this error when using the menu:

    Error in Processing Request
    Error code: 500
    Error text: Internal Server Error

    I upgraded to mySQL 5.1 before cPanel included it.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Please try updating the account passwords 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.
     
  5. Bigwebmaster

    Bigwebmaster Member

    Joined:
    Dec 3, 2003
    Messages:
    23
    Likes Received:
    1
    Trophy Points:
    1
    The problem is happening for me now too. When going into phpMyAdmin for any website on any customer account, all of the characters are simply in hex form. It used to display regular names, such as a username, but now everything looks like "8f3adf3321". I am able to get to the databases via WHM or regular account access, so reaching phpMyAdmin seems fine, its just that the contents under the browse tab are all unreadable. If I try to edit any entries, then everything display like normal, with regular text again.

    Any thoughts on what changed, or what needs to be fixed in so that information under the "browse" tab is readable again?
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Please open a support ticket so we can take a closer look and attempt to reproduce the issue:

    Submit A Ticket

    You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
  7. Bigwebmaster

    Bigwebmaster Member

    Joined:
    Dec 3, 2003
    Messages:
    23
    Likes Received:
    1
    Trophy Points:
    1
    Your Request id is: 4321509
     
  8. Bigwebmaster

    Bigwebmaster Member

    Joined:
    Dec 3, 2003
    Messages:
    23
    Likes Received:
    1
    Trophy Points:
    1
    This may be related:

    phpMyAdmin / Bugs / #3885 display_binary_as_hex option causes unexpected behavior

    We are using less than PHP 5.4, so upgrading sounds like it could potentially resolve the problem. For anybody using less than PHP 5.4 the issue may show up if this is the bug causing the problem.
     
    #8 Bigwebmaster, Aug 15, 2013
    Last edited: Aug 15, 2013
  9. Bigwebmaster

    Bigwebmaster Member

    Joined:
    Dec 3, 2003
    Messages:
    23
    Likes Received:
    1
    Trophy Points:
    1
    Okay I managed to figure this out myself. The link above is correct, and basically if a column's collation is set to utf8_bin the problem will appear. Changing the collation to utf8_general_ci resolved the problem for me and phpMyAdmin is displaying the values correctly now.

    An alternate resolution would be to patch that function in phpMyadmin that is causing the problem, or upgrade to at least PHP 5.4.
     
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page