Mysql 复习

1、my.ini ：mysql 配置文件

[client]
#password    = your_password
port        = 3306
socket        = /tmp/mysql.sock

[mysql]

default-character-set=utf8

[mysqld] //mysql服务器配置
port        = 3306
socket        = /tmp/mysql.sock
key_buffer_size = 16M
max_allowed_packet = 1M
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
basedir=D:/wamp/bin/mysql/mysql5.6.17
log-error=D:/wamp/logs/mysql.log
datadir=D:/wamp/bin/mysql/mysql5.6.17/data

2、prompt 提示符的修改

\d 为提示符默认为：当前使用的数据库

3、数据库的创建

其中CHARACTER SET = utf8 这样就能存储中文字符了

ALTER 修改数据库配置