"MYSQL" Mysql-5.6.19-win32 Installation-free version configuration method

"MYSQL" Mysql-5.6.19-win32 Installation-free version configuration method

1. File Download website (http://dev.mysql.com/downloads/):

Specific: Http://211.136.8.28/files/222900000004F0ED/dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.19-win32.zip

2, decompression mysql-5.6.19-win32.zip to C drive

3. Configure the path of the environment variable, add the paths to the bin in MySQL, so that the system can find the bin location

4, copy a My-default.ini, save a file My.ini, open My.ini in the last add:

#绑定IPv4和3306端口
Bind-address = 0.0.0.0
Port = 3306
Basedir=c:\mysql-5.6.19-win32
Datadir=c:\mysql-5.6.19-win32\data
max_connections=200
[MySQL]
No-beep

5. Add MySQL to the Windows service: Mysqld-install

6. Start MySQL service: net start MySQL or manually click on the MySQL service in the Windwos service

7. Enter the database: Mysql-uroot

8, modify the database login password

User MySQL;

Update user set Password=password ("pass123") where user= "root";

Flush privileges; ---refresh permissions

\q; ---exit

Appendix: References:

http://gsdhaiji-cai.iteye.com/blog/1381627 Detail

http://blog.csdn.net/super_dc/article/details/34101667

http://blog.csdn.net/fengbingyang/article/details/17149769