Jump to content

Windows GUI for MySQL


Recommended Posts

Have you tried the Query Browser? Also, SQLyog is also good, though the interface takes some getting used to. Obviously, Navicat is excellent, but not free. Personally, I still use the old MySQL Control Center, but only because the Query Browser is not supported under Win98.

 

Hope that helps.

  • Like 1
Link to post
Share on other sites

I know you asked for a windows GUI client, but in case you don't know about it, phpMyAdmin is really the way to go for pretty much anything you want to do. It is a web application that runs on php, is totally free, and works flawlessly. It has to run on a web server, but it doesn't have to be on the machine where the database is, it could even be installed on a machine in your house (preferably a nix/apache setup).

 

GUI clients that I've seen all have quirky little bugs and occasional slowdowns or lockups, and all but a very few are commercial apps (not free). Try the QueryBrowser from the MySQL guys. SQLyog is ok but it nags you repeatedly until you pay up (9 bucks). EnginSite and Navicat are decent commercial options.

Link to post
Share on other sites

No offence, but PHPMyAdmin totally sucks if you want to edit 3 rows at a time without having to click a thousand times. It's fine for raw queries, of course, but if you want to do anything meaningful with a result set, you're out of luck.

Link to post
Share on other sites

[!--quoteo(post=341978:date=Feb 2 2006, 04:04 AM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Feb 2 2006, 04:04 AM) 341978[/snapback][/div][div class=\'quotemain\'][!--quotec--]

No offence, but PHPMyAdmin totally sucks if you want to edit 3 rows at a time without having to click a thousand times. It's fine for raw queries, of course, but if you want to do anything meaningful with a result set, you're out of luck.

 

I do have phpmyadmin on my host, and this is exactly why I hate it. It's just too slow. I've tried all those ones that have been suggested, as well as another I got suggested to me - SQL manager, which seems to be the best out of all that I have seen, although none of what I have tried allow me to copy a whole column of fields from excel - but Navicat has an export feature to csv which would help; that seems to only be available on the registered version, so I might try buying it. Thanks for the suggestions

Link to post
Share on other sites
  • 5 months later...

Hello all,

 

new to these forums but after digging around this looked like a good place to get some advice on the subject.

 

 

Im looking for a good GUI tool to manage mySQL databases. Id love a free one but i dont mind paying for quality software.

 

Most of my experience is with MS SQL / Enterprise Manager so anything that is similar would be helpful. Mainly what i need is a Windows client for creating / modifying / backing up (and restoring) all aspects of a database. . . (tables etc). The DB server is a linux server if that matters at all.

 

Thanks for any and all help.

 

looking forward to some good conversation here.

Link to post
Share on other sites

Well, PHPMyAdmin is totally useless for just about everything... Navicat is fantastic, though often far too powerful, and not very free.  The MySQL Query Browser is fairly good as well (the old Control Center has many, many bugs).  Also, I use another tool, whose name I can't recall, for DB<->DB copying / backup.

Link to post
Share on other sites
Well, PHPMyAdmin is totally useless for just about everything...

Why you say that?

 

FYI PHPMyAdmin is a web based client which allows you to manage your MySQ: databases/tables. It is free an opensouce however requires your server to have PHP setup. I use phpMyAdmin a lot.

 

If you want a windows GUI, I've not seen many good free ones. However the good ones I have seen cost and can be expensive. I use MySQL Query Browser and MySQL Administrator from time to time but not alot, which are both free and are available from MySQL.com

Link to post
Share on other sites

PHPMyAdmin is just a cumbersome tool for any but very basic things... if you want to edit 7 records at the same time, that would require about 100 clicks in PHPMyAdmin.  It's just a very kludgy interface.

Link to post
Share on other sites
  • 1 year later...

My experience is with MS Access and SQL Server Enterprise Manager.

 

I like creating queries with a visual interface, linking tables visually for inner/left/right joins, etc...

 

Is there any free tools that I can do this with MySql?

 

Thanks!

Link to post
Share on other sites

So far i like MySql Tools a lot(official MySql GUI). Very good piece of software. Supports procedures, functions, views, tabbed interface, nice help and overview on the right side, pretty and clean interface, easy access to Query Browser from Administration and vice-versa.

Few drawbacks that i found so far:

1) interface is not resizable.

2) It has some issues with OUT variables in procedures, i had to use cmd to see the return value.

 

Alternative is HeidiSql, but i don't think that this one supports procedures, at least i failed at figuring out how to create and manage them.

Another alternative is PhpMyAdmin, but quite frankly managing databases online is ridiculous, way to slow. However it support all MySql features.

 

All the above is free, MySql Tools can be found on MySql official site.

Link to post
Share on other sites
  • 5 years later...
  • 1 year later...
  • 3 months later...
  • 1 month later...
  • 8 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

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.