Configure mysql5.6.16 without installation in win7 64-bit System

Since the machine has orcale and does not want to install mysql again, there will be a free installation, and it will take a little effort to complete the competition!

1. Download a version without Installation

I put in Baidu network disk, here can not put such a large file: http://pan.baidu.com/s/1jG2ulSi

2. Configure the my. ini file

Decompress the downloaded file and copy it to the location where you want to put it. You 'd better rename the file with a simple name;

Open the decompressed folder, which has a file: my-default.ini

Copy the file, name it my. ini, and copy the following content (Note: change the path to your own)

# The following options will be passed to all MySQL clients [client] # password = your_passwordport = 3306 [mysql] # set The character set default-character-set = utf8 # The mysql server [mysqld] port = 3306 # Set the mysql installation directory basedir = D: \ dev_soft \ mysql64 # Set the mysql database data storage directory, which must be data or \ xxx-datadatadir = D: \ dev_soft \ mysql64 \ data # Set character_set_server = utf8

3. Install the service

You can also configure environment variables or enter the bin folder in the mysql directory.

A. Configure MYSQL Environment Variables
New system variable MYSQL_HOME: D: \ dev \ mysql
Add:; % MYSQL_HOME % \ bin at the end of the PATH variable
Save it.

B. Go to cmd.

mysqld --install mysql5 --defaults-file=D:\dev_soft\mysql64\my.ini 

mysqld --install mysql5

C. Start the service

net stop mysql5  

The rest is to operate the database!