1.rpm -ivh MySQL-server-5.6.25-1.el6.x86_64.rpm 安装失败,跳一堆file,
mkdir -p /data/mysql
chown mysql:mysql -R /data/mysql
创建数据目录并赋予权限,后问题解决,
2.启动服务 报错
The server quit without updating PID file ([FAILED]/mysql/iZbp12lqd9o4nwejg02gimZ.pid)
发现是因为前面把my.cnf删掉了,重新创建 vim /etc/my.cnf
[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysql
socket=/tmp/mysql.sock
log-error=/data/mysql/mysql.err
pid-file=/data/mysql/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true
3重新启动 ,报错变成 MySQLCouldn't find MySQL server (/usr/local/mysql/[FAILED]ld_safe)
因为basedir路径不对,whereis mysqld_safe 查找
修改为basedir=/usr
重新启动,成功
4.登录,提示Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
发现mysql.sock 在tmp/mysql.sock,不在他说的这个目录,于是建立软连接关联两个文件夹
sudo ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
重新登录,成功