1.下载最新版:[https://pan.baidu.com/s/16TxyAV-60P3JTTxoyluvvw][https_pan.baidu.com_s_16TxyAV-60P3JTTxoyluvvw]
2.解压压缩包,注意存放的文件夹最好不要带有空格,可以直接解压到磁盘根目录:
![20191214162556993.png][]
3.打开解压后的文件夹,新建一个data文件夹和一个my.ini文件:
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70][]
4.用记事本打开my.ini,内容如下:
1. `[mysqld]`
2. `# 设置3306端口`
3. `port=3306`
4. `# 设置mysql的安装目录`
5. `basedir=D:\\mysql-8.0.18-winx64`
6. `# 设置mysql数据库的数据的存放目录`
7. `datadir=D:\\mysql-8.0.18-winx64\\data`
8. `# 允许最大连接数`
9. `max_connections=200`
10. `# 允许连接失败的次数。这是为了防止有人从该主机试图攻击数据库系统`
11. `max_connect_errors=10`
12. `# 服务端使用的字符集默认为UTF8`
13. `character-set-server=utf8`
14. `# 创建新表时将使用的默认存储引擎`
15. `default-storage-engine=INNODB`
16. `[mysql]`
17. `# 设置mysql客户端默认字符集`
18. `default-character-set=utf8`
19. `[client]`
20. `# 设置mysql客户端连接服务端时默认使用的端口`
21. `port=3306`
22. `default-character-set=utf8`
5.右键【此电脑】>> 【属性】>> 【高级系统设置】>> 【环境变量】>> 【新建系统变量】,设置为MySQL解压路径:
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 1][]
6.在系统path末尾追加,MySql的bin目录%MYSQL\_HOME%\\bin,(注意:末尾如果没有分号,要加个分号隔开):
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 2][]
7.使用管理员身份打开cmd,跳转到mysql的bin目录:
mysqld --initialize --console
8.出现错误:
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 3][]
9.解决办法:
1.下载vs2005支持库链接: https://pan.baidu.com/s/1GMn5\_ghBDJtwPq-hEeHt7Q 提取码: 2s63,安装后再次尝试mysqld --initialize --console,如果失败,尝试方法2.
2.按照如图标注的数字顺序,依次安装这些包:[https://pan.baidu.com/s/1bLbhRWomRoN7jMtyVUrf0w][https_pan.baidu.com_s_1bLbhRWomRoN7jMtyVUrf0w]
备注:1.第二个exe文件,在我这里点了一闪而过。 2.中途要经历几次重启。
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 4][]
10.再次运行【第8步】初始化命令 ,得到随机密码,一定要把密码记下来arfh:lk6y?Es:
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 5][]
11.继续安装服务,并启动之:
1. `# 安装服务`
2. `mysqld -install`
3. `# 启动服务`
4. `net start mysql`
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 6][]
12.登录并修改密码:
1. `# 登录`
2. `mysql -u root -p`
3. `# 修改密码`
4. `alter user root@localhost identified by '你的密码'`
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 7][]
13.授权远程登录:
1. `# 切换到mysql数据库`
2. `use mysql;`
3. `# 查看用户表;`
4. `select user, host from user;`
5. `# 将其中root用户的host更新成'%'`
6. `update user set host = '%' where user = 'root';`
7. `# 立即生效`
8. `flush privileges;`
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 8][]
[https_pan.baidu.com_s_16TxyAV-60P3JTTxoyluvvw]: https://pan.baidu.com/s/16TxyAV-60P3JTTxoyluvvw
[20191214162556993.png]: /images/1610258519056.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70]: /images/1610258493912.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 1]: /images/1610258459944.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 2]: /images/1610258428929.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 3]: /images/1610258391625.png
[https_pan.baidu.com_s_1bLbhRWomRoN7jMtyVUrf0w]: https://pan.baidu.com/s/1bLbhRWomRoN7jMtyVUrf0w
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 4]: /images/1610258361161.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 5]: /images/1610258333361.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 6]: /images/1610258302674.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 7]: /images/1610258274483.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L21pbGticm90aGVyMTk4OA_size_16_color_FFFFFF_t_70 8]: /images/1610258245494.png