MySQL5.6forWindows decompressed version configuration installation _ MySQL

MySQL5.6forWindows decompress version configuration install MYSQL 5.6.14 decompress version installation steps

1. Slave.

2. after decompression, you can rename the folder and place it in the appropriate location. after decompression, the file name is changed to a mysql-5.6.14 and put it on the D disk. Of course, you can place it in any location you want.

3. after completing the preceding steps, many users start to use MySQL, but errors may occur. This is because no environment variable is configured. It is easy to configure environment variables: My computer-> Properties-> Advanced-> environment variables, select PATH, and add the PATH of your mysql bin folder (for example, D: /mysql-5.6.14/bin), PATH = .......; d:/mysql-5.6.14/bin (note that it is append, not overwrite)

4. do not start mysql after configuring the environment variables. we also need to modify the configuration file (if no configuration is available, an error will occur when mysql is started later !), The default profile for the mysql-5.6.1X is in D:/mysql-5.6.14/my-default.ini, or create a my. ini file by yourself,

5. modify or add the configuration in it ():

[Mysqld]

Basedir = D:/mysql-5.6.14 (mysql directory)

Datadir = D:/mysql-5.6.14/data (mysql directory/data)

6. run cmd as an administrator (be sure to run it as an administrator; otherwise, the permissions are insufficient ),

Enter: cd D:/mysql-5.6.14/bin to enter the mysql bin folder (whether or not environment variables are configured, enter the bin folder, otherwise the service will still report an error when started)

Enter mysqld-install (if you do not need to run it as an administrator, the following error will occur due to insufficient permissions: Install/Remove of the Service Denied !)

7. installation successful

8. after the installation is successful, start the service. In cmd, enter net start mysql (). The service starts successfully!

9. if "The system cannot find the file" is displayed, check whether the configuration file has been modified or whether the file is in the bin directory. if the configuration file is modified correctly and entered the bin folder, you must first delete mysql (input mysqld-remove) and then reinstall (input mysqld-install). If error 1067 is displayed, it is the configuration file modification error and check whether the configuration file is correct.

10. after the service is successfully started, you can log on. enter mysql-u root-p (if you do not have a password for the first login, press enter). The login is successful!

Notes

The encoding of the my. ini file must be an English code (such as ANSI in windows), not a UTF-8 or GBK.

Modify the root password:

1.> use myql;

2.> update mysql. user set password = password ('root') where user = 'root ';

3. flush privileges;

4.> exit; after logging out, the new password is required when you log on again.

I don't know why, it's a waste of time to upload images. Finally, let's download a Word document with images in it.