MysqlDetailed tutorial on database installation and configuration

1 准备工作

1.1 下载好Mysql安装包

Download a database version from the official website,Downloading is not recommended hereMysql 8.0 Because he is unstable and there are still somebug,Most companies use it5.几的版本,这里演示的是Mysql 5.5.36版本的安装

Mysql 5.5.36Version installation package download link

1.2 删除之前安装过的MysqlDatabase and its configuration files

1.2.1 卸载之前安装过的Mysql版本

a 准备工作 关闭mysql的服务

a.1 我的电脑—>右键----->Double click to manage

a.2 点击服务和应用程序

a.3 双击服务

a.4 找到Mysql服务---->右键—>双击停止按钮

b 卸载Mysql程序

b.1 Type uninstaller in the search box,Double-click Apps & Features

b.2 Found in the Apps and Features interfaceMySQL软件,点击卸载按钮

b.3 Click the Uninstall button again,This uninstalls itMySQL程序成功了

1.2.2 Delete residual configuration files

a 删除Program Files文件夹下面的MySQL文件

Provide administrator privileges to delete(The latter deletion is also required,因为是c盘下的文件)

b 查看Program Files(x86)文件夹下面是否存在MySQL文件,If there is, it needs to be deleted

c 删除ProgramData文件夹(隐藏的项目)下面的MySQL文件

c.1 Display and double click to enterProgramData文件夹

c.2 找到MySQLfile and provide administrator rights to delete it

1.2.3 Delete the previously configured oneMySQLThe environment variable corresponding to the version

2 安装过程

2.1 双击下载好的mysql安装包(The pop-up interface needs to select Yes)

2.2 点击next按钮

2.3 勾选同意条款(许可协议中)并点击Next按钮

2.4 点击Typical按钮

2.5 点击install按钮

2.6 一直点击Next按钮(Mysql的宣传界面)

2.7 勾选Launch并点击Finish按钮(Then select Yes in the pop-up interface)

2.8 点击Next按钮

2.9 点击Next按钮

2.10 点击Next按钮

2.11 点击next按钮

2.12 点击Next按钮

2.13 点击Next按钮

2.14 点击Next按钮

2.15 Select the bottom option and setCharacter set改成utf8,然后点击Next按钮

2.16 点击Next按钮

2.17 输入rootPassword corresponding to the account and check Allow remote access

2.18 点击Execute按钮

2.19 When all the blue ticks are on,代表MySQL数据库安装成功了;点击finish按钮,就代表MysqlProgram installation is complete

3.配置环境变量

3.1 我的电脑—>右键---->双击属性

3.2 点击高级系统设置

3.3 点击环境变量

3.4 选中Path并点击编辑按钮

3.5 找到并复制MySQL对应的bin文件的路径

3.6 点击新建按钮

3.7 Paste the path you just copied(bin文件夹),Then add English at the end\

3.8 点击确定按钮

3.9 点击确定按钮

4 dosTest the interfaceMySQLwhether it can be used normally

4.1 在搜索界面输入cmd指令,然后回车

4.2 在dos界面输入mysql -uroot -p123456command and then enter

4.3 Rendering of a successful entry(代表Mysql安装并配置好了)