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

MySQL is the most popular relational database management system, and MySQL is one of the best RDBMS (Relational Database Management System: relational database management system) applications in WEB applications.

Download the MySQL installation package

Open the website to download MySQL (link to MySQL download address)

The link to this site is the default latest version of MySQL, so if you need to download version 5.7, you need to click on the link in the figure below to download.

Choose the version that corresponds to your computer. Now it is usually a 64-bit computer.

Next, click Download, select No thanks, and just start my download will download the installation package directly.

2. Decompress to the corresponding folder

What is downloaded is a compressed package and unzipped to the directory you want to put.

Configure MySQL environment variable, system variable-> New-> variable name is MYSQL_HOME, variable value is your path name

My variable name is: C:\ MySQL\ mysql-5.7.24-winx64

Then change the Path environment variable, the new increment is:% MYSQL_HOME%\ bin

III. My.ini file

There are no data folders and my.ini files in the folder you unzipped, so add an empty data folder and my.ini files.

The content of my.ini file is as follows

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 3306 # set mysql installation directory basedir=C:\ MySQL\ mysql-5.7.24-winx64# set mysql database data storage directory datadir=C:\ MySQL\ mysql-5.7.24-winx64\ data# maximum number of connections the character set used by the max_connections=200# server defaults to 8-bit encoding The default storage engine default-storage-engine=INNODB that the latin1 character set character-set-server=utf8# will use when creating new tables

Fourth, install the MySQL service and initialize

Run cmd as an administrator and execute the command to install the mysql service:

Mysqld install

We can see that the service has been successfully installed.

Assuming that the installation is not successful here, it is possible that you installed it before but did not uninstall it completely, so be sure to uninstall it completely.

Then execute the command of mysql initialization:

Msqld-initialize

By performing this naming, we start our mysql:

Net start mysql

The following errors may occur here

The solution is to go to our MySQL package, delete the data folder, and then execute the command again:

Mysqld-initialize

Execution: net start mysql will find that the service started successfully.

After the startup is successful, we log in. Since there is a default password in the initialization, where can we find the default password?

In the file ending with err under our data folder.

Execute the command:

Mysql-u root-p

Enter the password found above: EcpHl,h43/N), then log in and change the default root password:

Alter user root@localhost identified by '123456'

Finally, let's talk about how to set a username and password to connect remotely:

We use Navicat for user management. When you add a new user, you can see the host input box. When setting up, you want the user to connect remotely, please enter%. If it is for local connection, please enter localhost.

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql5.7

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.