windows 安装 mysql 8.0.x

青旅半醒 2022-11-27 06:27 228阅读 0赞

### 一、下载压缩版版本 ###

[https://dev.mysql.com/downloads/windows/installer/8.0.html][https_dev.mysql.com_downloads_windows_installer_8.0.html]

### 二、解压 ###

比如我解压到目录

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70][]

### 三、安装 ###

### 用管理员身份打开cmd,进入bin目录 ###

![20200813174034151.png][]

输入安装命令mysqld -install

![20200813174228160.png][]

如上即安装成功！

### 四、**启动** ###

输入命令mysqld --initialize

![20200813174640376.png][]

执行完之后，记下初始密码

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 1][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 2][]

然后在  路径  **D:\\mysql-8.0.21-winx64** 下新建文件my.ini  ， 内容如下

[mysqld]
    basedir=D:\mysql-8.0.21-winx64
    datadir=D:\mysql-8.0.21-winx64\data
    port=3306

然后启动mysql服务

net start mysql

![20200813175116974.png][]

### 五、**配置** ###

登录MYSQL

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 3][]

修改密码

alter user 'root'@'localhost' IDENTIFIED BY '123456';

设置远程连接(更改加密方式)

use mysql; #选择数据库
    # 远程连接请将'localhost'换成'%'
    # 下面三个语句分别是：更改加密方式、更新用户密码、刷新权限
    ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;
    ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456'; 
    FLUSH PRIVILEGES;

然后试试用Navicat连接（密码是123456）

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 4][]

六、报错处理

### [Navicat 连接MySQL 8.0.11 出现2059错误][Navicat _MySQL 8.0.11 _2059] ###

[https_dev.mysql.com_downloads_windows_installer_8.0.html]: https://dev.mysql.com/downloads/windows/installer/8.0.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70]: /images/20221124/2f949513c8694d1283ac3aca91f2c3b4.png
[20200813174034151.png]: /images/20221124/7ee0a101d41a4667b02205f7c754f5f8.png
[20200813174228160.png]: /images/20221124/0855954fd7034cfc8c56d987e713a655.png
[20200813174640376.png]: /images/20221124/6cf21718eaa8423ca0469877039695fb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 1]: /images/20221124/3ff04307062148368ace5658ff3a3efa.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 2]: /images/20221124/4b28d89ce86e42f58b3b677192ae10cd.png
[20200813175116974.png]: /images/20221124/c0a00a8c2d3e471681b218b298d5635d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 3]: /images/20221124/686c56e013c6410fb722f8a70aab89d5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW4xMDc4NzY_size_16_color_FFFFFF_t_70 4]: /images/20221124/d4dc6f277e434d87b5145955c143648a.png
[Navicat _MySQL 8.0.11 _2059]: https://www.cnblogs.com/lifan1998/p/9177731.html