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: & nbsp; root & nbsp; pwd: lyl123 server & 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.