使用Docker安装MySQL - sablier - 博客园
非docker 安装:
sudo docker run -p 3306:3306 --name mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.7
sudo docker exec -it mysql bash mysql -uroot -p123456
修改密码:
set password for username @localhost = password(newpwd);
set password for root @localhost = password("cai123456");
授权:
grant all privileges on *.* to root@'%' identified by "password";
grant all privileges on *.* to root@'%' identified by "cai123456";
flush privileges;