Shulou(Shulou.com)06/01 Report--

How to create and delete databases in MySQL? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

MySQL is the most popular Web development database. After installing mysql on the system, we start with database creation. In this article, we will show you how to create and delete databases in a MySQL server.

1. Create a database from the mysql prompt:

To create a database from the mysql command prompt, you first need to log in to the mysql server with administrative privileges.

# mysql-u root-pmysql > CREATE DATABASEexampledb

You can also set the default character set to utf8 with the following defined command.

Mysql > CREATE DATABASEexampledbDEFAULT CHARACTER SETutf8

2. Create a database from the system command prompt:

Using the mysqladmin command, we can create a database from the linux shell or windows command line. This is useful for queries that run automated tasks from shell or bash scripts.

# mysqladmin-u root-p createexampledb

3. Delete the database from the MySQL prompt:

To remove the database from the mysql command prompt, first log in to the mysql server with administrative privileges.

# mysql-u root-pmysql > DROP DATABASEexampledb

4. delete the database from the system command prompt:

We can also delete any database from the Linux shell or Windows command line using the mysqladmin command. This is useful for running queries from shell scripts.

# mysqladmin-u root-p drop exampledb Thank you for reading! After reading the above, do you have a general idea of how to create and delete databases in MySQL? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.