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.

Wrong permissions on mysql start?

Discussion in 'Database Discussions' started by 102020, Apr 26, 2016.

  1. 102020

    102020 Registered

    Joined:
    Apr 26, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Canada
    cPanel Access Level:
    Root Administrator
    Fresh install of CentOS 6.7 and latest CPanel.

    Initially found that 'localhost' could not be used in web configs, started digging and discovered static IP could. Kept digging, found root cause. /var/lib/mysql/mysql.sock has 755 permissions which makes everything fail. I have to manually go and change it to 777 for systems to operate.

    > service mysql restart

    Reverts the mysql.sock back to 755, how to fix this? I have followed the general guides with /tmp folder etc, nothing seems to keep it at 777 after a mysql restart.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,724
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. 102020

    102020 Registered

    Joined:
    Apr 26, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Canada
    cPanel Access Level:
    Root Administrator
    root@host [~]# rpm -qa|grep MySQL
    cpanel-perl-522-MySQL-Diff-0.43-1.cp1156.x86_64
    compat-MySQL51-shared-5.1.73-1.cp1150.x86_64
    compat-MySQL50-shared-5.0.96-4.cp1136.x86_64
    root@host [~]# cat /usr/local/cpanel/version
    11.56.0.8
    root@host [~]# stat /
    File: `/'
    Size: 4096 Blocks: 8 IO Block: 4096 directory
    Device: 700h/1792d Inode: 2 Links: 25
    Access: (0755/drwxr-xr-x) Uid: ( 0/ root) Gid: ( 0/ root)
    Access: 2016-04-27 18:14:28.019068199 -0400
    Modify: 2016-04-27 18:11:06.022913867 -0400
    Change: 2016-04-27 18:11:06.022913867 -0400
    root@host [~]#
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,724
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Check to ensure the /tmp/mysql.sock file is a symbolic link rather than a separate file:

    Code:
    ls -al /tmp/mysql.sock
    Also, please let us know the output from these commands:

    Code:
    cat /var/cpanel/rpm.versions.d/local.versions
    /usr/local/cpanel/scripts/check_cpanel_rpms --fix
    Thank you.
     
Loading...

Share This Page