Permissions for MySQL test database

By default, the rows contained in the MYSQL.DB table indicate that any user can access the database at the beginning of the test database and Test_. The value of the user field for these rows is empty, which means matching any user. This means that these databases (the test database and the database beginning with test_) can be used by default by any user, even if they do not have permissions.

Mysql.db Default settings:

In the initialized MySQL environment, the mysql.db table contains the 2-row test database-related configuration by default, causing any user to be free to manipulate the database starting with test or test_, and drop the test database directly if you want to avoid this problem.

For this phenomenon, you may need to pay attention to the following issues:
1, the formal environment do not use the test database or create a database Test_ start to store business data
2, the user's permission to test, verify, do not go to test database, which may mislead you
3. If you want to completely avoid the above problems, you can delete the data related to test mysql.db.

"Database starting with test", if you want to cancel a user's permission to test, you must add a user's record in the Test.db table, each permission is n.

Permissions for MySQL test database