![]() Now, click on the Databases, you should see all the databases in the following page: You will be redirected to the PhpMyAdmin dashboard in the following page: Provide your MySQL root username, password and click on the Go button. Mysql -u root -proot-password -e "drop database test2db" Delete MySQL Database with PhpMyAdminįirst, open your web browser and access the PhpMyAdmin web UI. You can also remove the MySQL database named test2db without log into the MySQL console as shown below: Next, exit from the MySQL console with the following command: Next, delete the MySQL database named test1db from the above list with the following command: Next, list all available databases with the following command: Type '\c' to clear the current input statement. Other names may be trademarks of their respective Oracle is a registered trademark of Oracle Corporation and/or itsĪffiliates. Once login, you should see the following output: mysql: Using a password on the command line interface can be insecure. You can also drop the MySQL database after log into the MySQL console.įirst, log into the MySQL console with root user with the following command: You should see the following output: Dropping the database is potentially a very bad thing to do.Īny data stored in the database will be destroyed.ĭo you really want to drop the 'testdb' database yĭelete MySQL Database within MySQL Console ![]() Mysqladmin -u root -proot-password drop testdb Next, delete the database named testdb from the above list by running the following command: You should see the following output: mysqlshow: Using a password on the command line interface can be insecure. Mysqladmin is a MySQL command-line utility that can be used to perform some basic MySQL tasks including, creating and deleting databases, checking MySQL processes, Setting root password and many more.īefore deleting any database, list all available databases in your system with the following command:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |