MysqlWindows 10安装MysqlWindows 10安装MysqlWindows 10安装Mysql

Windows 10安装Mysql

1.官网下载https://dev.mysql.com/downloads/
2.选择[MySQL Community Server]版本进行下载，该版本是开源免费的。‌

3.将mysql安装为windows服务

4.登录mysql

# 登录mysql,密码为之前记录的密码
mysql -uroot -p

#修改密码 
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password'; 

#开放远程连接
use mysql
update user set user.Host='%' where user.User='root';
flush privileges;