第1步:下载如下图安装包
第2步:解压mysql压缩包,然后进入解压后的安装包,将my-default.ini复制一份,并改名为my.ini(自己命名),把下面内容复制到my.ini,并保存,这里把网上大神的和我的都贴出来了,我没有用大神的,直接修改我自己的ini最后也可以成功。
第一段脚本是网上大神的,与我的ini打开看到的不一样
[client]
port=3306
default-character-set=utf8
#客户端字符类型,与服务端一致就行,建议utf8
[mysqld]
port=3306
character_set_server=utf8
#服务端字符类型,建议utf8
basedir=D:\mysql-5.6.16-win32
#解压根目录(skip-grant-tables,更改密码,加skip-grant-tables,停服务,起服务,update ,停服务,注skip-grant-tables,起服务)
datadir=D:\mysql-5.6.16-win32\data
#skip-grant-tables
#解压根目录\data
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin]
D:\mysql-5.6.16-win32\bin\mysqld.exe
#解压根目录\bin\mysqld.exe
第二段脚本我自己的
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
# These are commonly set, remove the # and set as required.
basedir = D:\mysql-advanced-5.6.25-winx64
datadir = D:\mysql-advanced-5.6.25-winx64\data
port = 3306
character_set_server=utf8
# server_id = .....
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
修改自己的配置basedir,datadir,和最后一项(我不知道最后一项是哪一项,我没有修改)
第3步:加环境变量
path:中加入:D:\mysql-advanced-5.6.25-winx64\bin;
第4步:将mysql加入windows系统服务
cmd中cd 到mysql解压目录的bin目录下,用下面命令安装:
mysqld install MySQL --defaults-file=“D:\mysql-5.6.16-win32\my.ini”
提示服务安装成功
注意:移除服务命令:mysqld remove
第5步:启动mysql服务
命令:net start mysql
第6步:修改root账号的密码
打开cmd输入mysql -uroot,登录mysql控制台
show databases; 显示数据库列表
use mysql; 选择数据库
这条命令完成密码修改:
update user set Password=PASSWORD(“123456”) where User=“root”;
flush privileges;
此时密码被改为:123456
退出控制台
exit
第7步:此时cmd中输入mysql 还能进去,但是权限不一样;
可以试一下:show databases;比较一下
第8步:此时的mysql 已经可以用了,为了方便连接:
桌面快捷方式:桌面右键->新建->快捷方式
对象位置输入:c:\Windows\System32\cmd.exe
右键单击刚才建立的快捷方式->属性->把目标一栏修改成MySQL启动参数:
C:\Windows\System32\cmd.exe “D:\mysql-5.6.16-win32\bin” /k mysql -uroot -p123456 databasename
3)修改完成后保存,直接双击快捷方式即可连接到名为databasename的数据库