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

This article shares the mysql installation and configuration tutorial for your reference. The details are as follows.

1. Configure MySQL database

1. Extract the green version of mysql and rename it to mysql5.7, as shown below

Compare the previous versions of figure 5.6 below, with fewer data directories (storing data) and my-default.ini files (configuration information)

II. Installation services

1. Run cmd (administrator version, otherwise there is no permission), as shown below

2. There is no data directory for the new version of mysql5.7, so we need to run the command to create

3. Run the command mysqld-install to install the service, as shown below:

If you don't need mysql, you only need to run mysqld-remove to remove it, as shown below

3. Run the net start mysql startup service, as shown below

If you need to configure whether to boot mysql, you can configure it in the windows service.

III. Client testing

1. Mysql-uroot-p is shown below.

IV. Change the user name and password

1. Run the command

Use mysql;UPDATE user SET authentication_string=password ('123456') where user='root';FLUSH PRIVILEGES

As shown below:

2. Log in again and run the command mysql-uroot-p123456

5. Configure the code as UTF-8

1. View the default encoding

2. Under the root directory of mysql5.7, create a new my.ini file (if you don't have this file after 5.7, create it yourself), as shown below:

When the Mysql service program starts, it automatically reads my.ini to get the configuration parameters, including coding.

3. Edit my.ini

Under the [mysqld] node, configure server-side coding and add 2 items

Character_set_server=utf8

[mysql] node, which is used to configure client information

We also add a [mysql] node and configure the encoding UTF8

[mysql]

Default-character-set=utf8

As shown below:

VI. Test query

1. If you modify the configuration file, you must restart the service first.

2. Log in using root users normally.

3. Run the command show variables like "% character%" to view the system character set variables, as shown below:

Wonderful topic sharing: different versions of mysql installation tutorials mysql5.7 various versions of installation tutorials

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.