MySQL grants remote connection direct access

Without SSH channel, MySQL grants remote connection direct access

Statement

GRANT all privileges on * * to [email protected]'%'!dsjdg! '

Later revoke, wrong.

There was an error in re-grant.

Mysql> Grant all privileges on * * to [E- Mail protected]'% ' identified by '!dsjdg! ' with GRANT OPTION;
ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:yes)

----------------------

Solution:

Remove some

Delete from user where user= "root" and host= "%";

Re-empowering Grant SELECT, INSERT, UPDATE, DELETE, Create,drop on * * to [email protected]'% ' identified by '!dsjdg! ';

MySQL grants remote connection direct access