Sunday, November 6, 2011

MySQL Table Name Starts With 'test'

By default, the `mysql.db` table contains rows that permit access by any user to the `test` database and other databases with names that start with `test`.

To disable this, after a fresh MySQL installation, please run the following command:
DELETE FROM mysql.db WHERE Db LIKE 'test%';


If you find this post helpful, would you buy me a coffee?


No comments:

Post a Comment