mysql-8.0.21-winx64 安装

￡神魔★判官ぃ 2022-12-08 01:34 163阅读 0赞

MySQL windows 64 bits 下载文件地址  
[https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.21-winx64.zip][https_cdn.mysql.com_Downloads_MySQL-8.0_mysql-8.0.21-winx64.zip]

**1、解压**

**2、初始化脚本 my.ini，放到 mysql 的解压目录，与 bin 目录平级**

# 设置3306端口
    port=3306
    # 设置mysql的安装目录
    basedir=E:\install\mysql8\product
    # 设置mysql数据库的数据的存放目录
    #datadir=E:\install\mysql8\data
    # 允许最大连接数
    max_connections=200
    # 允许连接失败的次数。
    max_connect_errors=10
    # 服务端使用的字符集默认为utf8mb4
    character-set-server=utf8mb4
    # 创建新表时将使用的默认存储引擎
    default-storage-engine=INNODB
    # 默认使用“mysql_native_password”插件认证
    #mysql_native_password
    default_authentication_plugin=mysql_native_password
    [mysql]
    # 设置mysql客户端默认字符集
    default-character-set=utf8mb4
    [client]
    # 设置mysql客户端连接服务端时默认使用的端口
    port=3306
    default-character-set=utf8mb4

**3、管理员方式启动 CMD**

**4、在 mysql 安装目录的 bin 目录，执行安装命令**

mysqld --initialize --console

本地报错

![format_png][]

我从脚本之家下了这个 dll 文件  
[http://xz6.jb51.net:81/dll/2019/vcruntime140\_1\_jb51.rar][http_xz6.jb51.net_81_dll_2019_vcruntime140_1_jb51.rar]  
将 vcruntime140\_1.dll 文件放到 C:\\Windows\\System32 目录下

继续执行安装指令

mysqld --initialize --console

**5、安装成功，生成 root 用户的临时密码**

![format_png 1][]

**6、安装服务**

mysqld --install

![format_png 2][]  
已存在需要删除，sc delete mysql

**7、启动服务**

net start mysql

![format_png 3][]

**8、连接 mysql，修改密码**

mysql -u root -p

输入临时密码

![format_png 4][]

**9、修改 localhost 的 root 密码**

ALTER USER 'root'@'localhost' IDENTIFIED BY 'constxiong@123';

![format_png 5][]

**10、用 navicate 连接，操作**

![format_png 6][]

--------------------

### 【Java面试题与答案】整理推荐 ###

*  [基础与语法][Link 1]
 *  [集合][Link 2]
 *  [网络编程][Link 3]
 *  [并发编程][Link 4]
 *  [Web][]
 *  [安全][Link 5]
 *  [设计模式][Link 6]
 *  [框架][Link 7]
 *  [算法与数据结构][Link 8]
 *  [异常][Link 9]
 *  [文件解析与生成][Link 10]
 *  [Linux][]
 *  [MySQL][]
 *  [Oracle][]
 *  [Redis][]
 *  [Dubbo][]

[https_cdn.mysql.com_Downloads_MySQL-8.0_mysql-8.0.21-winx64.zip]: https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.21-winx64.zip
[format_png]: /images/20221123/7c5c59c03a7d46a3a1b02cf0f7e55753.png
[http_xz6.jb51.net_81_dll_2019_vcruntime140_1_jb51.rar]: http://xz6.jb51.net:81/dll/2019/vcruntime140_1_jb51.rar
[format_png 1]: /images/20221123/0bd66fb22da2404c9faf74f7ba6d08eb.png
[format_png 2]: /images/20221123/2941f99bbc344e7b9ce0de3ce342f476.png
[format_png 3]: /images/20221123/e325a0bfec9e4cafa3591c17f62b13ef.png
[format_png 4]: /images/20221123/8ac02576a18245f1adbb0de9c22afe53.png
[format_png 5]: /images/20221123/8c9496fcb9774da28031475b8b13d698.png
[format_png 6]: /images/20221123/46217bcca9d14b609fa0bfe5d1ed2333.png
[Link 1]: https://www.javanav.com/interview/93b0069472fd479393006c0e73043fc4.html
[Link 2]: https://www.javanav.com/interview/4147d95e693945e7a50345fd33ec817e.html
[Link 3]: https://www.javanav.com/interview/68a57ffc78de4133bb890bdd502ac418.html
[Link 4]: https://www.javanav.com/interview/36a24fa3258e45c89873f474ce914912.html
[Web]: https://www.javanav.com/interview/4e27cb63adb440c6825a159d35cf4010.html
[Link 5]: https://www.javanav.com/interview/03affb2ce3f04fda8853f714e5764906.html
[Link 6]: https://www.javanav.com/interview/07a32a9ff17a4006a53550ce658cafed.html
[Link 7]: https://www.javanav.com/interview/5c466456e9b54ab0a749b5948e51f1d3.html
[Link 8]: https://www.javanav.com/interview/943f917041ee4f05add24539f5b861b2.html
[Link 9]: https://www.javanav.com/interview/d3f058cfc05d4c6dadd821b622e84d36.html
[Link 10]: https://www.javanav.com/interview/67a50996c28f418e83b109ea42fc3eff.html
[Linux]: https://www.javanav.com/interview/00cccb81729540d1923bd0a0ef49533a.html
[MySQL]: https://www.javanav.com/interview/d311e78502a845f1a4bb307bd6aec2b3.html
[Oracle]: https://www.javanav.com/interview/5f29e9677edf4a16be3dce30d257c9ab.html
[Redis]: https://www.javanav.com/interview/066c62b3af4d4827b2243a822c3084a9.html
[Dubbo]: https://www.javanav.com/interview/9a3e7a7740324757abaab953f7ebc455.html