启动报错
The innodb_system data file 'ibdata1' must be writable
解决办法:
修改data目录的权限
groupadd mysql
useradd -g mysql mysql
passwd mysql
chown -R mysql.mysql data目录路径
启动报错
Fatal error: Can‘t open and lock privilege tables: Table ‘mysql.user‘ doesn‘t exis
解决办法:
将data目录清空,重新生成库文件
mysqld --initialize
mysql -uroot -p 连接报错
can't connect to local MySQL server through socket '/tmp/mysql.sock'
解决办法:
修改my.cnf,路径一般为/etc/my.cnf
在[mysqld]下增加如下配置
socket = /tmp/mysql.sock
mysql -uroot -p 连接报错
Access denied for user 'root'@'localhost' (using password: NO)
解决办法:
停掉服务,用以下命令启动
mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
然后依次执行以下命令
mysql -u root mysql
UPDATE mysql.user SET Password=PASSWORD('密码') WHERE user='root';
flush privileges;
如果执行UPDATE语句时报错
Unknown column 'Password' in 'field list'
则将UPDATE语句替换成以下语句
UPDATE mysql.user SET authentication_string=password('密码') WHERE user='root';
mysql -uroot -p 连接后执行任何命令都报错
报错信息:
You must reset your password using ALTER USER statement before executing this statement.
解决方法:执行以下命令
alter user 'root'@'localhost' identified by '密码';
flush privileges;
无法用root账号远程连接
解决方法:执行以下命令
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
flush privileges;