mysql 安装步骤:
https://www.cnblogs.com/xiaopotian/p/8196464.html
安装完成后进入mysql没有密码:mysql -uroot -p ,提示输入密码时直接Enter
0、修改密码:
1)vi /etc/my.cnf
添加一段代码: skip-grant-tables
2)重启mysql:
免密登录mysql
use mysql;
update user set authentication_string=password('123456') where user='root';
或者
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
3)去掉my.cnf文件中追加的skip**内容
重启mysql
systemctl restart mysqld.service
1、报错处理
ERROR 1146 (42S02): Table 'performance_schema.session_variables' doesn't exist