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----
PHPmyadmin 2.2.0 and Remote server
Moderator: General Moderators
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:
Something like:
Code: Select all
grant all privileges on *.* to user@your.phpMyAdmin.server.address identified by 'password';
flush privileges;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.
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.