Phmyadmin How to use MySQL database remotely

Need to create a remote account on the server side of MySQL, the default root remote is not login.

1. Create a remote account

The code is as follows	Copy Code
Create user ' test ' @ ' 223.4.19.112 ' identified by ' testpasswd '; #只允许223.4.19.112

This IP login is allowed to be @ '% ' 2. Set permissions

The code is as follows	Copy Code
Grant all privileges in zjhy.* to ' test ' @ ' 223.4.19.112 ';

3. Test

The code is as follows	Copy Code
Mysql-h224.4.7.77-uzjhy-p

4. Test Success!

The permissions are set, we can manage the MySQL database locally as long as we configure the phpMyAdmin connection remote MySQL database

Introduction:
1, phpmyadmin program server: 192.168.1.1, Access address: http://192.168.1.1/phpmyadmin
2, MySQL database server: 192.168.1.2, has allowed the database chain, MySQL database user name: admin password: 123456
3, now through Http://192.168.1.1/phpmyadmin to manage the server 192.168.1.2 MySQL database above
System operation Dimension Warm reminder: qihang01 original content copyright, reprint please specify the source and the original link

The operation is as follows:

First, download phpMyAdmin to http://192.168.1.1/phpmyadmin directory
Download Address:, find the version you need

For example:

Modify the config.default.php file under the Libraries folder in the phpMyAdmin directory
1, find $cfg[' Pmaabsoluteuri '], set its value to Http://192.168.1.1/phpmyadmin
2, find $cfg[' Servers ' [$i] [' Host '], set its value to 192.168.1.2
3, find $cfg[' Servers ' [$i] [' User '], set its value to admin
4, find $cfg[' Servers ' [$i] [' Password '], set its value to 123456
Third, the configuration is completed, now through the Http://192.168.1.1/phpmyadmin Input database username: admin Password: 123456 can access the server 192.168.1.2 the MySQL database above.