无法删除mysql数据库
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| my_test |
| mysql |
| nvr_sev |
| test |
+--------------------+
5 rows in set (0.00 sec)
mysql> drop database nvr_sev;
ERROR 1008 (HY000): Can't drop database 'nvr_sev'; database doesn't exist
mysql>
mysql>
mysql> create database nvr_sev;
ERROR 1007 (HY000): Can't create database 'nvr_sev'; database exists
无法删除,也无法创建数据库,这是怎么回事?
------------------------------
补充一下,因为数据库无法访问才打算删除的
mysql> use nvr_sev;
Database changed
mysql> show tables;
ERROR 1018 (HY000): Can't read dir of './nvr_sev/' (errno: 13)
我安装网上给的方法,还是不行
chown -R mysql:mysql /var/lib/mysql/nvr_sev/
------解决方案--------------------
直接到目录中删除这个 /var/lib/mysql/nvr_sev/ 目录。