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

Most people do not understand the knowledge points of this article "Linux how to build a MySQL database", so the editor summarizes the following contents, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "Linux how to build a new MySQL database" article.

Log in to MySQL first

Mysql-u root-p / / then enter your own root password and create a new database mynewdatabase under the password

Create database mynewdatabase; / / be careful not to leave out the ";" semicolon. Now a new database mynewdatabase has been created.

Let's take a look:

Show databases; can find the database called mynewdatabase that he just created in the list.

If you want to delete the database, use the command:

Drop database mynewdatabase; / / Delete the database named mynewdatabase to summarize:

/ / create the database create database [database name]; / / check the database show databases; / / delete the database drop database [database name]. The above is about "how to create a MySQL database in Linux". I believe you all have some understanding. I hope the content shared by the editor will be helpful to you. If you want to learn more about the relevant knowledge, please 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.