Jump to content
gnuffo1

Windows GUI for MySQL

Recommended Posts

Preferably free. I did try MySQL administrator made by MySQL AB, but as far as I could see, it was mainly for monitoring the database and not editing records. Thanks

Share this post


Link to post
Share on other sites

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.

Share this post


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.

Share this post


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.

Share this post


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

Share this post


Link to post
Share on other sites

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.

Share this post


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.

Share this post


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

Share this post


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.

Share this post


Link to post
Share on other sites

No you dont you can select multiple records at any one time, by clicking the checkbox for each record you want to edit. The same applies for tables too.

Share this post


Link to post
Share on other sites

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!

Share this post


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.

Share this post


Link to post
Share on other sites

MySQL GUI is good, especially MySQL Query Browser.

 

If you are on a proprietary one, Navicat and SQLYog is pretty good but I prefer Navicat if given a choice. For now, I like going over Query Browser since its nice and free. :)

Share this post


Link to post
Share on other sites

MySQL Admin is fine for editing records.

 

Open a connection under "SQL Development"

Right click a table name and select "Edit table data"

Share this post


Link to post
Share on other sites

PHPMyAdmin for a web-based solution, HeidiSQL on the client-side.  It's fairly DB agnostic ... we first installed it for use against MSSQL DB's....

Share this post


Link to post
Share on other sites

Although not free, Navicat is by far the best Windows Mysql Gui. You can do anything and very easily. If you work with databases it is a very worthwhile investment.

Share this post


Link to post
Share on other sites

if you're using mysql then use the tool design by the people who made it:

 

http://www.mysql.com/products/workbench/

 

I'm surprised that this topic didn't end at this point. I too went looking for a tool to use with MySQL and was pleased to find Workbench after previously looking at Navicat and running a mile when I saw the price they wanted :)

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

×

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.