Shulou(Shulou.com)06/01 Report--

The main purpose of this article is to tell you briefly about how the Windows10 system mysql 8.0.12 decompressed version is installed and configured. You can check the relevant professional terms on the Internet or find some related books to supplement it. We will not dabble here, and let's go straight to the topic. I hope this article on how to install and configure the Windows10 system mysql 8.0.12 decompressed version can bring you some practical help.

12345678910111213141516171819202 "Database server configuration item [mysqld] # database path basedir=d:\\ programs\\ mysql\\ mysql-8.0.12-winx64# data path datadir=d:\\ programs\\ mysql\\ data# port number default character set character-set-server=utf8mb4# storage lead default-storage-engine=innodb # client configuration item [mysql] # default character set default-character-set=utf8mb4 # connection client configuration item [client] the default-character-set=utf8mb4Windows10 system mysql 8.0.12 decompressed version is how to install and configure, so let's stop here. If you want to know about other related issues, you can continue to follow our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

Installation environment: window10 Home Edition, 64-bit

Database: mysql8.0.12 64-bit

Installation method: compressed package installation

Installation steps:

1. Download the installation package

Download from mysql's official website

Directly click on the bottom "no thanks, just start my download." You can start downloading the compressed package after the download is successful

Note: when installing the database, the logged in user must have administrator privileges.

2. Unpack the package and put it in the directory where you will install it.

The decompressed file structure is shown in the figure:

From the unzipped document structure, we can see that there is no my.ini configuration file, here you need to create your own my.ini configuration file.

3. Create a my.ini configuration file

?

Once the configuration file is created, you can proceed to the next step of installation.

4. Initialize mysql with operation instructions

Open the terminal and go to the bin directory under the data installation path:

Enter the command "mysqld-initialize-console" in the terminal and press enter to complete the initialization:

Note: do not close the window after initialization, because the password of the root user will be generated here, and the "p=brffhdg4t5" in the figure is a random password.

Of course, there is another initialization method that does not generate random passwords, but you also need to set the password before officially using the database. The initialization instruction is "mysqld-initialize-insecure-console". When initializing the database with no random password, the first login data needs to use "mysql-u root-skip-password", that is, skip password verification.

5. Database service installation

Once the database is initialized, the data can be registered as a windows service so that the database can be started as a service. Open the terminal and go to the bin directory under the data installation path, as shown in figure 1 in step 4.

Use the command "mysqld-install" to complete the installation of the service:

Note: when registering the service, it must be performed as an administrator, otherwise it will be rejected when installing the service.

At the same time, you can use the directive "mysqld-remove" to remove registered services.

In fact, the complete instruction for registering the service is "mysqld-install service name". If the service name is not written, it defaults to "mysql". The service removal instruction is also "mysqld-remove service name", and the default value is "mysql".

6. Service startup

Use the command "net start mysql" in the terminal to start the database service:

Verify whether the service has been started, and try to log in to the database on the terminal page. The password you need to enter here is the random password generated by the system during initialization in step 4, figure 2. You can enter it:

Landing is successful! Before executing the instruction, the system forces you to change the random password at initialization:

Using the command "alter user 'root'@'localhost' identified by' my_new_psd';", press enter:

After changing the password, you can use the database normally!

Use client tools to connect to the database:

Windows10 system mysql 8.0.12 decompressed version is how to install the configuration of the first to tell you here, for other related issues you want to know can continue to follow our industry information. Our section will capture some industry news and professional knowledge to share with you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.