Mysql安装下载

曾经终败给现在 2023-02-19 06:30 8阅读 0赞

## 一、下载 ##

1.  下载地址[https://dev.mysql.com/downloads/mysql/][https_dev.mysql.com_downloads_mysql]
2.  选择最新的8.0版本![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTE4MzU0Mw_size_16_color_FFFFFF_t_70][]

## 三、安装 ##

1.mysql安装分为自动安装.msi和手动安装zip，手动安装需要设置环境变量，我们这里使用zip进行手动安装。

2.解压后设置环境变量，将D:\\Program-file\\soft\\java-manage\\mysql-8.0.20-winx64\\mysql-8.0.20-winx64\\bin放入path系统环境变量中。![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTE4MzU0Mw_size_16_color_FFFFFF_t_70 1][]

3.配置完环境变量后，在D:\\Program-file\\soft\\java-manage\\mysql-8.0.20-winx64\\mysql-8.0.20-winx64目录下创建data文件夹和mysql.ini配置文件

4.mysql.ini配置文件内容

[mysql]
    
    # 设置mysql客户端默认字符集
    default-character-set=utf8 
    
    [mysqld]
    
    #设置3306端口
    port = 3306 
    
    # 设置mysql的安装目录
    basedir=D:\Program-file\soft\java-manage\mysql-8.0.20-winx64\mysql-8.0.20-winx64
    
    # 设置mysql数据库的数据的存放目录
    datadir=D:\Program-file\soft\java-manage\mysql-8.0.20-winx64\mysql-8.0.20-winx64\data
    
    # 允许最大连接数
    max_connections=200
    
    # 服务端使用的字符集默认为8比特编码的latin1字符集
    character-set-server=utf8
    
    # 创建新表时将使用的默认存储引擎
    default-storage-engine=INNODB

5.进入cmd，输入mysqld --initialize-insecure --user=mysql，由于找不到vcruntime140\_1.dll,无法继续执行代码则下载vcruntime140\_1.dll文件，地址：[https://cn.dll-files.com/vcruntime140\_1.dll.html][https_cn.dll-files.com_vcruntime140_1.dll.html]将文件放入C:\\Windows\\System32下，如果是32位版本的`vcruntime140_1.dll`需要复制到`C:\Windows\SysWOW64`下

6.输入mysqld install，如果报错mysql Install/Remove of the Service Denied!则使用管理员身份打开cmd，再输入mysqld install命令即可。

7.使用net start mysql启动mysql服务器。第一次使用mysql是没有密码的。使用mysql -uroot -p进入MySQL

![20200619150736870.png][]![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTE4MzU0Mw_size_16_color_FFFFFF_t_70 2][]

8.修改密码，退出mysql，在cmd中输入mysqladmin -u root -p password

![20200619151206634.png][]

至此，mysql数据库已安装完毕。

三、图形化界面管理

1.SQLyog下载：[https://sqlyog.en.softonic.com/][https_sqlyog.en.softonic.com]

2.连接数据库![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTE4MzU0Mw_size_16_color_FFFFFF_t_70 3][]

[https_dev.mysql.com_downloads_mysql]: https://dev.mysql.com/downloads/mysql/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTE4MzU0Mw_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200619144621817.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTE4MzU0Mw==,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTE4MzU0Mw_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20200619145213342.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTE4MzU0Mw==,size_16,color_FFFFFF,t_70
[https_cn.dll-files.com_vcruntime140_1.dll.html]: https://cn.dll-files.com/vcruntime140_1.dll.html
[20200619150736870.png]: https://img-blog.csdnimg.cn/20200619150736870.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTE4MzU0Mw_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20200619150954720.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTE4MzU0Mw==,size_16,color_FFFFFF,t_70
[20200619151206634.png]: https://img-blog.csdnimg.cn/20200619151206634.png
[https_sqlyog.en.softonic.com]: https://sqlyog.en.softonic.com/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTE4MzU0Mw_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20200619153636136.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTE4MzU0Mw==,size_16,color_FFFFFF,t_70