Docker安装mysql

2023-04-16 13:03:32     You need to specify one of the following as an environment variable:
2023-04-16 13:03:32     - MYSQL_ROOT_PASSWORD
2023-04-16 13:03:32     - MYSQL_ALLOW_EMPTY_PASSWORD
2023-04-16 13:03:32     - MYSQL_RANDOM_ROOT_PASSWORD

laradock mysql 密码,laradock下mysql You need to specify one of MYSQLROOT_PASSWORD, MYSQL_ALLOW_EMPTY_P…陆雨知的博客-CSDN博客

解决办法:

修改密码

docker部署mysql5.7后登录时出现Access denied for user ‘root‘@‘localhost‘ (using password: YES)的解决方法_weixin_48226988的博客-CSDN博客

下面命令挨个儿试试

update mysql.user set authentication_string = password('root') where user='root';
UPDATE user SET Password = PASSWORD('root1') WHERE user = 'root';
set password for root@localhost = password('root');
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root');
UPDATE user SET Password = PASSWORD('root') WHERE user = 'root';
ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
update user set host='%' where user='root';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root';
flush privileges;