使用Docker 安装PerconaMySql8.0.20-11

docker pull percona:ps-8.0.20-11

docker run -p 3306:3306 --name mysql -v /mydata/mysql/log:/var/log/mysql -v /mydata/mysql/data:/var/lib/mysql -v /mydata/mysql/conf:/etc/mysql -e MYSQL_ROOT_PASSWORD=root -d percona:ps-8.0.20-11

sudo chmod -R 777 文件路径(/mydata/mysql/)

docker restart mysql

docker update mysql --restart=always

docker exec -it -u root mysql bash

mysql -u root -proot

ALTER user ‘root‘@‘%‘ IDENTIFIED WITH mysql_native_password BY ‘123456‘;

GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘;

　FLUSH PRIVILEGES;