最近更新到MySQL 5.7.24,无法再使用命令"use MyVideos93"或任何其他kodi数据库访问kodi安装的数据库使用mysql运行良好。有什么建议吗?
root@localhost [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| MyMusic52 |
| MyMusic60 |
| MyVideos107 |
| MyVideos93 |
| mysql |
| performance_schema |
| sys |
+--------------------+
8 rows in set (0.00 sec)
root@localhost [(none)]> use MyVideos93
ERROR 1049 (42000): Unknown database 'myvideos93'
root@localhost [(none)]> use mysql
Database changed
root@localhost [mysql]> show grants;
+---------------------------------------------------------------------+
| Grants for root@localhost |
+---------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------+
2 rows in set (0.00 sec)
@ted,如果您有MyVideos93的sql文件。
ndrop current one然后运行这些命令。
CREATE DATABASE MyVideos93;
USE MyVideos93;
然后
mysql -uroot –pmypassword < MyVideos93.sql