When deleting the MySql database, the client program and the command line controller all reported an error:

ERROR 1010 (HY000): Error dropping database (can't rmdir './db_test', errno: 39)

Solutions:

Go directly to the MySql data directory, directly delete the database corresponding file directory. Then refresh and look at the database, and you will find that the database is gone.

# rm -rf /usr/local/mysql/data/db_test

Read More:

• ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./myapp’, errno: 39)
• Error: EBUSY: resource busy or locked, rmdir ‘
• An error is reported when kettle connects Oracle database and MySQL database
• 1716438 – Error :” Failed to load database information Details: The Database connector crdb_bwquery.
• How to solve MySQL error 1049 (42000): unknown database ‘database’
• Solve the database connection failure of Discuz! Database error (1045) notconnect Forum
• MySQL error: error 1010 (HY000) when deleting database
• An error occurs when superstet connects to the Clickhouse database: error: could not load database driver: Clickhouse
• The connection pool of SSM project database cannot be connected. The project can run normally and the database cannot be connected
• The difference between hive and relational database
• How to view the version of MySQL database
• Could not create connection to database server. Attempted reconnect 3 times. Giving
• Postgressql: cannot drop the currently open database
• Navicat import local SQL file error “[MSG] finished – unsuccessfully | [err] 1046 – no database selected”
• Wamp install WordPress prompt can’t select database
• MySQL appears: ERROR 1049 (42000): Unknown database’XXX’ solution
• Solve MySQL installation error: initializing database prompts an error when installing mysql
• The problem of MySQL database connection failure errno: 1049 error
• Dm7 Dameng database dmrman reports an error OS_ pipe2_ conn_ Server open failed solution
• What is the schema in the database?