随着时间的限制,我只mysqldump和source几个小数据库到mysql 5.5,然后mysql_upgrade --verbose -u root -p,一切都好。[root@localhost ~]# mysql -u root -p < db3.sql[root@localhost ~]# mysql_upgrade --verboseThis installation of MySQL is already upgraded to 5.5.60-MariaDB, use --force if you st
今天上午,我的mySQL在我的系统上自动更新,从5.7版本更新到8.0.11版本。我得到的大多数错误是:#1449 - The user specified as a definer ('mysql.infoschema'@'localhost') does not exist
我搜索了错误,并尝试运行命令来创建用户GRANT ALL ON *.* TO 'someuser'@'%