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

This article records the installation and configuration tutorials of MySQL5.6 under Windows 8 and shares them with you.

1.1 download and path configuration

First, go to the official website to download the MySQL installation package.

Select DOWNLOADS,Community version

Decompress after download

Add the address of the bin directory to the path (Path) in the environment variable

1.3. Generate the data file:

Run cmd as an administrator

Go to C:\ Users\ lym96\ Desktop\ mysql-5.6.40-winx64\ bin

Execute the command: mysqld-- initialize-insecure-- user=mysql generates the data directory in the C:\ Users\ lym96\ Desktop\ mysql-5.6.40-winx64 directory

1.4. Start the service: execute the command: net start mysql starts the mysql service

1.5. Log in to mysql:

Log in to mysql: (because the password has not been set before, the password is empty. You do not need to enter the password, you can enter directly.)

C:\ Users\ lym96\ Desktop\ mysql-5.6.40-winx64\ bin > mysql- u root-p (- u username,-p password)

Enter password: *

1.6. Set password

Mysql > set password=password ('123456'); Query OK, 0 rows affected, 1 warning (0.00 sec)

Now if you do not enter your password after re-login, you will be prompted not to log in.

Remember: Mysql should end with a semicolon after typing a sentence.

This password is used after 123456, mysql-uroot-p123456

1.7. Query user password:

Query user password command: mysql > select host,user,authentication_string from mysql.user

1.8. Exit mysql:

Mysql > quit

Problem encountered: enter mysql-u root-p on the command line to log in to mysql and return "Can't connect to MySQL server on localhost (10061)" error

Solution: the reason is that mysql did not start

Solution: 1. Add mysql to the service of Windows. Change to the bin folder under the mysql installation directory, and run "mysqld-- install" on the command line

2. Initialize the mysql database

3. Enter net start mysql on the command line under the bin folder

4. Log in

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.