MySQL-未知数据库

Question

最近更新到 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)

Answer 1

@ted 如果您有 MyVideos93 的 sql 文件。

然后删除当前命令并运行这些命令。

CREATE DATABASE MyVideos93;
USE MyVideos93;

然后

mysql -uroot –pmypassword < MyVideos93.sql