解决navicat连接上mysql数据库

太过爱你忘了你带给我的痛 2022-11-25 04:21 252阅读 0赞

## 前言 ##

新安装完数据库后，使用`mysqladmin`修改了数据库的密码，不过没有给主机授权，导致navicat连接不上数据库，报错如下

![在这里插入图片描述][20200807122339837.png]

所以，不建议大家使用mysqladmin修改数据库的密码

解决方法：grant 给主机授权

[root@localhost ~]# mysql -uroot -p123.com
    mysql: [Warning] Using a password on the command line interface can be insecure.
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 12
    Server version: 5.7.30 MySQL Community Server (GPL)
    
    Copyright (c) 2000, 2020, 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> 
    mysql> grant all privileges on *.*  to root@'172.16.46.%' identified by '123.com';
    Query OK, 0 rows affected, 1 warning (0.00 sec)
    
    mysql> flush privileges;
    Query OK, 0 rows affected (0.00 sec)

测试连接

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzgxNTE0MA_size_16_color_FFFFFF_t_70]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzgxNTE0MA_size_16_color_FFFFFF_t_70 1]  
**如果还有其他的错误，根据报错排查**

*  mysql服务确认是否已经开启？
 *  数据库的端口号是否更改？连接时是否一致？
 *  防火墙是否关闭？或者开放3306端口？

[20200807122339837.png]: /images/20221124/f7ffbebdda3541ef845e7d85720f1035.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzgxNTE0MA_size_16_color_FFFFFF_t_70]: /images/20221124/344fb5ce983f42378893114c208a1ad7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzgxNTE0MA_size_16_color_FFFFFF_t_70 1]: /images/20221124/0d4f779f2a1e40e5bab69a6975d6575c.png