这是经常能遇到的问题,安装mysql好几次都遇到了今天通过执行以下命令是问题得到解决,特发出来与大家共享
1. 第一次登陆跳过输密码步骤
/etc/my.conf
skip-grant-tables
2. Starting MySQL...The server quit without updating PID file (/usr/local/mysql/data/CentOS.pid). [FAILED]
[root@CentOS support-files]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/
即两个“-”
3. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
1.修改/etc/my.cnf配置文件
[mysql d]
socket=/var/lib/mysql .sock
[mysql ]
socket=/tmp/mysql .sock
2.建立软连接
ln -s /var/lib/mysql /mysql .sock /tmp/mysql .sock