Linux下首次安装MySQL关于root用户的密码问题
基于MySQL-8.0版本
- 以root用户登录MySQL系统(初始无密码)
sudo mysql -u root
- 查询一下MySQL系统是否自带数据库mysql(一般自带的,当前处于mysql命令行模式)
use mysql;
显示如下,没啥问题:
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
- 查询一下root用户的情况(首次安装mysql的话,plugin对应是auth_socket)
SELECT User, Host, plugin FROM mysql.user;
显示如下,也没啥问题:
+------------------+-----------+-----------------------+
| User | Host | plugin |
+------------------+-----------+-----------------------+
| debian-sys-maint | localhost | caching_sha2_password |
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session | localhost | caching_sha2_password |
| mysql.sys | localhost | caching_sha2_password |
| root | localhost | auth_socket |
+------------------+-----------+-----------------------+
- 开始修改root用户的密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '密码填写在这里';
- 刷新一下系统权限相关表
flush privileges;
- 退出
exit
- 重新登陆测试(不需要sudo提权了)
mysql -u root -p
# 接下来输入设置的密码
# ...
# 成功登录!!!