win7/mysql-8.0.11-winx64 installation of the test pits step

A false alarm, the main problem is Navicat Premium connection Mysql8 Client does not support authentication.

1. Download the archive download package: Mysql-8.0.11-winx64.zip

2. Unzip to the directory you want to install: Then create a new file under the installation package My.ini content as follows: (note Basedir/datadir...data is configured according to its installation location)

[Client]

port=3306
Default-character-set=utf8

[Mysqld]
#设置mysql的安装目录
Basedir=d:\developinstall\mysql-8.0.11-winx64
#设置mysql的数据目录
Datadir=d:\developinstall\mysql-8.0.11-winx64\data

Character_set_server=utf8
#sql_mode =no_engine_substitution,no_auto_create_user
#开启查询缓存
Explicit_defaults_for_timestamp=true

3. Run cmd as Administrator enter: Mysql-8.0.11-winx64/bin directory: Execute command mysqld–-initialize

(You can see the. err file under data that contains the password for your first login to root) such as:

A temporary password is generated for [email protected]: cu/fkq0mts?t

4. Execute the mysqld install service in cmd,

5.cmd in net start MySQL startup service

6.cmd mysql-u root-p login. err file password Paste to login

7. Login successful.

8*************** now I connect with Navicat Premium mysql hint: Client does not support authentication protocal requested by server; ...

I thought it was root. The remote IP connection is not allowed so be prepared to grant permissions:

Grant all privileges on * * to [email protected] '% ' identified by ' 123456 ';

Mysql> Grant all privileges on * * to [e-mail protected] '% ' identified by ' 123456 ';
Error 1064 (42000): You have a error in your SQL syntax; Check the manual that
Corresponds to your MySQL server version for the right syntax to use near ' ident
ified by ' 123456 ' on line 1

-------------repeated repeated errors, repeated Baidu query error hints, and no use. Finally Google Agent: All of a sudden there is a result:

https://stackoverflow.com/questions/50177216/how-to-grant-all-privileges-to-root-user-in-mysql-8-0

I read the first half: The effect is that grant all privileges on * * to [e-mail protected] '% ' identified by ' 123456 '; Error Ah, MYSQL8 and 5.1 difference Ah, how to give permission to root can also be remote IP access AH.

finally see

mysql> CREATE USER ' java ' @ '% ' identified by ' root ';

Query OK, 0 rows affected (0.31 sec)

Mysql> GRANT all privileges on. To ' java ' @ '% ' with GRANT OPTION;

Query OK, 0 rows affected (0.16 sec)

In short, you have to create a new user and give permission by the way. Then I changed the ' java ' @ '% ' user as a remote connection.

9. After that, I can't even

Navicat Premium connection MySQL tip: Client does not support authentication protocal requested by server; ...

At last:

Https://www.cnblogs.com/xiaojian1/p/mysql.html

Alter user ' test ' @ '% ' identified with Mysql_native_password by ' 123 ';  Solve the trouble navicate can be connected properly.

A false alarm, the main problem is Navicat Premium connection Mysql8 Client does not support authentication.

win7/mysql-8.0.11-winx64 installation of the test pits step