MySQL Community Server 8.0.11 Download and installation configuration

First, download

1, choose the appropriate installation package, I download here is the latest installation package, 8.0.11, and I choose to download the decompression version of the installation version, the installation will be more troublesome.

MySQL Community Server Download Link: https://dev.mysql.com/downloads/mysql/

Click to go to the download page, scroll to the bottom, select the compressed version of the download.

2, direct download complete.

Second, installation and configuration

1. Extract the downloaded files directly to the specified directory.

2. Select "This Computer", right click, select "Properties", as shown in

3. Select the Open attribute and click Advanced System settings on the left side of the pop-up window.

4. When "Advanced system settings" is turned on, click "Environment variable (N) ..." Button.

5. Start setting environment variables.

Set the corresponding values for Mysql_home, Path, and these 2 system variables, respectively:

Mysql_home= D:\ProgramFiles\mysql-8.0.11-winx64
Path=%mysql_home%\bin

6. Create My.ini file, file code as shown below, copy my.ini file to MySQL after creation is complete
The Bin folder under the installation directory, where the path is D:\ProgramFiles\mysql-8.0.11-winx64\bin

[Client]
port=3306
Default-character-set=utf8
[Mysqld]
port=3306
Character_set_server=utf8
Basedir=%mysql_home%
Datadir=%mysql_home%\data
[Winmysqladmin]
%mysql_home%\bin\mysqld.exe

Put it under the bin directory.

7, test the installation results, go to the DOS command prompt interface, click the Start menu, select Windows System, command prompt,

After running as administrator and entering Mysqld.exe–install, after executing the command, prompt: Service successfully installed. Indicates that the installation was successful.

Mysqld.exe–install

8, initialize MySQL, create a root user with a blank password, enter mysqld--initialize-insecure at the DOS command prompt interface, execute the command, wait a minute,

The system automatically generates the corresponding data directory in the MySQL installation path and automatically creates the root user of the empty password, indicating that the initialization was successful.

Mysqld--initialize-insecure

9. Start MySQL and set the password.

(1) At the DOS command prompt interface, enter net start MySQL and start the MySQL service.

net start MySQL

(2) Then, after the service starts, because the root user you just created is a blank password, you need to set the password first, enter the following in the DOS command prompt interface.

Note that because the password for the first user is empty, the user's password is modified the next time you do not have to enter the old password after entering password:, go directly to enter.

Mysqladmin-u root-p Password Enter a new password here
Enter Password: Enter the old password here

(3) Finally, if you need to stop the MySQL service already started, execute the following command.

net stop MySQL

10. Test whether the installation is successful

MySQL Community Server 8.0.11 Download and installation configuration