MYSQL

MYSQL安装完毕

配置

命令行登录

创建数据库

mysql> create database stusys;

Query OK, 1 row affected (0.01 sec)

mysql> show databases;

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

| Database |

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

| information_schema |

| mysql |

| performance_schema |

| stusys |

| sys |

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

5 rows in set (0.00 sec)

查看数据库

mysql> show databases;

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

| Database |

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

| information_schema |

| mysql |

| performance_schema |

| sys |

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

4 rows in set (0.01 sec)

选择数据库

mysql> use stusys;

Database changed

修改数据库

mysql> alter database stusys

-> default character set gb2312

-> default collate gb2312_chinese_ci;

删除数据库

mysql> drop database stusys;