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

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.