What are the drawbacks of using test 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.

Sai Subramanyam

Published on 19-Feb-2018 07:12:07

• Related Questions & Answers
• What are the drawbacks of database security?
• What are the benefits and drawbacks of using Canva?
• What are the drawbacks of Selenium WebDriver?
• What are the drawbacks of the arrays in Java?
• What are the drawbacks of Kerberos in information security?
• What is a database and what are the advantages of using MySQL database?
• What are the elements of database security policy?
• What are the Database recovery techniques?
• What are the database security policy?
• What are the types of threats in a database?
• What are the issues in database privacy?
• What are the levels of database security in information security?
• What are the techniques of database security in information security?
• What are MySQL database engines?
• What are the methods for expressing attribute test conditions?