MySQL Free install version configuration (collation)

1. Download the MySQL free install version (unzip version).

：

Http://dev.mysql.com/downloads/mysql/5.0.html

2. Unzip to the directory, I extracted this to D:\Program Files

3. Locate the My-default.ini copy under MySQL and rename it to My.ini

What you need to change to open My.ini: Basedir, DataDir, and port. Notice the difference between Basedir and DataDir

4. Environment variable configuration:

My Computer-Properties-advanced-environment variables-NEW

Variable mysql_home value D:\Program files\mysql-advanced-5.6.18-winx64

Find the variable path edit, add it at the back;%mysql_home%\bin;

5. Run cmd as administrator into the bin folder under the MySQL folder enter Mysqld-install registration service

　　

6. Start the service net start MySQL

Stop service net stop MySQL

Remove Service Mysqld-remove

7. Modify the MySQL password: (change password to root)

run cmd as Administrator, enter Mysql-uroot followed by input Note semicolon

Mysql>show databases;

Mysql>use MySQL;

Mysql>delete from User where user= "";

Mysql>update User Set Password=password (' root ') where user= ' root ';

Mysql>flush privileges;

mysql>quit;

Finally, you can install MySQL management interface navicat to use MySQL

MySQL Free install version configuration (collation)