docker mysql 报无操作权限

docker exec -it mysql bash

mysql -u root -p

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

flush privileges;

 

 

SELECT * FROM mysql.user where `User` = 'root'

 

show variables like 'max_allowed_packet';

set global max_allowed_packet=10*1024*1024;


//查看max_allowed_packet大小

//设置允许的最大数据包大小,单位为B

 

 

https://blog.csdn.net/Abysscarry/article/details/79714114