在 Docker 中运行 mysql_upgrade? [英] Running mysql_upgrade in Docker?

问题描述

我正在尝试使用以下方法创建用户:

I was trying to create a user using:

docker exec -i database mysql -uroot -proot -e "CREATE USER 'dbadmin'@'%'"

但是我遇到了这个错误:

However I ran into this ERROR:

ERROR 1054 (42S22) at line 1: Unknown column 'password_last_changed' in 'mysql.user'

推荐答案

google了几个小时后，我在这个博客文章:

After googling for a few hours, I found the answer in this blog post:

docker exec -it container_name bash -c "mysql_upgrade -uroot -proot"

root 必须是你的mysql用户名和密码

root must be your mysql username and password

这篇关于在 Docker 中运行 mysql_upgrade?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！