Forum Moderators: coopster

Message Too Old, No Replies

remote MySQL admin

good tool?

         

smallcompany

4:51 am on May 22, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



I have several MySQL databases for same numbers of sites which is likely to grow.

I figured the point of having access to database as local only - for security reasons.

I still wonder about easier way of access, especially read-only, from my local Windows or Mac machine.
I came across something called navicat.

Is that good, and what else is available for multiple server/database management?
What makes you happy?

Thanks

eeek

6:45 am on May 22, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



Just use an ssh tunnel to get access.

smallcompany

4:12 pm on May 22, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



That would be for command line or I could use phpMyAdmin installed on my local machine?

Thanks

smallcompany

2:38 am on May 24, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



...or how about that MySQL Administrator (running on Windows)?

Thanks

coopster

12:14 am on May 26, 2009 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



I am most comfortable at the command line, too. I tunnel in using secure shell and start the command line client. For sites where that is not an option I have developed my own browser interface.