Jump to content
xisto Community
Sign in to follow this  
cfusion2k

What Is A Good Gui For MySQL ?

Recommended Posts

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 :P

Share this post


Link to post
Share on other sites

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 :P

<{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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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).

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 :P

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


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 :P

Share this post


Link to post
Share on other sites

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)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 :)

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.