MYSQL ZIP Installation free version configuration steps and graphical management tool mysql ES3en

1. Unpack ZIP packages and configurations

First, extract mysql-5.5.25-ES5en64.zip into D:/ mysql-5.5.25 directory, then copy my-ES10en.ini (of course, you can choose other ini configuration files as appropriate) and rename it my.ini.

# System base directory 
basedir= D:/mysql-5.5.25
# User data directory 
datadir= D:/mysql-5.5.25/data
# Character set 
character-set-server = utf8
 in [client] Segment added: 
default-character-set = utf8

MySQL Install Windows services

2.1 installation
Locate the bin directory in the mysql installation directory and execute mysqld. The steps are as follows:

Open the cmd command prompt (the win+r keyboard brings up the run window, or click the "Run button" in the windows menu and enter cmd). Then type and execute the following command:

Enter d: and press enter
Input: D: \ mysql - 5.5.25 \ bin > mysqld? install, then press enter

windows service installed successfully Service successfully installed.

2.2 Configure environment variables
Add the bin path of MySQL to the environment variable path, and you can execute the mysql command directly at run time. The steps are as follows:

The computer/my computer > Right-click to select the property wok > Select the high-level, environment variable wok > Double-click the path variable in system variable to add the bin directory path of MySQL first. Such as:

D:\mysql-5.5.25\bin>

2.3 Start MySQL Service
Enter the following command:

D:\mysql-5.5.25-winx64\bin> net start MySQL

The service has started successfully.

The attached:

 The installation 1 a mysql Windows Command for service: mysqld  � install MySQL 
 remove mysql Services: mysqld  � remove MySQL
 Start the mysql Command for service: net start MySQL
 stop mysql Command for service: net stop MySQL
 will mysql Default system user root Change the empty password to 12345 The command: mysqladmin -u root password "12345"

3. Download graphical management tools

https://www.ofstack.com/database/29494.html

mysql-workbench Installation tutorial

https://www.ofstack.com/article/48284.htm

Download and install.