Shulou(Shulou.com)06/01 Report--

This article is about how phpMyAdmin sets up a remote connection to a database. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

How to set up remote connection to database by phpMyAdmin

The first step is to set up a remote user on the server (the root account only allows local connections, and a remote login account is generally set up for security)

Operations on the server

Log in to mysql with your root account

# mysql-u root-p root password mysql > GRANT ALL ON *. * TO admin@'%' IDENTIFIED BY 'admin' WITH GRANT OPTION

Allow any computer with an IP address to access the MySQL Server with an admin account and password (admin).

Local operation

Configure the phpmyadmin profile phpMyAdmin/libraries/config.default.php in your local web service

About 125lines. Change host, user, password to server related information.

$cfg ['Servers'] [$I] [' host'] = 'remote database server IP address' $cfg ['Servers'] [$I] [' user'] = 'admin'$cfg [' Servers'] [$I] ['password'] =' admin'

Open the phpMyAdmin address locally with a browser and log in to the remote account.

Thank you for reading! This is the end of this article on "how to set up a remote connection to the database in phpMyAdmin". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.