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.

cPanel/MySQL not working correctly

Discussion in 'General Discussion' started by SiMka, Jun 1, 2005.

  1. SiMka

    SiMka Active Member

    Joined:
    Mar 12, 2005
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    My cPanel currently not showing the SQL databases under MySQL, but it shows the databases under phpMyAdmin. And I cannot login to root sql account (myql root etc).
    Tried to reset the root sql password under WHM, but still nothing. Also tried to reinstall mysql and run some "fix scripts" like fixmysql etc. But still nothing.. Users cannot see their databases under cpanel. And i cannot login with root account.

    Anybody knows the solution to this?

    Greetings,
    Enn K
     
  2. aby

    aby Well-Known Member

    Joined:
    May 31, 2005
    Messages:
    638
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    Is mysql working on the server. Did you try
    ps ax | grep mysql

    if mysql is working on the server

    try
    /scripts/updatemysqlquota

    then check the cpanel if the datatabases are showing

    About reseting the mysql password, you can do it from the shell.

    ---------
    Aby :)
     
  3. SiMka

    SiMka Active Member

    Joined:
    Mar 12, 2005
    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    6
    MySQL itself worked.. sites too, but cpanel not show the databases.. only in phpmyadmin.. and cannot do rootlogin..
    I downgraded from 4.1 to 4.0 and all now work just fine!
     
  4. Interdit

    Interdit Well-Known Member

    Joined:
    May 27, 2003
    Messages:
    70
    Likes Received:
    0
    Trophy Points:
    6
    Hello,

    I'm having the same issue under mysql 4.1 after an upgrade, how to fix it ?

    Thanks,
    Francois
     
  5. rusel

    rusel BANNED

    Joined:
    Aug 1, 2005
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Poland
    /scripts/mysqlup --force
    Regards.
     
Loading...

Share This Page