MySql备忘录

1.解压zip，并将bin目录配置环境变量
2.修改ini配置文件

# These are commonly set, remove the # and set as required.
basedir = D:\mysql-5.6.34-winx64
datadir = D:\mysql-5.6.34-winx64\data
character-ser-server = utf8
# port = .....
# server_id = .....

3.安装mysql：mysqld install（mysqld remove）
4.开启服务：net start mysql（net stop mysql）
5.登陆mysql，操作数据库mysql -uroot -proot -h127.0.0.1 -P3306
6.退出mysql，exit;quit;\q