mysql官网:https://dev.mysql.com/
mysql下载:https://dev.mysql.com/downloads/
5.6.x版本解压版安装说明文档:
https://dev.mysql.com/doc/refman/5.6/en/windows-install-archive.html
mysql5.6.46下载地址:https://dev.mysql.com/downloads/mysql/5.6.html#downloads
解压安装
配置:
1,复制my-default.ini改名为my.ini,配置如下信息
[mysql]
default-character-set=utf8
#设置3306端口
[Client]
port = 3306
# 设置客户端默认字符集
default-character-set=utf8
[mysqld]
port = 3306
# 设置安装目录
basedir = E:\ProgramFiles\mysql-5.6.46-winx64
# 设置数据存放目录
datadir = E:\ProgramFiles\mysql-5.6.46-winx64\data
# 设置最大连接数
max_connections=200
# 设置服务端字符集
character-set-server=utf8
2,初始化mysql
mysqld --initialize
该E:\ProgramFiles\mysql-5.6.46-winx64\data目录增加这几个文件
3,设置mysql为windows服务:Starting MySQL as a Windows Service
mysqld -install
4,启动mysql
net start mysql
删除data目录下的ib_logfile*和ibdata1文件,再次执行
如果还不行看下权限问题
5,登录mysql
1,直接输入mysql 然后回车
2,mysql -u root -p然后回车
3,上面两种方式都进不去,在E:\ProgramFiles\mysql-5.6.46-winx64\data\WIN8-hyc.err中找临时登录密码
xxxx.err中搜索 [Note] A temporary password is generated for root@localhost:
6,修改密码 用户名和密码都为root
set password = password(‘root’);
mysql> use mysql
默认:
修改后:
另:Host是不一样的
登录mysql
1,mysql直接回车
2,mysql -u root -p 回车输入密码
远程登录错误:
ERROR 1130 (HY000): Host ‘windows10.microdone.cn’ is not allowed to connect to t
his MySQL server
授权远程登录:
GRANT ALL PRIVILEGES ON . TO ‘user’@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘root’ WITH GRANT OPTION;
flush privileges;
启动停止服务命令:
net start mysql
net stop mysql