ERROR 1010 (HY000) mysql 5.5.19
ERROR 1010 (HY000): Error dropping database (can't rmdir '.\test', errno: 13)
[root@xinnet5519 mysql]# ./bin/mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.5.19-log MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> drop database test;
ERROR 1010 (HY000): Error dropping database (can't rmdir './test/', errno: 17)
mysql> show warnings;
+-------+------+------------------------------------------------------------+
| Level | Code | Message |
+-------+------+------------------------------------------------------------+
| Error | 1010 | Error dropping database (can't rmdir './test/', errno: 17) |
+-------+------+------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> exit
Bye
[root@xinnet5519 mysql]# ll
[root@xinnet5519 data]# cd test/
[root@xinnet5519 test]# ls -all
total 8
drwxr-xr-x 2 mysql mysql 4096 Jan 17 16:49 .
drwxr-xr-x 5 mysql mysql 4096 Jan 18 16:29 ..
-rw-r--r-- 1 mysql mysql 0 Nov 23 23:28 .empty
[root@xinnet5519 test]# rm -rf .empty
[root@xinnet5519 test]# /usr/local/mysql/bin/mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.5.19-log MySQL Community Server (GPL)
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> drop database test;
Query OK, 0 rows affected (0.00 sec)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/90618/viewspace-715080/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- MySQL "ERROR 1010(HY000):Error dropping database(canMySqlErrorDatabase
- ERROR 1010 (HY000): Error dropping databaseErrorDatabase
- MYSQL ERROR 2003 (HY000) CanMySqlError
- ERROR 1290 (HY000): The MySQL server is running withErrorMySqlServer
- MySQL5.5.19安裝圖解MySql圖解
- 【MySQL】ERROR 1878 (HY000): Temporary file write failure.MySqlErrorAI
- Mysql連線錯誤ERROR 2003 (HY000)MySqlError
- 【Mysql】ERROR 1872 (HY000): Slave failed to initialize relay log infoMySqlErrorAI
- MySQL ERROR 1031 (HY000) at line 33: Table storage engine forMySqlError
- MySQL報錯ERROR 2013 (HY000): Lost connection to MySQL server during queryMySqlErrorServer
- MySQL5.6:mysql_secure_installation 報錯ERROR 2002 (HY000)MySqlError
- MySQL 使用 show tables 時出現 ERROR 1449 (HY000) 問題MySqlError
- mysql執行sql指令碼報錯ERROR 1366 (HY000) 解決MySql指令碼Error
- 【MySQL】ERROR 1005 (HY000): Can't create table' (errno: 150)MySqlError
- MySQL報錯'ERROR 2002 (HY000): Can't connect to local MySQL server through'MySqlErrorServer
- ERROR 2002(HY000):Can't connect to local MySQL socket '/tmp/mysql.sock'ErrorMySql
- MySQL5.7叢集(MGR)啟動報ERROR 3092 (HY000)MySqlError
- ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables optErrorMySqlServer
- 【MySQL】ERROR 1290 (HY000): --secure-file-priv--匯出報錯MySqlError
- mysql 5.6.25報錯ERROR 1372 (HY000): Password hash 的一點思考MySqlError
- MySQL 報錯 ERROR 1290 (HY000): running with the --secure-file-privMySqlError
- 阿里雲mysql遠端登入報ERROR 2027(HY000)阿里MySqlError
- MySQL案例02:ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGESMySqlError
- mysql資料匯入問題處理(ERROR 1418 (HY000))MySqlError
- MySQL ERROR 1366(HY000):Incorrect string value:''for column''at row 1解決方案MySqlError
- ERROR 1548 (HY000): Cannot load from mysql.proc. The table is probably corruptedErrorMySql
- MySQL 亂碼實戰解決ERROR 1366 (HY000): Incorrect string value: 'MySqlError
- ERROR 1524 (HY000): Plugin is not loadedErrorPlugin
- ERROR 2026 (HY000): SSL connection error: unknown error numberError
- mysql無法建立儲存過程問題 ERROR 1307 (HY000)MySql儲存過程Error
- ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization paErrorMySqlServer
- MySQL建立使用者報錯 ERROR 1396 (HY000): Operation CREATE USER failed for 'afei'@'%'MySqlErrorAI
- MySQL 5.7 建立使用者報錯 ERROR 1805 (HY000): Column count of mysql.user is wrongMySqlError
- ERROR 1114 (HY000) The table '' is fullError
- ERROR 2002 (HY000): Can't connect server socket /tmp/mysql.sockErrorServerMySql
- MySQL遠端連線ERROR 2003 (HY000) Cant connect to MySQL server on (10060)MySqlErrorServer
- ERROR 1290 (HY000) 解決辦法Error
- MySQL 5.7向表匯入資料包錯"ERROR 13 (HY000): Can't get stat of"MySqlError