What are the drawbacks of using test database?

MySQLMySQLi Database

There is a database named test in the list of databases displayed by the statement SHOW DATABASES. We can use test database but the main disadvantage is that anything created in this database can be removed/changed by anyone else with access to it. To avoid this we should take permission from MySQL administrator to use a database of our own. For taking permission 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 taking permission for the tutorial database. Root is the username and localhost is the hostname with which I am connected to MySQL server.

Published on 19-Feb-2018 11:42:07