MySQL App?

A Standalone App for SQL?

[ahmedtheking]

Is there a standalone App that is able to write MySQL for Windows or Mac?

[anshul]

Not sure, what are you talking about! Perhaps, you need PHPMyAdmin; you may see SourceForge Web site.

[ahmedtheking]

got that, but I'm doing some work via SSH and haven't got the priv's to installed phpmyadmin! There must be a SQL writer somewhere...

[anshul]

If your host not provide you that in cp, install it yourself. First install it on localhost, then upload it. But, be careful with usernames'/passwords'. Add Apache HTTP Authentication or directory-authentication to that directory, for security.

[ergophobe]

Do you mean an sql client? If you have MySQL installed, you almost certainly have a command-line client you can use via SSH

Just login and type

mysql -u username -ppassword

(note the lack of space after the -p)

Then once you get the mysql prompt you just choose your DB

use DB;

and then do whatever you want.

You *may* be able to get some GUI clients to run on your local computer and access MySQL using http tunneling, but I've never tried that.

Tom

[ahmedtheking]

No no no, I've got all the SQL via Command line, but I just can't be bothered to type the code! What I'd normally do is create it in phpmyadmin and then copy it into the SSH. But isn't there a stand alone app that will write sql for me to stick into the SSH?

[KingMacro]

if you're sending up an entire database you can use mysqldump to generate a dump of the database, then import it in to the other server

[ahmedtheking]

I already do that, kinda, but isn't there a stand alone program that will write sql for me?

[Stormfx]

Are you look for a GUI to edit your MySQL databases?

[mysql.com...]

[anshul]

I say again, PHPMyAdmin is sufficient ( Yes, it is though, slow! ). You can enter data into HTML FORM-like fields of PHPMyAdmin ( is a top-rated SourgeForge project ). It can then export/import db easily.

Also, if you get SQL for one row of table, you can duplicate/modify SQL for further rows ( using Find/Replace of say, [U]Notepad[/U]. I do this! )

[ahmedtheking]

Ok guys, I know phpmyadmin is great, and I do use it, but sometimes I work offline, and I need a stand alone app! That mysql Admin thing cannot connect to my server! I'm getting in touch with the server guys about it tho!

[coopster]

MySQL GUI development has seemingly thrown all it's resources (shifting directions, yet again) behind MySQL Administrator [dev.mysql.com] and MySQL Query Browser [dev.mysql.com], at least, for this week in time.

Different tools have come and gone over the past couple years alone and these two options seem to be the latest fad. Call me crazy, but this is one reason I still like the command line interface -- it hasn't changed ;)

[coopster]

As far as *offline* development, you can easily install a local MySQL server on your desktop development pc.

[anshul]

Yes! It is also nice to have online dbs as local dbs for development/management/information/backup/&c

[ahmedtheking]

Yeah def thought of that, but I've got a Mac (so installing would be fine, if it didnt screw up my apache web server on it! Any ideas on how to fix it or where to get a clean httpd.conf doc?)

[anshul]

I'ven't ever been to Mac, but MSI installer Apache works fine for Windows. Basic settings of httpd.conf for localhost are simple ( This file gets really gets complex for shared hosting; many entries! ). Just read comments, itself in httpd.conf; first but, let Apache is working; I don't know if you can run installers on Mac, as we do on Windows.

Or See Apache forum here.