docker 部署mysql踩坑日志

客户端navicat 连接 docker部署的mysql容器显示权限不足

重点看3

1. 进入容器
   1. docker exec -it mysql bash
2. 登录mysql ,执行以下命令
   1. mysql -u root -p
3. 这句命令是放权限的,但是会报错语法不对
   1. GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
       
4. 所以这里新建一个root用户,然后给予权限
   1. 
      CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'rootroot';
   2. GRANT ALL PRIVILEGES ON *.* TO 'root'@'%';
   3. FLUSH PRIVILEGES;