How does MYSQL-font connect to a remote server?

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.