Is there WYSIWYG MySQL Software?

Forum Moderators: open

Message Too Old, No Replies

Is there WYSIWYG MySQL Software?

Looking for a tangible way to view and tweak tables without code

Jeremy_H

4:12 am on Nov 30, 2006 (gmt 0)

I really like the power and capabilities of MySQL, but the thing is, I'm kind of a tangible person.

On one site host, they had a back-end site that I could log in and view my tables. I could sort data, and even change values. It wasn't perfect, but it was nice, and none of these views or tweaks didn't require any code.

Of course, my website would interact and use the code the standard way, with it speaking and reading PHP. This viewer was just a second way to view the data, one designed for a human interaction.

I have since upgraded to a new host, a much better one, but they don't have such a way to view my tables.

I'm hoping there's a piece of software, (or maybe capability in excel or the like) that I could install on my home computer (windows) and connect to the MySQL tables to view and tweak.

I'm not looking to export or import data into excel or something like that, but able to view and interact with the data.

Thanks for your suggestions

inbound

4:23 am on Nov 30, 2006 (gmt 0)

Check with your host to see if they can/have install/ed phpMyAdmin.

It sits on the server rather than your desktop (usually - it's probably possible to run it on a remote computer but is way beyond the scope of your question).

phpMyAdmin is like a user interface for MySQL, it's easy enough to view change data in a limited way and, if you are feeling adventurous, it's able to handle most tasks which include getting your hands dirty with SQL.

Jeremy_H

5:25 am on Nov 30, 2006 (gmt 0)

That's great, phpMyAdmin is the what I used on my old host. I thought the system was something they developed an therefore unique to them -- guess not.

That also makes me think this is a "professional" level program, or at least semi-professional, versus simply a little entry level gadget for beginners.

I'm contacting my new host to see if I am able to install this on my system. (I've never installed software on my host before, so this is new to me).

On the off chance I'm not able to install this software on my site, are there alternative software just like this that can be based on my computer?

Thanks.

jtara

7:03 am on Nov 30, 2006 (gmt 0)

There's also MySQL Query Browser and MySQL Administrator, which run locally on your PC. You connect remotely to MySQL. If you want to be secure about it, limit MySQL to localhost (or your local network if you have a seperate database machine) and use ssh port forwarding.

There are quite a number of additional options. Heck, you can even use Microsoft Access.

I've disabled MySQLAdmin on my server. I think it's a huge security problem.

Jeremy_H

3:38 pm on Nov 30, 2006 (gmt 0)

Thank you so much!

I know have phpMyAdmin up and working on my system (installation much, much easier than I had thought), and its great to know I'll have some desktop application options too.

Thanks again!

jtara

8:24 pm on Nov 30, 2006 (gmt 0)

Oops, I meant that I've disabled phpMyAdmin on my server. It's one of the most popular website attack targets.

It is safe, though, if you limit it to 127.0.0.1 and use SSH port forwarding to access it.

johnhh

4:39 pm on Dec 1, 2006 (gmt 0)

Use a little program calle HeidiSQL myself - pretty good in its current version, runs on your desktop.

Or use good old MySQL ODBC into Access as jtara says.