一、从官网下载
![MySQL Community Downloads](https://cdn.saiita.com.cn/wp-content/uploads/2022/10/1664896789-image.png?x-oss-process=image/interlace,1/quality,Q_95)
![No thanks, just start my download.](https://cdn.saiita.com.cn/wp-content/uploads/2022/10/1664896810-image.png?x-oss-process=image/interlace,1/quality,Q_95)
二、安装MySQL
用管理员身份打开Windows PowerShell
进入MySQL文件夹
e:
cd mysql
cd bin
然后输入
.mysqld --initialize --console
![Windows初始化MySQL](https://cdn.saiita.com.cn/wp-content/uploads/2022/10/1664897230-image.png?x-oss-process=image/interlace,1/quality,Q_95)
root@localhost: qx;MNy4:Q(k)
qx;MNy4:Q(k)为root初始密码
三、将MySQL设置为Windows服务
.mysqld -install
![将MySQL设置为Windows服务](https://cdn.saiita.com.cn/wp-content/uploads/2022/10/1664897242-image.png?x-oss-process=image/interlace,1/quality,Q_95)
四、启动MySQL服务
net start mysql
![Windows启动MySQL](https://cdn.saiita.com.cn/wp-content/uploads/2022/10/1664897302-image.png?x-oss-process=image/interlace,1/quality,Q_95)
五、登录MySQL
.mysql -u root -p
![Windows登陆MySQL](https://cdn.saiita.com.cn/wp-content/uploads/2022/10/1664897562-image.png?x-oss-process=image/interlace,1/quality,Q_95)
六、修改root初始密码
alter user 'root'@'localhost' identified by '想要设置的密码';
commit;
六、设置MySQL远程登陆
#创建用户
create user '用户名'@'%' identified by '密码';
#设置远程登陆
ALTER USER '用户名'@'%' IDENTIFIED WITH mysql_native_password BY '密码';
本作品采用知识共享署名-相同方式共享 4.0 国际许可协议进行许可。
暂无评论
要发表评论,您必须先 登录