PHPmyadmin 2.2.0 and Remote server

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Alex Papa
Forum Newbie
Posts: 10
Joined: Sat Sep 14, 2002 12:53 pm

PHPmyadmin 2.2.0 and Remote server

Post by Alex Papa »

My problem is that I want to control my MySQL database in a remote server using PHPmyadmin. If the PHPmyadmin is installed in the server then no problem. But I don't seem to be able control the MYSQL database on the remote server when phpmyadmin is installed on my local PC.

Any tricks on the issue??

Thanks

AAA----
rev
Forum Commoner
Posts: 52
Joined: Wed Oct 02, 2002 3:58 pm
Location: Atlanta, GA

Post by rev »

The server which MySQL is installed must have a user recognized as coming from the host you wish to connect from... e.g. the machine that your install of phpMyAdmin resides must have a user in MySQL that is allowed to connect from the phpMyAdmin server's IP.

Something like:

Code: Select all

grant all privileges on *.* to user@your.phpMyAdmin.server.address identified by 'password';
flush privileges;
Alex Papa
Forum Newbie
Posts: 10
Joined: Sat Sep 14, 2002 12:53 pm

Post by Alex Papa »

Thank you rev. But you confused me a bit.

What do you mean? I don't think that would be a solution.

PHPmyadmin is installed on my PC. I want to control the remote server's MYSQL database without having to install PHPmyadmin again to the remote server and waste space.

Thank you.
rev
Forum Commoner
Posts: 52
Joined: Wed Oct 02, 2002 3:58 pm
Location: Atlanta, GA

Post by rev »

MySQL's default means of user authentication is both user/pass and user server-specific.

If I were to try and connect to your MySQL server, it would not grant me access because there is not a user in it's user table that has a valid reference to my IP/hostname.

For phpMyAdmin to successfully connect to your 'remote' MySQL server, the 'remote' MySQL server is going to have to have a valid user referencing your PC's IP or hostname. This is where the 'grant' statement I listed above comes in to play. You are gonna have to add this valid user else you will not be able to connect.

Regardless of remote, when adding a user local to MySQL it still requires a valid host reference... in the case of local access, a simple declaration of user@localhost is suffice.
Post Reply