Remote MySQL administration

[alpert]

Is it possible to administer MySQL database remotely using a program on my local PC? (I don't wanna use phpAdmin!)
Does it listen to the well-known tcp port 3306? and what should be the server address, mydomain.com?

When I try, I get an access denied message.

[Brendan]

At the current time no, but I will look into this later today and see if we can work something out. I'll post what I find here.

[petesmc]

Telnet works, once connected type: mysql

then you can connect to databse.

I know nothing on telnet so i use phpadmin, but i wanted to do a databse dump and stumbled upon this.

They probably refuse entry or something becaseu you can see everyones databases.

[petesmc]

I ment type: mysqladmin

[widget]

I was able to do a dump on my old database then pop it into the new one, using phpAdmin, I'm not too familiar with telnet commands for mysql.

[JohnM]

You can use mysqldump to dump your DB to a file... I use:

mysqldump --opt --user=db_username --password=db_password database_name > /home/username/database.sql

in crontab to back my database regularly

[Lucky]

Originally posted by petesmc

They probably refuse entry or something because you can see everyones databases.

That doesn't matter, you still will not have the usernames and the passwords to those databases. With my "other" host I can see the countless db's of all the other users....

I too would like to access my db's remotely, disappointing to find out I can't.

[Edited by Lucky on 03-04-2001 at 01:44 AM]

[foe]

but you need ot make sure that its just your db thats viewed remotely, because password crackers are available all over that just crack mysql dbs, very quikc.

[conan]

I too would like to be able to access my HR database using a local program like MySQLGUI or MySQL Navigator or even Mascon.

It would be excellent if HR supported this!

[tbj]

I would also like to have direct access in order to have more control on user permissions.