Shulou(Shulou.com)06/01 Report--

There are two types of MySQL installation files, one is in msi format and the other is in zip format.

Click to enter: download address

1. Here are the steps for downloading and installing msi

Click in and download according to the number of digits on your computer.

After the download is completed, you can refer to the following installation steps to install.

Here, you need to set the login password for MySQL, and you need to use the login password when linking to the database. The user name is: root

After the installation is complete, you can click on the MySQL link database at the beginning.

two。 Here are the steps for downloading and installing zip

Download according to the number of digits on your computer.

After the download is completed, you can refer to the following installation steps to install.

1. Extract the compressed package to disk D, and the path is D:\ mysql-5.7.25-winx64

2. Copy the my.ini file to the D:\ mysql-5.7.25-winx64 path

3. Configure environment variables

Edit key name: path value: d:\ mysql-5.7.25-winx64\ bin

4. In the D:\ mysql-5.7.25-winx64\ bin directory, type cmd to start the console

Execute mysqld-install to install MySQL

Execute mysqld-initialize-insecure-user=mysql to initialize MySQL

Execute net start mysql to start the mysql service

Execute mysqladmin-u root-p password to set the new password

Enter password: enter directly, and then enter the new password root twice

5. Complete the installation and connect to the database mysql-h localhost-u root-p Note: under win10, you need to execute the above command under Windows PowerShell (administrator) (in the beginning)

The following is the configuration file my.ini

[mysqld] # set MySQL installation path basedir = D:/mysql-5.7.25-winx64# sets the data storage directory of the mysql database, which is data datadir = D:/mysql-5.7.25-winx64/data# setting database connection port port = 330 setting the character set character-set-server=utf8#default-storage-engine=MyISAM default-storage-engine=INNODB # of the mysql server supports the INNODB engine mode. Just change it to default-storage-engine=INNODB. # if INNODB mode cannot be started, delete the log file at the beginning of ib in the data directory and restart it. # set the maximum number of connections max_connections=512# allows temporary storage in the query cache size query_cache_size=0

If it is not installed in the D: root directory, you need to change the installation steps of the

3. Configure environment variables

Edit the key name: path value is: d:\ mysql-5.7.25-winx64\ bin; D:\ mysql-5.7.25-winx64\ bin; change to the path you installed, which needs to go to the bin directory.

And # set the MySQL installation path basedir = D:/mysql-5.7.25-winx64 in the configuration file my.ini and # set the data storage directory of the mysql database, which needs to be changed if data datadir = D:/mysql-5.7.25-winx64/data.

4. Change login password

Method one

C:\ > mysqladmin-uroot-p old password password new password

Method two

Mysql > use mysql;-- Note: in the previous version, the name of the password field was changed from password,5.7 version to acthentication stringmysql > update user set password=password ('new password') where user='root';mysql > flush privileges

5. Exit the database

Method one

Mysql > exit

Method two

Mysql > quit

Method three

Mysql >\ Q

6. Stop the MySQL server

Mysql > net stop mysql

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.