Easy Interface for SQL

January 12, 2006 4:38 AM

What is the best alternative interface for an SQL server?

I am converting several databases from Access to mySQL. Unfortunately, Access doesn't interface natively with mySQL, creating problems.

Are there any tools available with a very Access-like interface that will work with mySQL? I've looked at many query builders, but haven't found much in the way of something that would work for me to give to my end users. These are people who don't know how to compose SQL, but still need to query the database.

posted by benjh to computers & internet (6 answers total)

Isn't it just a matter of defining an ODBC data source to MySQL (using the MySQL/ODBC Connector) and then accessing it from Access as you always did?
posted by nkyad at 4:54 AM on January 12, 2006

You can use it through Access as nkyad suggests. Otherwise, you can try MySQLFront or CocoaMySQL for Mac. MySQLFront changed developers when version 3.0 came out. I still run 2.5 because I find it much easier to use. If you can find an older copy, I would recommend that.
posted by yerfatma at 5:44 AM on January 12, 2006

DBDesigner is a great tool, with a special attention paid to MySQL dbs.

Also works with any ODBC db.

FOSS (Free, Open Source Software).
posted by unixrat at 6:18 AM on January 12, 2006

Aqua Data Studio
posted by mkultra at 7:14 AM on January 12, 2006

I realize this isn't a complete answer to your question, but MdbToMySQL XP is a great software tool for converting Access files to SQL text files for import into MySQL.
posted by owen at 7:55 AM on January 12, 2006

EMS MySQL Manager
posted by drylongso at 12:37 PM on January 12, 2006