使用Navicat Premium 连接数据库

Mac版: Navicat Premium​​​​​​

当连接到8.0以上的MySQL是重置密码方法;

1 /usr/local/mysql/bin/mysql -u root -p

2 ...       输入密码

3 Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 12
Server version: 8.0.13 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 这里开始执行mysql命令

1.5.7以前版本

& mysql -u root -p 

mysql> use mysql;

mysql> update user set password=password("新的密码") where user='root';  

mysql> flush privileges;



出现错误: 转载 https://www.cnblogs.com/ivictor/p/5142809.html

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
validate_password_number_count指定了密码中数据的长度，
validate_password_special_char_count指定了密码中特殊字符的长度，validate_password_mixed_case_count指定了密码中大小字母的长度



mysql> select @@validate_password_length; #查看密码长度

mysql> set global validate_password_policy=0; #设置时select @@validate_password_length;为8

mysql> set global validate_password_length=1;

2. 5.7以后版本

update user set authentication_string=password("新的密码") where user='root'

3.8.0版本

ALTER user 'root'@'localhost' IDENTIFIED BY '新的密码';
FLUSH PRIVILEGES;

4.8.0版本

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新的密码';
FLUSH PRIVILEGES;