"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