MYSQL Zip free installation configuration steps and graphical management tools Mysql-workbench_mysql

1. Unzip the ZIP package and configuration

First, the Mysql-5.5.25-winx64.zip to the d:/mysql-5.5.25 directory, and then according to the relevant information on the Internet, will be My-large.ini (of course, depending on the situation to choose the other INI configuration file) After the copy is renamed to My.ini, on this basis, mainly in the [Mysqld] section, added:

Copy Code code as follows:

#系统基本目录
Basedir= d:/mysql-5.5.25
#用户数据目录
Datadir= D:/mysql-5.5.25/data
#字符集设置
Character-set-server = UTF8
Added in the [client] segment:
Default-character-set = UTF8

2. mysql Installation Windows service

2.1 Installation
Locate the bin directory in the MySQL installation directory and execute mysqld–install. The steps are as follows:

Open the cmd command prompt (Win+r keyboard to pull up the Run window, or click "Run Button" in the Windows menu, enter cmd back carriage). Then enter execute the following command:

Enter D:, and then return
Enter:d:\mysql-5.5.25\bin> Mysqld–install, then return

Install Windows Services successful service successfully installed.

2.2 Configuring Environment variables
Add the MySQL bin path inside the path of the environment variable, and then directly execute the MySQL command directly in the run. The steps are as follows:

Computer/My Computer –> Select Properties –> Select Advanced, environment variable –> double click the path variable in the "System variable" and add the MySQL Bin directory path to the front. Such as:

Copy Code code as follows:

D:\mysql-5.5.25\bin>

2.3 Start MySQL Service
Enter execute the following command:

Copy Code code as follows:

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

The service has started successfully.

Report:

Copy Code code as follows:

To install a MySQL Windows service command: Mysqld–install MySQL
Remove MySQL service: mysqld–remove MySQL
command to start MySQL service: net start MySQL
command to stop MySQL service: net stop MySQL
To change the MySQL default system user root's empty password to 12345: mysqladmin-u root password "12345"

3. Download graphical management tools

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

Mysql-workbench Installation Tutorial

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

Install after downloading.