记录一下配置过程。
- 首先是开放端口:
【踩坑】在linux服务器上配置mysql并开放3306端口 - 然后是在Linux系统上改变密码:
开放数据库权限后,host并非localhost,因此如下语句会报错。
# ×
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password by '123456';
# √
mysql> mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123';
一些有用的指令:
# 一些有用的指令:
# 登录:
mysql -u root -p
mysql> use mysql;
mysql> select user,plugin from user; # 查询其用户
mysql> update user set plugin='mysql_native_password' where user='root'; # 修改其密码格式
mysql> select user,plugin from user; # 查询其用户
mysql> flush privileges;
mysql> select user,host from user;
# 根据结果改密码
mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123';
#
mysql> flush privileges;
mysql> quit;
service mysql restart
- 效果图
- 一些参考
Ubuntu的mysql安装与配置 4.密码查询及更改
mysql启动报错【No directory, logging in with HOME=/】
Navicat Premium 15下载与安装教程 记得启动Keygen前关闭Navicat
ERROR 1396 (HY000): Operation ALTER USER failed for ‘root‘@‘localhost‘