下载mysql5.6.24绿色版百度搜都可以找到
1.主要配置如下,basedir datadir要跟安装目录一致
2.环境变量配置bin目录
3.管理员运行cmd命令行,执行:
mysqld.exe -install
net start mysql
3.mysql安装成功后需要修改管理员root密码,原默认为空
mysql –uroot –p
show databases;
use mysql;
UPDATE user SET password=PASSWORD("wsf5259177") WHERE user='root';
FLUSH PRIVILEGES;
quit;
配置mysql局域网访问
1.关闭防火墙:
2.
use mysql;
select host from user;
update user set host ='%' where user ='root';
重启服务:
net stop mysql
net start mysql