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.

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:
    1
    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:
    18
    Only root can do this as there is file .my.cnf in the root's home directory, which contains the mysql login details.
     
  3. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,279
    Likes Received:
    8
    Trophy Points:
    38
    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