Page 1 of 1
PHPmyadmin 2.2.0 and Remote server
Posted: Thu Oct 03, 2002 2:27 pm
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----
Posted: Thu Oct 03, 2002 2:35 pm
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;
Posted: Thu Oct 03, 2002 5:16 pm
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.
Posted: Thu Oct 03, 2002 11:43 pm
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.