[Crashby]

I need a good MySQL GUI that will allow for

- Database viewing
- Record editing
- SQL script writing and execution
- Script result viewing
- Record(s) 'copy & paste' into Excel capability...

any open source or freeware applications that would do this for me?

Thanks!

 

[Ridemonkey]

For what platform?

 

[Crashby]

For what platform?

XP!

 

[SkaredShtles]

GUIs suck.

 

[Crashby]

GUIs suck.

not for a 'middle manager' like myself :eviltongu

 

[SkaredShtles]

not for a 'middle manager' like myself :eviltongu

Well played!

Edit: Although as a 'middle manager' you should NOT be editing records or creating SQL scripts.

 

[jonKranked]

XP!

*shudders*

i hope that this is on an isolated network.

 

[johnbryanpeters]

Find a MySQL ODBC driver like http://dev.mysql.com/downloads/connector/odbc/ (not vetted, just the first one Google showed me) and hit it directly through Excel or use Access.

J

 

[Crashby]

Find a MySQL ODBC driver like http://dev.mysql.com/downloads/connector/odbc/ (not vetted, just the first one Google showed me) and hit it directly through Excel or use Access.

J

meh... I need something simpler to look at and to interact with... a GUI is really what Im looking for. *remember - 'middle manager'

 

[johnbryanpeters]

Even a middle manager should know that Access has a GUI. Hire some help if you can't understand the answer.

 

[sanjuro]

Even a middle manager should know that Access has a GUI. Hire some help if you can't understand the answer.

How well does Access work with MySQL?

 

[Ridemonkey]

I had no idea there was a MySQL ODBC driver...that could have come in handy a lot...

 

[johnbryanpeters]

How well does Access work with MySQL?

If the ODBC driver is competently written, it should work fine.

ODBC is a translation mechanism that lets you more or less easily hook up to any database type in the Windows environment.

 

[Ridemonkey]

But Access uses MS SQL...I don't think queries written in MySQL will work...could be way off, don't use it ever.

 

[sanjuro]

Too bad we have lots of admins and web designers but apparently no dba's...

 

[Crashby]

Even a middle manager should know that Access has a GUI. Hire some help if you can't understand the answer.

Why the harshness? I'm indicating that I don't know enough to use something outside a point and click, menu driven, easy as pie GUI.

I don't have to, but I like to work in and around my database enough to keep my knowledge of the 'innards' sharp enough to delegate what I need to when I need to.

i.e. Mycon, EMS SQL manager, etc. Just looking for something similar that is free since my company wont pay for it...

 

[RenegadeRick]

But Access uses MS SQL...I don't think queries written in MySQL will work...could be way off, don't use it ever.

I'm almost afraid to comment on this since my ePenis is so huge, but here goes...

There aren't a whole lot of differences between the different SQL databases. On the most basic level SQL, is SQL is SQL. If there is an ODBC driver it should allow you to perform most basic tasks. Certainly enough for a middle manager.

Anyhow, here is a link that explains how to setup MS Access to work with MySQL via ODBC, and another link to a whole bunch of MySQL front ends ranging from shareware to freeware on Google. Of course, I haven't actually tested any of this stuff, because real developers write their own SQL.

And FWIW, I am a DBA (at times), but I heard that experience is irrelevant anyway.

 

[sanjuro]

And FWIW, I am a DBA (at times), but I heard that experience is irrelevant anyway.

If you're not an unix admin, you dont know ****

 

[SkaredShtles]

If you're not an unix admin, you dont know ****

 

[Ridemonkey]

On the most basic level yes, but when it comes to various functions, such as date formating, etc they differ.