What is mySQL GUI

rashersangitch · 31-12-2008 12:30PM #1

Hi,
In a previous life I've used MS Access with SQL Server and so have become quite used to it.

Now I have a series of MySQL databases. Im Told MS Access doesn't like MySQL but that I would like the same ability to graphically create queries, Forms reports etc...Not to mention Macros etc

I've tried using Open Office (Base) application but found this to be a bit shakey...

Any Ideas?

Evil Phil · 31-12-2008 12:36PM

Not that familiar with mysql myself but would mysql workbench be what you're looking for?

Webmonkey · 31-12-2008 12:54PM

MySQL Control Center is the only one I'm familiar with but I amn't sure if it is as user friendly as you'd like. http://sourceforge.net/projects/mysqlcc/

rashersangitch · 31-12-2008 03:11PM

These seem to be very much back end DBA tools...Which is fine..
I'm looking for a way I can, for instance, create a front end which will allow for easy data-entry capabilities...
...When I worked with MS Access and SQL server I was constantly moaning about it. now that its gone I miss it.

CuLT · 31-12-2008 03:39PM

MS Access, as far as I know, will work with MySQL.

If you haven't actually tried, it might be worth a shot.

Edit: might try rifling through a few of these also.

Tom Dunne · 31-12-2008 03:44PM

Oh dear. You see, MS Access was designed as an all-in-one solution.

MySQL/PHP/Apache are independent products and while there is a large amount of inter-operability, there probably isn't anything free comparable to MS Acces. You will probably have to learn PHP.

Anyway, I would imagine you can put an MS Access front-end onto a MySQL database, though as a DBA, I would cringe at the thought of it.

Webmonkey · 31-12-2008 03:58PM

Interesting: http://www.vfront.org/en/

kyote00 · 31-12-2008 06:09PM

I've used this for many years - http://www.phpmyadmin.net/home_page/try.php

Really the only way to go when using mySQL, especially when coupled with SQL workbench as mentioned earlier...

duffman85 · 31-12-2008 08:08PM

I think these are what you are looking for:
http://dev.mysql.com/downloads/gui-tools/5.0.html

Saint_Mel · 01-01-2009 12:12PM

You can Link mySQL tables into an MS Access Database and then use Access queries/forms/reports against them.

If you create a mySQL ODBC DataSource and then link as external data

sinkingfish · 02-01-2009 11:00AM

I like SQLyog, the have a community & enterprise edition.

http://www.webyog.com/en/download_form.php?url=http%3A%2F%2Fwww.webyog.com%2Fdownloads%2FSQLyog714.exe

thebman · 02-01-2009 11:19AM

Download MySQL Query Browser from duffman85's link.

It is a very easy to use solution for connecting to MySQL databases and writing queries or doing GUI insertions to databases. Used it a bit in final year of college to test queries.

What is mySQL GUI

Comments