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