Win7 64-bit installation MySQL Absolute Classic

Windows 7 64-bit under configure MYSQL64-bit free install version
1, the official website download Mysql-5.6.10-winx64.zip
Here you can also download http://xiazai.zol.com.cn/detail/4/33431.shtml this is a free installation version
2, decompression to D:\mysql (path of their own designation)
3, under the D:\mysql new My.ini configuration file, the contents are as follows:

---------Profile starts--------

[Mysqld]
# set Basedir to your installation path
Basedir=d:\mysql
# set DataDir to the location of your data directory
Datadir=d:/mydata/data

---------configuration file End---------

Basedir unzip the path for your MySQL compressed package, datadir the path to the database file you have stored.

Then go to your MySQL unzip directory, install MySQL for system service, start running input cmd Press ENTER Note If it is Win7 need to search to cmd right-click to run with Administrator rights

Then type in the following command

First Enter D: Press ENTER to enter the D-Tray directory

Then in the input CD D:\mysql\bin

Then enter the Mysqld--install
If you are prompted for Service successfully installed. Represents success

Last input net start MySQL start MySQL service

After successful startup, you will be prompted:

The MySQL service is starting.
MySQL Service has started successfully

If you report 1067 errors, most of the time you specified a new database directory (in this case: E:\mydata\data), but did not copy the files inside the original e:/mysql/data to the new directory. Also pay attention to whether your system is 32-bit or 64-bit, to download the corresponding version.
If 2 error is reported, Mysqld-nt--install must be executed under the path specified by MySQL, such as X:\mysql\bin;

Remove Service for mysqld remove

The command to stop MySQL is as follows:

net stop MySQL

4. Add the following to the Windows environment variable (easy to execute command line command)
New Mysql_home= "E:\mysql",
Add%mysql_home%\bin to Path

5, the password to change the root of 111111 (5.1 is so executed, 5.6 after execution no effect, password or empty)
C:>mysql-uroot
mysql> UPDATE user SET Password=password ("111111") WHERE user= ' root ';
mysql> FLUSH privileges;
Mysql> QUIT