Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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.

Databases not show in phpmyadmin

Discussion in 'Database Discussions' started by gopkris2005, Mar 4, 2010.

  1. gopkris2005

    gopkris2005 Well-Known Member

    Joined:
    Jan 9, 2007
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    #1 gopkris2005, Mar 4, 2010
  2. madaboutlinux

    madaboutlinux Well-Known Member

    Joined:
    Jan 24, 2005
    Messages:
    1,051
    Likes Received:
    2
    Trophy Points:
    168
    Location:
    Earth
    Only the databases added from cPanel will be shown from cPanel/phpMyAdmin. Manually added/copied databases will only be listed in WHM/phpMyAdmin.

    cPanel add the username of the account before the database name (ex. user_dbname) and if the database is not in this format, it won't be listed under cPanel.
     
    #2 madaboutlinux, Mar 4, 2010
  3. gopkris2005

    gopkris2005 Well-Known Member

    Joined:
    Jan 9, 2007
    Messages:
    64
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Yes, All database added from cpanel and its looks like database name (ex. user_dbname). Now I received the following error.

    Wrong username/password. Access denied.

    I have already changed cpanel password but it does not help. :(
     
    #3 gopkris2005, Mar 4, 2010
  4. hm2k

    hm2k Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    93
    Likes Received:
    0
    Trophy Points:
    156
    One of my users has started to see this issue.

    Was there a fix?

    Thanks.
     
    #4 hm2k, Nov 1, 2010
  5. Bahram0110

    Bahram0110 Well-Known Member

    Joined:
    Dec 12, 2007
    Messages:
    45
    Likes Received:
    0
    Trophy Points:
    56
    Hi,
    I have this problem too
    after I was update cpanel to Current Build 11.28.7, nobody can login to phpmyadmin directly
    It always ask for Db login details.

    (But I can view any db with root account without db login details)
     
    #5 Bahram0110, Nov 4, 2010
  6. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,554
    Likes Received:
    9
    Trophy Points:
    168
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    Troubleshooting phpMyAdmin in cPanel & WHM

    Please ensure that when accessing cPanel you are not logging-in using either the root or reseller password; please verify that you are using the correct cPanel username and cPanel account password.

    If the difficulty persists, please consider one of the following two options:
    • Submit a support request so that we can assist with an in-depth and thorough investigation, to ensure the issue is properly diagnosed and escalated as needed; please also let me know your ticket ID number so that we may follow-up internally.
    • One-at-a-time, try the following steps as possible corrective measures, and after each step please test phpMyAdmin in both cPanel and via WebHost Manager (WHM):
      1. Ensure your cPanel installation is using the latest available version:
      2. Re-install phpMyAdmin via root SSH access:
        Code:
        # /usr/local/cpanel/bin/updatephpmyadmin --force
      3. Reset the cPanel account password via WebHost Manager: WHM: Main >> Account Functions >> Password Modification
      4. Logout of cPanel, then via root SSH access use the following command to monitor the cPanel error_log for new messages; proceed to access cPanel and re-test phpMyAdmin while keeping an eye on any log output displayed via SSH:
        Code:
        # tail -fvn0 /usr/local/cpanel/logs/error_log
     
    #6 cPanelDon, Nov 4, 2010
  7. Bahram0110

    Bahram0110 Well-Known Member

    Joined:
    Dec 12, 2007
    Messages:
    45
    Likes Received:
    0
    Trophy Points:
    56
    Thank you very mich cPanelDon

    1, 2 & 3 was not solution for me.

    I used 4:
    after login to cpanel:
    Code:
    warn [cpanel] Unable to retrieve disk usage information. at /usr/local/cpanel/Cpanel/Filesys.pm line 63
        Cpanel::Filesys::disk_space_check('/', 1) called at cpanel line 344

after click on PhpMyadmin (In cPanel):
 warn [cpanel] Unable to retrieve disk usage information. at /usr/local/cpanel/Cpanel/Filesys.pm line 63
        Cpanel::Filesys::disk_space_check('/', 1) called at cpanel line 344
    What should I do with this error?

    Any Idea?
     
    #7 Bahram0110, Nov 6, 2010
  8. cPanelDon

    cPanelDon cPanel Quality Assurance Analyst
    Staff Member

    Joined:
    Nov 5, 2008
    Messages:
    2,554
    Likes Received:
    9
    Trophy Points:
    168
    Location:
    Houston, Texas, U.S.A.
    cPanel Access Level:
    DataCenter Provider
    Twitter:
    The disk usage warning may not be directly related, but without having direct access to inspect the system it will be difficult to know with certainty. Please submit a ticket so that we can take a look at the system and investigate further; I believe direct access is necessary to properly diagnose the phpMyAdmin difficulty. Please let me know your ticket ID number so that we may follow-up internally; this will be greatly appreciated.
     
    #8 cPanelDon, Nov 8, 2010
(You must log in or sign up to post here.)
Loading...
Similar Threads - Databases show phpmyadmin
  1. behinam

    remote databases are not shown in phpmyadmin

    behinam, Nov 26, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    344
    cPanelMichael
    Dec 4, 2017
  2. VJIADIS

    mysql databases (only) backup

    VJIADIS, Jan 18, 2018, in forum: Data Protection
    Replies:
    1
    Views:
    242
    cPanelMichael
    Jan 19, 2018
  3. Nirjonadda

    How can Optimize one Databases

    Nirjonadda, Dec 14, 2017, in forum: Database Discussions
    Replies:
    5
    Views:
    214
    cPanelMichael
    Dec 15, 2017
  4. MarceloKonrath

    Restore all databases ibdata1 corrupted

    MarceloKonrath, Oct 29, 2017, in forum: Database Discussions
    Replies:
    8
    Views:
    491
    MarceloKonrath
    Oct 31, 2017
  5. ovais

    Missing databases in PhpMyAdmin

    ovais, Oct 20, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    406
    cPanelMichael
    Oct 24, 2017

Share This Page