Solution to schema problems cannot be deleted in mysql in mac Environment

Source: Internet
Author: User
In the mac environment, mysql cannot delete the schema. The solution first describes the problem environment. I installed mysql + workbench on a mac machine. When deleting a database, the error errordroppingdatabasecantrmdir. test occurs. Google's solution is to find the test directory and put the files under the Directory

In the mac environment, mysql cannot delete the schema. The solution first describes 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 put the files under the Directory

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.