Mysql zip installation-free configuration steps and graphical management tool mysql-workbench

1. decompress the ZIP package and Configuration

First, extract mysql-5.5.25-winx64.zip to the d:/mysql-5.5.25 directory, and then according to the relevant information on the Internet, the my-large.ini (of course, you can also select another ini configuration file) copy and rename my. ini, which is added in the [mysqld] section:

Copy codeThe Code is as follows:
# Basic system directory
Basedir = D:/mysql-5.5.25
# User data directory
Datadir = D:/mysql-5.5.25/data
# Character Set settings
Character-set-server = utf8
Added the following in the [client] section:
Default-character-set = utf8

2. Install Windows Services in MySQL

2.1 installation
Find the bin directory in the mysql installation directory and execute mysqld-install. The procedure is as follows:

Open the cmd command prompt (win + r keyboard to bring up the running window, or click "run" in the windows menu, Enter cmd, and press Enter ). Run the following command:

Enter d: And press Enter.
Enter: D: \ mysql-5.5.25 \ bin> mysqld-install, and then press ENTER

The windows Service is successfully installed.

2.2 configure Environment Variables
Add the MySQL bin path in the path of the environment variable, and then you can directly execute the mysql Command during running. The procedure is as follows:

Computer/my computer-> right-click Properties-> select Advanced, Environment Variable-> double-click the path variable in "system variables" and add the bin directory path of MySQL to the beginning. For example:

Copy codeThe Code is as follows:
D: \ mysql-5.5.25 \ bin>

2.3 start the MySQL Service
Run the following command:

Copy codeThe Code is as follows:
D: \ mysql-5.5.25-winx64 \ bin> net start MySQL

The service has been started successfully.

Appendix:

Copy codeThe Code is as follows:
Install a mysql Windows service command: mysqld-install MySQL
Remove mysql service: mysqld-remove MySQL
Command for starting mysql service: net start MySQL
Command for stopping mysql service: net stop MySQL
Run the command mysqladmin-u root password "12345" to change the default mysql System User root password to 12345"

3. Download the graphical management tool

Http://www.jb51.net/database/29494.html

Mysql-workbench installation tutorial

Http://www.jb51.net/article/48284.htm

Download and install it.