How to use phpmyadmin to access remote mysql database with IP address

The first step: Open the /phpmyadmin/libraries directory

The second step: Modify the config.default.php file (vim can be used to edit under Linux, and vi can be used under FreeBSD Or ee editor) find the "AllowArbitraryServer" code content

$cfg['AllowArbitraryServer'] = false; modify it to: $cfg['AllowArbitraryServer'] = true;

Change $cfg[ 'Servers'][$i]['host'] = '';Change to the IP address of your server

Change $cfg['Servers'][$i]['port'] = '' ;Change to the port of your server

Change $cfg['Servers'][$i]['user'] = 'root';Change to the user name of your server

Change $ cfg['Servers'][$i]['password'] = '';Change to your server's password

Step 3: Enter localhost:3336/phpmyadmin in the address bar, enter the server address, user name, password.

Recommended related articles and tutorials: phpmyadmin tutorial

The above is the detailed content of How to use phpmyadmin to access remote mysql database with IP address. For more information, please follow other related articles on the PHP Chinese website!