gnuffo1 Posted February 1, 2006 Share Posted February 1, 2006 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 Link to comment Share on other sites More sharing options...
fenway Posted February 1, 2006 Share Posted February 1, 2006 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. 1 Link to comment Share on other sites More sharing options...
wickning1 Posted February 2, 2006 Share Posted February 2, 2006 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 comment Share on other sites More sharing options...
fenway Posted February 2, 2006 Share Posted February 2, 2006 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 comment Share on other sites More sharing options...
gnuffo1 Posted February 2, 2006 Author Share Posted February 2, 2006 [!--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 comment Share on other sites More sharing options...
audiopanik Posted July 27, 2006 Share Posted July 27, 2006 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 comment Share on other sites More sharing options...
fenway Posted July 27, 2006 Share Posted July 27, 2006 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 comment Share on other sites More sharing options...
wildteen88 Posted July 27, 2006 Share Posted July 27, 2006 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 comment Share on other sites More sharing options...
fenway Posted July 27, 2006 Share Posted July 27, 2006 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 comment Share on other sites More sharing options...
wildteen88 Posted July 27, 2006 Share Posted July 27, 2006 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. Link to comment Share on other sites More sharing options...
cirene Posted July 12, 2008 Share Posted July 12, 2008 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 comment Share on other sites More sharing options...
vikramjeet.singla Posted July 12, 2008 Share Posted July 12, 2008 you may use mysql adminstrator, mysql query browser.... mysql front and mysql yog but i m not sure whether they are free or not Link to comment Share on other sites More sharing options...
next Posted July 12, 2008 Share Posted July 12, 2008 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 comment Share on other sites More sharing options...
bluejay002 Posted July 12, 2008 Share Posted July 12, 2008 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. Link to comment Share on other sites More sharing options...
sathishnadu Posted March 14, 2014 Share Posted March 14, 2014 I use SQLyog for this. They do have a free version which is available here: https://code.google.com/p/sqlyog/wiki/Downloads Link to comment Share on other sites More sharing options...
Barand Posted March 19, 2014 Share Posted March 19, 2014 MySQL Admin is fine for editing records. Open a connection under "SQL Development" Right click a table name and select "Edit table data" Link to comment Share on other sites More sharing options...
sathishnadu Posted March 21, 2014 Share Posted March 21, 2014 There are many options. You can use HeidiSQL or SQLyog or navicat. HeidiSQL and SQLyog have free version but navicat is paid. Link to comment Share on other sites More sharing options...
sathishnadu Posted March 21, 2014 Share Posted March 21, 2014 I have used SQLyog for this. They do have a free version and you can download it from here: https://code.google.com/p/sqlyog/wiki/Downloads Link to comment Share on other sites More sharing options...
gristoi Posted March 21, 2014 Share Posted March 21, 2014 if you're using mysql then use the tool design by the people who made it: http://www.mysql.com/products/workbench/ Link to comment Share on other sites More sharing options...
gristoi Posted March 21, 2014 Share Posted March 21, 2014 mysql Workbench Link to comment Share on other sites More sharing options...
JordanS Posted April 28, 2015 Share Posted April 28, 2015 I like dbForge Studio for MySQL - http://www.devart.com/dbforge/mysql/studio/ It has free edition Link to comment Share on other sites More sharing options...
dalecosp Posted August 11, 2015 Share Posted August 11, 2015 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.... Link to comment Share on other sites More sharing options...
benanamen Posted September 22, 2015 Share Posted September 22, 2015 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. Link to comment Share on other sites More sharing options...
Dal1980 Posted September 27, 2015 Share Posted September 27, 2015 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 Link to comment Share on other sites More sharing options...
EricOnAdventure Posted June 15, 2016 Share Posted June 15, 2016 By far the best way that I find to edit a database is to export it to excel as a CSV, edit it, and import it back. Link to comment Share on other sites More sharing options...
Recommended Posts