使用终端连接docker 内部的MySQL不能连接的解决办法

MariaDB [(none)]> show databases;
+——————–+
| Database |
+——————–+
| information_schema |
| mysql |
| performance_schema |
| test |
+——————–+
4 rows in set (0.00 sec)

MariaDB [(none)]> use mysql
Database changed
MariaDB [mysql]> update user set host = ‘%’ where user = ‘root’;
ERROR 1062 (23000): Duplicate entry ‘%-root’ for key ‘PRIMARY’
MariaDB [mysql]> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

MariaDB [mysql]> FLUSH PRIVILEGES
-> ;
Query OK, 0 rows affected (0.00 sec)

这样就ok了