介绍

MySQL是一款数据库管理系统(DBMS),可以理解为管理数据库的软件。

而Navicat则是管理MySQL(等各种DBMS)的软件,可以建立多个MySQL的连接。

安装MySQL8.0

直接去官网下载

dev.mysql.com/downloads/m…

登录Oracle账户

19e486571bb34be0bc191af8dd5dba74~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

点击

cf9121bd52f446088231a04bbdf47203~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

点击

e2caae3afc6645f8b2ae5d3a0d4d7551~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

点击下载

这是一个安装器,里面有x64的mysql535858b28bd64e9cb0045707b7df1589~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

点击custom

82b270d20a80428a92ea9c46d2c3058a~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

选中左边的软件,点击向右的箭头,移到右边。

a17e81da988b4cf3bd18a1c12f283107~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

选中,更改安装路径到D盘

0225f58848924012b995416d1753ad99~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

de33450f06f54c049fe0f2aae15300b3~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

d1cca020147b4f3c9225efc81dcfdd87~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

点击Next,等待安装完成

c97d24edd0b348579466321c7a6a9d76~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

继续Next,完成配置


289beefbf787474793cfcfca8f12dbaa~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

289beefbf787474793cfcfca8f12dbaa~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

设置密码,继续Next

289beefbf787474793cfcfca8f12dbaa~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

配置环境变量

此电脑——右键-属性——高级系统设置

289beefbf787474793cfcfca8f12dbaa~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

环境变量

289beefbf787474793cfcfca8f12dbaa~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

打开MySQL所在文件夹,一直到bin文件夹下,然后复制地址

289beefbf787474793cfcfca8f12dbaa~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

D:\MySQL\MySQL Server 8.0\bin

找到系统变量中的Path,双击进入

289beefbf787474793cfcfca8f12dbaa~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

点击新建,把刚才的路径粘贴进去,然后点击上移,移到上方,点击确定

289beefbf787474793cfcfca8f12dbaa~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

点击确定(有三个确定,都得点击!)

更改时区(不用Java可忽略)

为什么要改?学习Java时会用到JDBC连接Mysql,会存在时区问题,要改成东八区。

到mysql文件夹下找到my.ini文件,


找到[mysqld],在下面输入default-time-zone='+8:00'保存,退出。

289beefbf787474793cfcfca8f12dbaa~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

289beefbf787474793cfcfca8f12dbaa~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

桌面左下角win标志-右键-计算机管理-服务和应用程序-服务

9dda66490849477ebae740725a3a3b58~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

找到MySQL,右键点击重新启动

9dda66490849477ebae740725a3a3b58~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

验证安装

Win+R,cmd 输入mysql -uroot -p输入密码 看到如下界面,说明安装成功!9dda66490849477ebae740725a3a3b58~tplv-73owjymdk6-jj-mark-v1_0_0_0_0_5o6Y6YeR5oqA5pyv56S-5Yy6IEAg6IuP54mna2Vpbw==_q75.webp

如果报错,可能是没有启动MySQL服务。