在源码编译安装mysq5.7 后报错
报错一:
2023-01-30T09:15:36. [ERROR] Could not create unix socket lock file /usr/local/mysql/tmp/mysql.sock.lock.
2023-01-30T09:15:36.[ERROR] Unable to setup unix socket lock file.
或者
2023-01-30T08:42:08. [ERROR]Could not open unix socket lock file /usr/local/mysql/tmp/mysql.sock.lock.
2023-01-30T08:42:08. [ERROR] Unable to setup unix socket lock file.
找到mysql的安装目录
[root@bogon tmp]# cd /usr/local/mysql
[root@bogon mysql]# ls
bin docs lib man README share tmp
data include LICENSE mysql-test README-test support-files
mysql下面创建的目录都需要添加mysql权限,其实就是上面报错的上一个目录
chown -R mysql:mysql /usr/local/mysql/tmp
加一个权限就好了
报错二:
2023-01-30T08:32:08.763884Z 0 [ERROR] Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root!
启动的时候增加–user=root 使用root用户
这里的环境
/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --user=root