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