tags:

views:

209

answers:

8
+1  Q: 

need a good frontend for MySQL for beginner user

implementing a database and need an easy to use frontend. Have tried: HeidiSQL - editing fields was very tedious MySQL-Front - wasnt adding tables through the SQL Editior, and only updated when the prog was restarted.

Can anyone recommend a Frontend which they think would be appropriate?

Many thanks

A: 

Navicat

Jage  2010-03-22 23:03:23
+6  A: 

People go back and forth, but when it comes to mySQL, the best interface is PHPMyAdmin. it's intuitive and really let's you do everything you need.

Marcos Placona  2010-03-22 23:03:26
+1 for PHPMyAdmin, but on a hosted db's from Dreamhost it's dog slow.
Alan  2010-03-22 23:04:09
I would disagree. For quick stuff it's fine. Backups are rough. I don't believe it has the ability to do even data / structure syncs with other databases and across servers.
Jage  2010-03-22 23:05:52
@Jage you have a point, but I think by the OP's question, data syncs across servers aren't really under consideration, based on "beginner user" ;-)
richsage  2010-03-22 23:07:41
+3  A: 

Have you looked at MySql Workbench?

Download Site

Alan  2010-03-22 23:03:36
URL should be http://dev.mysql.com/downloads/workbench/5.2.html
Felix  2010-03-22 23:18:12
fixed thanks!!!
Alan  2010-03-23 02:17:11
+1  A: 

Squirrel is pretty nice:

http://squirrel-sql.sourceforge.net/

Works in linux and windows.

 2010-03-22 23:05:27
thanks guys! much appreciated!
aadersh patel  2010-03-22 23:06:42
Java!! Run!! Sorry, I tend to hate anything Java that has a GUI.
Felix  2010-03-24 10:48:37
I tend to agree. I like squirrel though because I deal with Mysql, Oracle, SQLServer, DB2 on both windows and linux. Mysql only ow windows-only options won't help there and I always had trouble with Toad.
 2010-03-24 14:24:57
A: 

I use Toad for MySQL on Windows.

http://www.quest.com/toad-for-mysql/

I use Sequel Pro on Mac.

http://www.sequelpro.com/

Aaron Havens  2010-03-22 23:13:44
A: 

If you do not mind using a different implementation of SQL standard, you can use Postgres. Then you can use pgadmin http://www.pgadmin.org/. It is really powerful and simple to use. Here is a link describing the differences between the two implementations: http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL.

John  2010-03-22 23:18:03
+1  A: 

SQLYog is the shit for Windows or Linux

Paul  2010-03-22 23:22:27
Having a background with SQL Server and its front-end, I found SQLYog fairly natural to pick up.
Frank Schwieterman  2010-03-22 23:24:06
A: 

For Windows, use Database Workbench Pro, or the FREE Database Workbench Lite for MySQL.

Martijn Tonies  2010-03-23 08:41:23

related questions

Remove Quotes and Commas from a String in MySQL
What's the best way of converting a mysql database to a sqlite one?
How do you manage databases in development, test, and production?
Multiple foreign keys?
Add 1 to a field (MySQL)
Issues using MS Access as a front-end to a MySQL database back-end?
Bigger than a char but smaller than a blob
How do I retrieve my MySQL username and password?
Long-time LAMP Developer moving to VB.NET
How do I Concatenate entire result sets in MySQL?
Full complete MySQL database replication? Ideas? What do people do?
SQL: Distribution of table in time
SQLite vs MySQL
How do I create a new Ruby on Rails application using MySQL instead of SQLite?
Multiple Updates in MySQL
MySQL/Apache Error in PHP MySQL query
What all do I need to escape when sending a (My)SQL query?
Auto Generate Database Diagram MySQL
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
Python and MySQL
SQL Server 2005 implementation of MySQL REPLACE INTO?
How to export data from SQL Server 2005 to MySQL
Throw Error In MySQL Trigger
Binary Data in MySQL