美文网首页
Navicat连接docker容器中的mysql报错2003解决

Navicat连接docker容器中的mysql报错2003解决

作者: 目光下的暮光 | 来源:发表于2020-05-21 20:45 被阅读0次

    使用Navicat远程连接docker容器中的mysql 报2003错误

    解决办法:

    一、在docker中启动mysql,定义端口号3306

    [root@localhost ~]# docker run -p 3306:3306 --name mysql01 -e MYSQL_ROOT_PASSWORD=123456 -d mysql
    

    二、执行命令,输入密码

    [root@localhost ~]# docker exec -it mysql01 bash
    
    root@863b69d78d4f:/# mysql -uroot -p
    
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 8
    Server version: 8.0.12 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> GRANT ALL ON *.* TO 'root'@'%';
    

    四、刷新权限

    mysql> flush privileges;
    

    五、更改加密规则

    mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
    

    六、更新root用户密码(123456是我的密码,要替换成自己的)

    mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
    

    七、刷新权限

    mysql> flush privileges;
    
    连接成功.png

    成功!

    相关文章

      网友评论

          本文标题:Navicat连接docker容器中的mysql报错2003解决

          本文链接:https://www.haomeiwen.com/subject/doztahtx.html