Shulou(Shulou.com)05/31 Report--

This article mainly explains "mysql steps to create a database". The explanation in this article is simple and clear, easy to learn and understand. Please follow the ideas of Xiaobian and study and learn "mysql steps to create a database" together.

[root@www ~]# mysql -u root -p

Enter password: create database vbirddb; grant all privileges on vbirddb.* to vbirduser@localhost

identified by 'vbirdpw' ;

Query OK, 0 rows affected (0.00 sec)

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql | select * from user where user = 'vbirduser';

#The above two commands query whether there is a vbirduser account in the system. If there is a bunch of things,

#That's how I found the account! This is done properly!

mysql> exit

Thank you for reading, the above is the "mysql steps to create a database" content, after the study of this article, I believe we have a deeper understanding of the steps to create a database mysql this problem, the specific use of the situation also needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

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.