phpMyAdmin connection remote MySQL database method

Modify the phpmyadminconfig.inc.php files in the phpMyAdmin site for this machine

Find this line and change the ' localhost ' after [' host '] to remote database IP

The code is as follows	Copy Code
$cfg [' Servers '] [$i] [' host '] = ' 192.168.1.10 ';

Note: 192.168.1.10 is the IP of the remote database

After the change---Start menu----run----cmd (return)----net stop MySQL (enter)--------net start MySQL (enter)

This proves that your phpmyadmin can connect to the remote, but how MySQL does not support remote is useless, here is a description of MySQL open remote connection

First link the MySQL of this computer (with SSH login terminal, enter the following command):

Mysql-uroot-p Enter the password login, enter the following statement, execution.

The code is as follows	Copy Code
Grant all privileges in *.* to ' user ' @ '% ' identified by ' password ' with GRANT option;

Where user is the username, MySQL defaults to root, password is the password set itself. % represents any host. This allows remote access to any host computer

FIX: At this time you access the local phpMyAdmin site when the user name password entered is a remote database, you can directly connect to the