我用回车不能打开mysql
可能是apt安装的时候默认设置了一大串密码
找了很多网上修改root密码的方法都报错
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORd('1');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PASSWORd('1')' at line 1
或者是
mysql> update mysql.user set authentication_string=password('root') where user='root';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('root') where user='root'' at line 1
最后找到解决方法
service mysql stop service mysql restart mysql -u root -p
这时候回车就能够以root账号进去了
参考官网https://dev.mysql.com/doc/refman/5.7/en/linux-installation-yum-repo.html的方法
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '需设置的密码';
就成功了
可以exit退出后再mysql -u root -p用密码进入试试，我的是成功了。
