Mysql login remote database, mysql Login

Mysql login remote database, mysql Login

1.LoginMysql

2. e mysql;

3.For example, if the user name and password areRoot/root.

You wantRootUseRootConnect from any hostMysqlServer.

@''AddIpGenerallyLocalhostOr127.0.0.1 * %Represents anyIpCan be accessed.

Grant all privileges on *. * TO 'root' @ '%' identified by 'root' with grant option;

4.Refresh permission

Flush privileges;

If you cannot connect to the remote database, it may be that the port is not open.

Add new inbound rules to open the port used by mysql (Common 3306)