Two ways to create a database under mysql

xiaoxiao2021-03-06  97

1, command creation

First log in with root user

SQL> CREATE DATABASE DATABASENAME;

2, how do you want to create a MySQL database without logging in to MySQL, and create a userbase directory in MySQL's Data directory. After connecting MySQL, show databases; you can see the UserBase library you created.

Note: Delete the database

SQL> DROP DATABASE DATABASENAME;

转载请注明原文地址:https://www.9cbs.com/read-123676.html

New Post(0)