读书人

无法删除mysql数据库,该如何解决

发布时间: 2012-03-08 13:30:13 作者: rapoo

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

读书人网 >Mysql

热点推荐