Creating MySQL database on Windows system_creating system database-优快云博客

本文介绍如何在Windows系统上启动MySQL服务器并创建名为“employees”的数据库。通过命令行操作，详细展示了从启动MySQL服务到创建数据库的全过程，并展示了如何查看当前系统上的所有数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Start the MySQL server by issuing the command mysqld-shareware --standalone at the prompt in c:/mysql/bin. Refer the previous session Installing MySQL on Windows for further details.
Now invoke the mysql client program by typing mysql at the prompt.
The prompt is changed to a mysql> prompt. Type:
```
create database employees;
```
(Note: The command ends with a semi-colon).
The MySQL server responds with something like:
```
Query OK, 1 row affected (0.00 sec)
```
This means that you have sucessfully created the database. Now, let's see how many databases you have on your system. Issue the following command.
```
show databases;
```
The server responds with the list of databases.
```
+----------------+
| Database       |
+----------------+
| employees      |
| mysql          |
| test           |
+----------------+
3 rows in set (0.00 sec)
```
Here we have three databases, two created by MySQL during installation and our employees database.
To come back to the DOS prompt, type quit at the mysql prompt.