日期:2014-05-16  浏览次数:20880 次

无法删除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/ 目录。