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

Reply

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

 

 

 

Reply

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.

Reply

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 http://www.phazeddl.com (do a search for 'SQL' once you get to the site).

Reply

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.

Cheers
Arun

Reply

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://mysqlfront.venturemedia.de/
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://www.dctkc.com/winlamp.php) and they do include 2.5
if you can't find it apart, it's word the 90mb download

Reply

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.

Reply

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)

Reply

yeah, but gui apps are easier to add data.

search google for mysql front 2.5
it's free
there's a linux app too that is really good, but i forgot the name.

Reply

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

Reply