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.

WHM not talking to SQL (pics)

Discussion in 'Database Discussions' started by schoeps, Oct 3, 2004.

  1. schoeps

    schoeps Well-Known Member

    Joined:
    Sep 22, 2004
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    there seems to be a login issue for the WHM to root SQL, Do i need to create a root user for WHM?

    Thanks so much! LOVE CPANEL!

    :)
    Bri
     

    Attached Files:

  2. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    "Reset Local MySQL Root Password" from WHM; and then try. or an upcp will just be fine.
     
  3. schoeps

    schoeps Well-Known Member

    Joined:
    Sep 22, 2004
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6

    I tried the reset, but what do I put in the password box? What does WHM think the pass is?

    new to cpanel... what is upcp? sorry for biendg such a knewb! Major major thanks for the help!!!!

    Bri
     
  4. haze

    haze Well-Known Member

    Joined:
    Dec 21, 2001
    Messages:
    1,550
    Likes Received:
    3
    Trophy Points:
    38
    Make up a password, just don't use the same password as your root user.
     
  5. schoeps

    schoeps Well-Known Member

    Joined:
    Sep 22, 2004
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    will upcp delete any files? what is the command line to run the script? I am in /scripts/ as root....

    thanks a million guys...

    bri
     
  6. echoterra

    echoterra Active Member

    Joined:
    Aug 29, 2003
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Eden, NC
    i had to upgrade cpanel to the newest version to correct this error
     
  7. schoeps

    schoeps Well-Known Member

    Joined:
    Sep 22, 2004
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    ran the upgraded, same problem... :mad:
     
    #7 schoeps, Oct 3, 2004
    Last edited: Oct 4, 2004
  8. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    first at shell; see if mysql is running on the machine.

    ps ax | grep mysql

    if yes; stop it; check again. If it is there then kill all of it by the

    kill -9 PID
    =================================
    now start mysql fresh. Login into mysql as root:
    ==================
    mysql -u root -p

    give the password on prompt.
    =================================

    In case your mysql root isnt working; you will have to reset it by getting into the mysqladmin. (that we will see later.. in case if the above fails)

    Now; if you could login to mysql the above way; then you need to check another thing:
    ====================================
    Just type "mysql" at shell

    See if you are logged in to mysql... If yes; then its a C-panel issue; else check if a file named "/root/.my.cnf" is there at the server; if not; create it with the following contents:
    ============================
    [client]
    user=root
    pass=XXXXXXXX
    ============================
    Replace XXXXXXX with the root password. Now try again on shell.. "mysql"

    This must fix... lets see..
     
  9. schoeps

    schoeps Well-Known Member

    Joined:
    Sep 22, 2004
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    thanks so much for your help, but it's still not working. I was able to login as root as well as see the valid information in the .my.cnf file. I guess this is a cpanel issue? What do I do now? Thanks again!

    Bri
     
  10. schoeps

    schoeps Well-Known Member

    Joined:
    Sep 22, 2004
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6

    I made a support ticket, I'll let you guys know what becomes of it... :)

    cheers and many thanks for your efforts....

    Bri
     
  11. PaulTech

    PaulTech Member

    Joined:
    Dec 9, 2003
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    in /etc/.my.cnf and /root/.my.cnf make sure there is NO quotes (" ") around mysql user or password :)
     
  12. schoeps

    schoeps Well-Known Member

    Joined:
    Sep 22, 2004
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6

    THAT DID IT! Big thanks to Rich Gilliam (CPANEL) and you! Both right on!!! :) SO HAPPY THANKS!!!!!!!!

    Bri
     
  13. PaulTech

    PaulTech Member

    Joined:
    Dec 9, 2003
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    1
    Problem was reported to Nick last night, I belive it is fixed on the Edge Release at the moment :) Glad it was fixed :)
     
  14. schoeps

    schoeps Well-Known Member

    Joined:
    Sep 22, 2004
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    good news, nice work cpanel!
     
  15. Jan Klerks

    Jan Klerks Member

    Joined:
    Mar 30, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    That worked just fine for me, although I wonder why this is needed. It took me two hours to find out what happened and how to fix it. Good thing this thread popped up. :)
     
Loading...

Share This Page