Wrong permissions on mysql start?

102020

Registered
Apr 26, 2016
2
0
1
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
Hello :)

Please post the output from the following commands:

Code:
rpm -qa|grep MySQL
cat /usr/local/cpanel/version
stat /
Thank you.
 

102020

Registered
Apr 26, 2016
2
0
1
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 [~]#
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
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.