/*************************************************************************** * MySQL [ERROR] Can ' t ' create IP Socke T:permission denied * Description: * In the embedded aspect, this permission problem is quite big, and sometimes not easy to find. * 2016-9-27 Shenzhen Nanshan Ping Shan village Zengjianfeng ******************************************************* *******************/first, the error phenomenon: Cat/var/mysql/Mysql.err700101 xx: on: theMysqld_safe starting mysqld daemon with databases from/var/MySQL700101 0: on: the[Warning]'--skip-locking' isDeprecated and would be removedinchA future release. Please use'--skip-external-locking'instead. 700101 0: on: the[Note] Event scheduler:loaded0Events700101 0: on: the[Note]/usr/libexec/mysqld:ready forconnections. Version:'5.1.73-log'Socket'/tmp/mysql.sock'Port3306Source Distribution000101 xx: .: theMysqld_safe starting mysqld daemon with databases from/var/MySQL000101 0: .: the[Warning]'--skip-locking' isDeprecated and would be removedinchA future release. Please use'--skip-external-locking'instead. 000101 0: .: the[ERROR] Can'T create IP Socket:permission denied 000101 0: .: the[ERROR] aborting000101 0: .: the[Note]/usr/libexec/Mysqld:shutdown Complete000101 xx: .: theMysqld_safe mysqld fromPID file/run/mysql/Mysqld.pid ended second, reason: should be mysqld the execution user is MySQL, then cannot use the content of root permission. Third, the solution: Cat/etc/my.cnf ... # the MySQL server [mysqld] .... user=root ...
MySQL [ERROR] Can ' t ' create IP Socket:permission denied