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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ERROR 1290 (HY000): The MySQL server is running withErrorMySqlServer
- Mysql連線錯誤ERROR 2003 (HY000)MySqlError
- 【MySQL】ERROR 1878 (HY000): Temporary file write failure.MySqlErrorAI
- MySQL報錯ERROR 2013 (HY000): Lost connection to MySQL server during queryMySqlErrorServer
- ERROR 2013 (HY000): Lost connection to MySQL server at 'reading authorization paErrorMySqlServer
- ERROR 2026 (HY000): SSL connection error: unknown error numberError
- 阿里雲mysql遠端登入報ERROR 2027(HY000)阿里MySqlError
- MySQL 報錯 ERROR 1290 (HY000): running with the --secure-file-privMySqlError
- ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables optErrorMySqlServer
- ERROR 1114 (HY000) The table '' is fullError
- 【MySQL】ERROR 1290 (HY000): --secure-file-priv--匯出報錯MySqlError
- MySQL5.7叢集(MGR)啟動報ERROR 3092 (HY000)MySqlError
- MySQL案例02:ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGESMySqlError
- MySQL 使用 show tables 時出現 ERROR 1449 (HY000) 問題MySqlError
- mysql 5.6.25報錯ERROR 1372 (HY000): Password hash 的一點思考MySqlError
- mysql無法建立儲存過程問題 ERROR 1307 (HY000)MySql儲存過程Error
- Error!: SQLSTATE[HY000] [2002] Connection refusedErrorSQL
- MySQL 5.7 建立使用者報錯 ERROR 1805 (HY000): Column count of mysql.user is wrongMySqlError
- Centos7-mysql執行報錯ERROR1820(HY000):YoumustresetyourpasswordusingALTERUSERstatementbeforeexecutingthisstatement.CentOSMySqlError
- Linux:ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannLinuxErrorMySqlServer
- ERROR 1290 (HY000) 解決辦法Error
- MySQL建立使用者報錯 ERROR 1396 (HY000): Operation CREATE USER failed for 'afei'@'%'MySqlErrorAI
- 解決ERROR 1030 (HY000): Got error 168 from storage engine apparmorErrorGoAPP
- mysql 8 報錯 ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repositoryMySqlErrorAIStruct
- mysql錯誤詳解(1819):ERROR 1819 (HY000): Your password does not satisfy the current policy requirementsMySqlErrorUIREM
- linux下連線mysql報錯ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysqLinuxMySqlErrorServer
- ERROR 1786 (HY000): Statement violates GTID consistency: CREATE TABLE ... SELECTError
- SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-preparedSQLError
- mysql 報錯:ERROR 1366 (HY000): Incorrect string value: ‘\xD5\xC5\xC8\xFD‘ for column ‘name‘ at row 1MySqlError
- ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAError
- mysql Unknown error 1054MySqlError
- KBJ1010-ASEMI開關電源專用KBJ1010
- KBPC1010-ASEMI新能源專用方橋KBPC1010
- MySQL error 錯 誤 碼MySqlError
- 建立xtrbackup備份使用者 ERROR 1819 (HY000): Your password does not satisfy the current policy requirementsErrorUIREM
- MySQL error log和bin logMySqlError
- Dr.Elephant mysql connection errorMySqlError
- MySQL ERROR 1040: Too many connectionsMySqlError
- mysql-SQL Error: 1205, SQLState: 41000MySqlError