1. 下载安装包,这里选择压缩版mysql-5.7.16-winx64.zip:
http://dev.mysql.com/downloads/mysql/
2. 解压到安装目录,注意最好不要含有中文目录
D:ProgramMysqlDBmysql-5.7.16-winx64
3. 配置环境变量
变量名:Path
变量值: D:ProgramMysqlDBmysql-5.7.16-winx64in
4.修改配置文件my-default.ini,并重命名为my.ini,指定mysql的主目录和数据目录
注意不要使用\,要么用正斜杠/,要么用\
[client] default-character-set=utf8 [mysqld] # set basedir to your installation path basedir=D:/Program/MysqlDB/mysql-5.7.16-winx64 # set datadir to the location of your data directory datadir=D:/Program/MysqlDB/mysql-5.7.16-winx64/data default-storage-engine=INNODB character-set-server=utf8 collation-server=utf8_general_ci
5.初始化数据库
在命令行中进入“‘D:ProgramMysqlDBmysql-5.7.16-winx64in’”目录下
mysqld --defaults-file=D:ProgramMysqlDBmysql-5.7.16-winx64my.ini --initialize-insecure
6. 将mysql注册为windows服务
mysqld -install mysql
如果要移除就是
mysqld -removemysql
步骤如下:
7.修改root密码
C:Userszydev>mysql -u root mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
8.mysql服务启动和关闭
9.登录mysql,并查看字符集
mysql -u root -p
查看字符集