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!

Noob Question: MySQL root user not protected?

Discussion in 'General Discussion' started by Doctor_Cox, Jan 12, 2009.

  1. Doctor_Cox

    Doctor_Cox Member

    Joined:
    Sep 11, 2005
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    151
    Gentleman,

    In the course of doing some work today, I discovered out FreeBSD server running cPanel build 11.17.5-CURRENT 20439 seems to have no root password. I ran an import command line, used the root user, and was no prompted for a password.

    Now I was logged in as root in FreeBSD itself, would this have had something to do with why I was not prompted for a password? Or does cPanel not setup the root user to have a password? If it is the latter, can I protect the root user and will it affect anything if I do?

    Thanks.
     
  2. MaestriaNick

    MaestriaNick Well-Known Member

    Joined:
    Aug 6, 2008
    Messages:
    159
    Likes Received:
    3
    Trophy Points:
    68
    Only root can do this as there is file .my.cnf in the root's home directory, which contains the mysql login details.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,216
    Likes Received:
    10
    Trophy Points:
    313
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    One can also set a MySQL Root Password by going to WHM -> SQL Services -> MySQL Root Password.
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice