Solution to schema deletion failure in mysql in mac environment _ MySQL

Solution to schema deletion failure in mysql in mac environment bitsCN.com

Solution to schema deletion failure of mysql in mac environment

First, describe the problem environment. I installed mysql + workbench on a mac machine.

When deleting a database, the error dropping database cant rmdir./test occurs.

Google's solution is to find the test directory and delete the files under the Directory.

So I went to the test directory and found that mysql-related directories could not be found through mac search. the directory should be hidden and the results will not be displayed by default.

Later, I found the directory under usr/local/mysql/data. However, the created database directories are all set with access permissions and cannot be accessed.

Use the command line chmod command to change the test permission, remove all the files, and then delete the files in workbench.

Note: The test Directory cannot be deleted directly. only files under the test directory can be deleted. otherwise, workbench cannot find the database, and the database cannot be deleted normally.

BitsCN.com