Mysql 5.7.14 download and install the configuration method text tutorial, 5.7.14 install the configuration

Source: Internet
Author: User

Mysql 5.7.14 download and install the configuration method text tutorial, 5.7.14 install the configuration

How to download the latest MySQL version?

I will go to the MySQL home page to download the latest version of MySQL-link: https://www.mysql.com/downloads/

Go to this interface to download:

Downloads-> MySQL Community Edition (GPL)

-> Select the corresponding system and computer version (here, the 64-bit download of the Window system is selected)

-> No thanks, just start my download.

How to install mysql 5.7.14 database?

Because it is free of installation, we can download the compressed package and decompress it directly to the directory we want to install.

Create the my. ini file and paste the following code (Note: Modify basedir and datadir to your own installation path ):

[Mysql] # set the default character default-character-set = utf8 # set port = 3306 # set basedir = D: \ mysql-5.7.14-winx64 # Set the data storage object datadir for mysql database = D: \ mysql-5.7.14-winx64 \ data # allow maximum connections to max_connections = 200 # the character set used by the server defaults to the 8-bit latin1 character-set-server = utf8 # default-storage-engine = INNODB

Open the cmd command window (run as Administrator), enter the bin directory of the installation directory, and execute the command:
After mysqld-initialize-insecure-user = mysql press enter, the data folder is automatically created in the mysql installation directory.

Install mysql through the command line:
Register the Service (note the operation as Administrator: Open "C: \ Windows \ system32.pdf, find the file named cmd.exe" on my computer, right-click and select "Run as Administrator (), go to the Directory D: \ mysql-5.7.14-winx64 and run the following code)
Copy codeThe Code is as follows: bin \ mysqld-install mysql-5.7.14-winx64-defaults-file = d: \ mysql-5.7.14-winx64 \ my. ini

Start the Service (run as Administrator)
Netstart mysql-5.7.14-winx64
-You can also right-click my computer | manage | services and applications | services | find mysql-5.7.14-winx64, right-click and choose start

Log on to the command line (if you set the bin directory to the path environment variable, You can omit "bin \". The same applies later)
Bin \ mysql-u root-p
-If the password is blank, press Enter.

Set password for root (when the original password is empty): mysqladmin-u root password "1234"

Modify the root password: mysqladmin-u root password oldpassword "newpass"

Stop Service (run as Administrator): net stop mysql-5.7.14-winx64

-You must stop the service before deleting it!

Delete Service (run as Administrator): bin \ mysqld-remove mysql-5.7.14-winx64

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

Related Article

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.