Install and configure MySQL in the free version of win10, and install and configure win10

Source: Internet
Author: User

Install and configure MySQL in the free version of win10, and install and configure win10

I found a lot on the Internet. I found that many of them are not linux systems, but they are different from the current new version. I have done some practical work on small projects for your reference.
MySQL version: mysql-5.7.17

Download Method:

1. MySQL official website https://www.mysql.com/downloads/
2. Download Method:

A. Select the corresponding module:


B. Select the corresponding version (here I select windows ):


C. Select the 32-bit or 64-bit version for download:


D. Click Download. It will allow logon or registration. You can skip this step:

MySQL installation Configuration

1. decompress the downloaded. ZIP file and place it in the desired location.
Open the folder, create the my. ini file, and enter:

[Mysql] # set the default character set of the mysql client default-character-set = utf8 [mysqld] # set port 3306 to port 3306 # set the mysql installation directory basedir = D: \ mysql \ mysql-5.7.17-winx64 -- your own path # Set the mysql database data storage directory datadir = D: \ mysql \ mysql-5.7.17-winx64 \ data -- your path # maximum number of connections allowed max_connections = 200 # the character set used by the server defaults to the 8-bit latin1 character set character-set-server = utf8 # create a new table default-storage-engine = INNODB

And save it as ANSI format.

2. Open the Windows environment variable settings, put the full Path of the bin directory of mysql in the Path variable of the environment variable, and add a semicolon (;) after the Path to save.

Such as D:/mysql/mysql-5.7.17-winx64/bin;

3. install MySQL service: mysqld-install

Start: net start MySQL
Stop: net stop MySQL
Uninstall: SC delete MySQL, mysqld-remove
The command line window must be opened in administrator mode.
A. install the service: mysqld-install.
B. start the Service net start MySQL
(The MySQL service is starting. The MSQL service cannot be started. The Service did not report any errors. Type net helpmsg 3534 for more help.
Delete the data folder and use mysqld-initialize to initialize the data directory.

4. When the service is enabled successfully, use

Mysql-u root-p press ENTER
Enter the password (in the data folder with the suffix. err)
Enter and press Enter.
Note: The old version does not have a password at the beginning. You can log on to the old version by pressing enter. The new version generates a random password to enhance security.

5. Change the password

There are three methods:
① Run the set password command: log on to MySQL first.
Format: mysql> set password for username @ localhost = password ('new password ');
Example: mysql> set password for root @ localhost = password ('20140901 ');
(Mysql> set password = password ('20140901 ');)
② Use mysqladmin (used without logging on to MySQL)
Format: mysqladmin-u username-p old password New password
Example: mysqladmin-uroot-p123456 password 123
③ Use UPDATE to directly edit the user table
First, log on to MySQL.

mysql> use mysql;mysql> update user set password=password(‘123') where user='root' and host='localhost';mysql> flush privileges;

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.

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.