What Is A Good Gui For MySQL ?

May I know what is a good GUI for manipulating mysql? Perhaps in the league of mysqlcc will be a good one Thanks for the help.And btw, who uses GUI for their Mysql here? I know that some people like to use console to type

May I know what is a good GUI for manipulating mysql? Perhaps in the league of mysqlcc will be a good one Thanks for the help.

 

And btw, who uses GUI for their Mysql here? I know that some people like to use console to type

<{POST_SNAPBACK}>

I prefer console, doing it in PHP or SQL scripts, depends whether I'm working in the program or not at the time. Other than that, there's the web based alternative phpMyAdmin which is quite good. I haven't really looked into GUI's for MySQL although I've heard good feedback for SQLyog, maybe give that a go?

 

Point and click methods are slower to me and there's really no need for me to use a frontend when I can plan everything out in advance, even just writing everything I want to happen in a text file and saving it for later references to see what structure I used in creating it.

 

Well hopefully you find something that is suited to your needs.

 

 

MC

I’ve tried using phpMyAdmin, but in the end found console is much easier and faster. If you know mySQL I suggest using console, it means you can write your code whether you have internet access at the time or not. If you don’t know mySQL well it isn’t that difficult to learn, I learnt in a few days, it’s relatively simple compared to most other programming operations. Once you learn it, it is well worth it. After which you can even write on paper what you wish to implement if you are stuck somewhere waiting. Sometimes back to the basics is just easier.

I'd go along with the others - console access is way much faster and easier than any of the GUI's. Alternatively try the new MySQL Administrator + Query Browser from mysql.com - the deprecated mysqlcc has been now broken down into two components.
Ummm... other than that - you do have a few good ones, for example, EMS MySQL Manager/Importer/Exported/Query Browser - a suite of 4 very handy tools - unfortunately they are not free. But if you are desperate enough, you could try downloading them from https://en.usenet.nl/?utm_medium=AFSI&utm_campaign=408878&utm_source=AF_TA_83028&utm_content=0_1 (do a search for 'SQL' once you get to the site).

Hi,There are lot of open source tools available under GNU GPL license, but i preffer you to go for MySqlAdmin from mysql.com, and with mysql5.0 u will get a built in admin tool.Search the net with kweyword "MySql Admin tool" And once again it depends on either do u need a web based tool or a standalone one.CheersArun

i agree on mysql admin tool

but a long time ago, i installed php & mysql & apache with winlamp, an auto installer (long ago, when i was a noob) and they had a great tool included. you have to pay for it, but the older versions were free and did their job just as wel, and still run fine on winxp. i'll have a look if i still have it somewhere

but check the mysql.org site, they have some nice tools.
still, i wish i could remember the tool


ok: i found it: it's mysql front:
http://forums.xisto.com/no_longer_exists/
nice tool! really! i remeber their version 2.5 being free. maybe you should google the net for that version. or download winlamp, i think they still include that version!

edit: just checked the winlamp site ( http://forums.xisto.com/no_longer_exists/) and they do include 2.5
if you can't find it apart, it's word the 90mb download

I don't do much coding in MySql yet but I find it's easier to follow your own logic if you use console. Phpadmin seems ok also.

I don't do much coding in MySql yet but I find it's easier to follow your own logic if you use console. Phpadmin seems ok also.

<{POST_SNAPBACK}>

Yups I agree to that - console access allows you to deal with problems much faster - and you get a good dose of the real HANDS-ON MySQL.. You cannot learn something through a GUI - if you REALLY WANT TO LEARN. In the end the gui will bend you down on your knees and make you go running back to the console.. Nothing like the console...

Long live the console.... and linux (there, I did it again..lol)

yeah, but gui apps are easier to add data.search google for mysql front 2.5it's freethere's a linux app too that is really good, but i forgot the name.

i use the mysql prompt or sometimes phpmyadmin. phpmyadmin is good.... easy and fast.

Mysql CC is very good, phpmyadmin too but as they said it's better to use the console, you've the realy control of the database and then why do you want to use a gui that need a lot of resources when the console need only some kb of ram and almost nothing of cpu?Php scripts are useful too, you've to create a scripts to insert directly SQL string in the db

i use phpmyadmin and its easy to manipulate mysql database server...i have not tried others yetso cant say about others....

Which Platform are you wondering about?

 

For web-based acces there is nothing better than MyPHPAdmin...

 

For PC-based access, I still uses MySQLGui, it can be found here

 

There are a bunch of different PO-based guis listed and downloadable from the MYSql Download page, here. I've not really had any experiance with any other GUI's, but I'm sure some exist...

 

Some Relevant Results from a Google on "MySQL GUIs":

MySQL Control Center Downloads

MySQL-Front

MySQL Administrator

MySQLGUI

Navicat

The Whole list of results can be found here

Well, I don't have much hands on experience in MySQL, even though I do have it on my pc to look around in it. I also have phpMyAdmin which I found to be pretty ok, I tried the MySQL Admin and Query Browser and was completely lost and utterly confused.So I would have to agree to go for the command line option And indeed, you will learn much more about MySQL through the commandline (at one point we did get this course in school - too bad I didn't pay attention )The commandline is also pretty straight forward, and there is a good help function in there as well I just found the GUI made it more complex than it is in all honesty.