What are the disadvantages of using a test database?

There is a database named test in the database list displayed by the statement SHOW DATABASES. We can use the test database, but the main disadvantage is that anything created in this can be deleted/changed by anyone with access to the database. To avoid this, we should get permission from the MySQL administrator to use our own database. To obtain permission, the following command must be run -

mysql> grant all on tutorial.* to root@localhost;
Query OK, 0 rows affected (0.10 sec)

In the above command, I am getting the permissions of the tutorial database. Root is the username and localhost is the hostname I connect to the MySQL server.

The above is the detailed content of What are the disadvantages of using a test database?. For more information, please follow other related articles on the PHP Chinese website!