How to use phpmyadmin to connect to a local existing database

Configure phpmyadmin to connect to an existing database on this machine

Directory: /xampp/phpMyAdmin

File: config.inc.php

1. Search for $cfg['PmaAbsoluteUri'] and set its value to the machine where phpmyadmin is currently located, for example: http://172.16.1.200/phpmyadmin

2. Search for $cfg['Servers'] [$i]['host'], set its value to the IP address of the database, for example: 172.16.1.100 (if Mysql is directly changed to localhost locally)

3. Find $cfg['Servers' ][$i]['user'] , set its value to the database user, for example: admin

4. Find $cfg['Servers'][$i]['password'] and set it The value is set to the database password, for example: 123456

Recommended related article tutorials: phpmyadmin tutorial

The above is the detailed content of How to use phpmyadmin to connect to a local existing database. For more information, please follow other related articles on the PHP Chinese website!