How to solve the problem that mysql cannot be connected to another root user.

In fact, the root permission is used to create a % user. Specific Method: CREATEUSER 'whoamam' @ % 'identifiedby 'whoamifortest'; GRANTALLPRIVILEGESON *. * TO 'whoam' @ % 'identifiedby 'whoamifortest' WITHGRANTOPTIONMAX _ comment

In fact, the root permission is used to create a % user. Specific Method: create user 'whoamam' @ % 'identified BY 'whoamifortest'; grant all privileges on *. * TO 'whoam' @ % 'identified BY 'whoamifortest' with grant option MAX_QUERIES_PER_HOUR 0 MAX_CONNECT

In fact, the root permission is used to create a % user. Specific Method:

Create user 'whoamam' @ '%' identified by 'whoamifortest ';
Grant all privileges on *. * TO 'whoamam' @ '% 'identified BY 'whoamifortest' WITH GRANT OPTION
MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;

Finally, remember to drag the database and delete the created user.

Drop user 'whoam' @ '% ';
Drop database if exists 'whoam ';

Original article address: solution to the problem that mysql cannot be connected to another root user ., Thanks to the original author.