

- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
- 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?
Advertisements