How does MYSQL-font connect to a remote server?

How does MYSQL-font connect to the remote server? How does MYSQL-font connect to the MYSQL remote server, such as the local machine? & nbsp; host name: lyl & nbsp; IP: & nbsp; 192.168.0.200 & nbsp; user: & MYSQL-font how to connect to a remote server
How does the local MYSQL-font connect to the MYSQL remote server?

For example, host name: lyl IP: 192.168.0.200
User: root pwd: lyl123

Server host name: server2 IP: 192.168.0.1

User: rirny pwd: lg123 (the permission is correct) all 'y'

No changes have been made to the port.

How to set

The settings used always appear:
#1045-Access denied for user 'rny '@ 'lyl' (using password: YES)

It is the same as phpmyadmin (local ).




------ Solution --------------------
Host field write %
------ Solution --------------------
This is because mysql does not allow remote access. you need to add a database user that allows remote connection to the mysql database, and enter the host name that allows remote access in the host part. for example, you can write "192.168.0.% ", which allows users in the Lan to connect to the mysql database
------ Solution --------------------
This has nothing to do with the MYSQL-FRONT

Run the following command in MYSQL:

Grant all privileges on *. * to 'root' @ '%' identified by 'password you want ';
Flush privileges;

And then login in the MYSQL-FRONT.