mysql5.7.18.zip Installation-free version configuration tutorial (windows)

This is the installation tutorial of mysql5.7.18.zip that I used before, and I will share it with you first.

MySQL official website download address: http://www.mysql.com/downloads/

There will be several versions to choose from in this download interface.

1. MySQL Community Server community version, open source and free, but no official technical support is provided.
2. MySQL Enterprise Edition, which requires payment and can be tried for 30 days.
3. MySQL Cluster cluster version, open source and free. Several MySQL Servers can be encapsulated into one Server.
4. MySQL Cluster CGE advanced cluster edition, which requires payment.
5. MySQL Workbench (GUI TOOL) is an ER/database modeling tool designed specifically for MySQL. It is the successor of the famous database design tool DBDesigner4. MySQL Workbench is divided into two versions: community edition (MySQL Workbench OSS) and commercial edition (MySQL Workbench SE).

MySQL Community Server is open source and free, and this is the version of MySQL we usually use. It is divided into multiple versions according to different operating system platforms. Below we take the Windows platform as an example.

Select 32-bit/64-bit to start downloading

After downloading, select the address to unzip the compressed package. The location I unzipped is: D:\Program Files\mysql-5.7.18-winx64

The most important command: mysqld --initialize-insecure --user=mysql

Create a new my.ini configuration file in the folder and edit the content as follows:

[mysqld] 
 
# Set the installation directory of mysql basedir=D:\Program Files\mysql-5.7.18-winx64 
 
# Set the storage directory of mysql database data datadir=D:\Program Files\mysql-5.7.18-winx64\data 

Create a new data folder in the directory and clear the folder with data folder

Find cmd.exe in C:\Windows\System32 and run it as an administrator. Note that it must be run as an administrator (if you do not run it as an administrator, an error will occur due to insufficient permissions: Install/Remove of the Service Denied!)

Enter the bin directory (must be in the bin directory)

Execute this statement in the bin directory

After completion, directly install mysqld

service successfully installed indicates that the installation is successful

After installation, you need to enable the service:

Enter net start mysql to start the service, and it will show that the service has been started successfully.

Type mysql -u root -p to log in. You will be asked to enter a password. If you do not have a password for the first time, just press Enter.

So far the login is successful!

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.