Allow Remote Access to MySQL

The reason why MySQL allows remote access is not allowed is that mysql controls the access permissions of each user. You can view the mysql. user table of the database ,? The Host field is the allowed address. Add the address you want to access in it? % Is to allow all addresses to access So... modify it? 1 .? Modify the original user ??? Mysqlup

The reason why MySQL allows remote access is not allowed is that mysql controls the access permissions of each user. You can view the mysql. user table of the database ,? The Host field is the allowed address. Add the address you want to access in it? '%' Is to allow all addresses to access So... modify it? 1 .? Modify the original user ??? Mysqlup

Allow Remote Access to MySQL

The reason is that mysql controls the access permissions of each user.

Can you check the mysql. user table of the database ,?

The Host field is the allowed address. Add the address you want to access in it? '%' Indicates that all addresses are allowed to access

So... modify it.

?

1 .? Modify original user

??? Mysql> update user set host = '%' where user = 'root ';

2. Add a new user

??? Mysql> insert into mysql. user (host, user, password) values ('%', 'crackren', PASSWORD ('pw123456 '));
??? Mysql> grant all privileges on *. * TO 'crackren' @ '%' identified by 'pw123456' with grant option;
??? Mysql> flush privileges;

??? (Note that only access is allowed. You do not need to grant all permissions to the added user)