1低滩、安裝Mysql命令 docker pull mysql-server
2召夹、啟動(dòng) docker run -it --rm --name mysql -e MYSQL_ROOT_PASSWORD=123456 -p 3306:3306 -d mysql
3、進(jìn)入 docker exec -it mysql bash
4恕沫、進(jìn)入mysql : mysql -uroot -p123456 或 (mysql -uroot -p )
5监憎、查詢 select host,use from mysql.user;
查看 root 的host 如果你是localhost,執(zhí)行如下:
update mysql.user set host = '%' where user = 'root';
這里是解決到時(shí)候連接的時(shí)候出現(xiàn) Host is not allowed to connect to this MYSQL server
6婶溯、ALTER user 'root'@'%' IDENTIFIED WITH mysql_native_password BY '數(shù)據(jù)庫(kù)密碼';
7鲸阔、FLUSH PRIVILEGES;