MySQL5.6forWindows decompressed version configuration installation _ MySQL

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.