connect remotely to MySQL

[georgeocrawford]

Hi,

I use my G4 to administer a website which is served from an old G3 on the other side of the world. At present, I use the copy of phpMyAdmin on the server to work with the MySQL databases there.

I would like change this system and use my local copy of phpMyAdmin, connecting remotely to the server's databases. Reason - purely speed, as the G3 often takes 10 seconds or so process the various php scripts needed for each page.

The server's copy of phpMyAdmin logs in as root perfectly well, but I can't log in as root from my computer using the same password (nor can I using a GUI tool like CocoaMySQL). I understand that remote logins are either allowed or not, but don't know what I need to do to change this.

Bearing in mind the server's running OSX Server 10.2, what settings do I have to change to permit remote logins to MySQL???? (NB. - I have complete access to the computer via Timbuktu.)

Thanks for any help!!!

______________________

George

 

[tshot]

login is based on 3 factors
1. who can login
2. from where can login
3. what privileges.

in ur case root is permitted from localhost only.

u reqire to grant access to root from remote also (potetnital security risk)

i do not have experoence in PhpMyAdmin but i use MySql-Front from

http://www.mysqlfront.de

an no problem in connecting on a remote m/c as root or opetive user

by the way what is G3 and G4 ?




----------------
ur feedback is a very welcome desire