How to create database and user in mySQL database

This article shows you how to create databases and users in the mySQL database, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

MySQL database systems can support many different databases, and typically, one database is required for each application. In the Book-O-Rama example, the database is named books.

Creating a database is the easiest part. At the mySQL command prompt, enter the following command:

MySQL > create datebase dbname

You should use the desired database name to "dbname" the string. In the Book-O-Rama example, we will create a database called books. You should see a response like this (execution time varies from machine to machine):

Query ok,1 row affected (0.0 sec)

If the appeal field appears, it means everything is fine. If you don't get a response, be sure to enter a semicolon after the above command line, which will tell mySQL that the command has been entered and it's time to execute the command.

The above is how to create databases and users in the mySQL database. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.