idea设置ctrl滚轮调节字体Access denied for user ''@'172.17.0.1' (using password: NO)大小
时间: 2023-10-02 17:13:49 浏览: 57
要解决"Access denied for user ''@'172.17.0.1' (using password: NO)"的问题,你可以按照以下步骤进行操作:
Step 1: 打开MySQL配置文件mysqld.cnf进行修改。
Step 2: 重置密码,可以使用ALTER USER语句来重置密码。首先,进入MySQL命令行界面,并使用以下命令修改密码:
```
mysql> use mysql;
mysql> alter user 'root'@'localhost' identified by '12345c';
```
Step 3: 更新user表中的authentication_string字段,将密码存储在该字段中。在MySQL命令行界面中执行以下命令:
```
mysql> use mysql;
mysql> update user set authentication_string=PASSWORD("12345c") where user='root';
mysql> update user set plugin="mysql_native_password";
mysql> flush privileges;
```
Step 4: 授予远程登录MySQL的权限。在MySQL命令行界面中执行以下命令:
```
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '12345c' WITH GRANT OPTION;
```
Step 5: 重新配置MySQL以允许通过Navicat连接。在MySQL命令行界面中执行以下命令:
```
mysql> ALTER user 'root'@'%' IDENTIFIED WITH mysql_native_password BY '12345c';
mysql> flush privileges;
mysql> quit;
```
通过以上步骤,你应该能够解决"Access denied for user ''@'172.17.0.1' (using password: NO)"的问题。