Install and configure the Mysql zip package on Windows

Source: Internet
Author: User

Install and configure the Mysql zip package on Windows

Environment: 64-bit Windows 7 system running mysql-5.7.16-winx64.zip

1. download the required mysql zip package from the mysql official website. For example, mysql-5.7.16-winx64.zip is downloaded;

2. Decompress to local disk (such as D disk), decompress the folder for mysql-5.7.16-winx64, rename to mysql-5.7.16;

3. Enter the mysql-5.7.16 folder, the default configuration file displayed is my-default.ini, there are fewer configuration items in the configuration file, I re-create a configuration file my. ini;

4. Double-click my. ini and enter the configuration content:

[Client]

Port = 3306

Default-character-set = utf8

[Mysqld]

Port = 3306

Character_set_server = utf8

Basedir = D: \ mysql-5.7.16

Datadir = D: \ mysql-5.7.16 \ data

SQL _mode = NO_ENGINE_SUBSTITUTION, STRICT_TRANS_TABLES

Save the configuration file;

5. Set Windows environment variables: Right-click "computer" on the desktop, choose "properties"> "Advanced System settings"> "environment variables"> "system variables"> "Path", and add Path D at the end of the variable value box: \ mysql-5.7.16 \ bin, save;

6. In Windows running, Enter cmd, enter the command line window, enter D:, press enter to enter D disk, then enter cd mysql-5.7.16 \ bin, press enter to enter the bin directory, enter the following three commands in sequence;

A. Command: mysqld -- initialize initializes mysql and generates files in data;

B. Command: install mysql

C. Command: net start mysql to start mysql Service

Note: Other commands: mysqld-remove to uninstall mysql; net stop mysql to stop mysql service;

Difference between mysql and mysqld: mysql is a client program, and mysqld is a server program;

7. After configuring the preceding settings, you can log on to mysql:

A. Because the root password is not set during the First Login, an error will be reported during logon. add skip-grant-tables to the ini file, save the settings, and restart the mysql service. In cmd, enter: net stop mysql; net start mysql; mysql-uroot-p, after you press enter, you can log on directly;

B. Set the root password:

① Enter the mysql database: use mysql;

② Set password: update user set authentication_string = password ('xxx') where user = 'root' and Host = 'localhost'; (version 5.7)

Update user set password = password ("xxx") where user = "root"; (Version 5.5)

③ Exit the database: exit (or quit)

④ After the password is changed, enter my. ini, comment out skip-grant-tables, and save the settings;

⑤ Restart the mysql service and log on again;

8. log on to mysql again and enter the command: alter user 'root' @ 'localhost' identified by 'xxx ';

Exit: quit

So far, the installation and configuration are complete! You can start using mysql.

 

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.