Jump to content


Photo

Windows GUI for MySQL


  • Please log in to reply
28 replies to this topic

#1 gnuffo1

gnuffo1
  • Members
  • PipPip
  • Member
  • 10 posts

Posted 01 February 2006 - 04:28 PM

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
[a href="http://www.sentinelpc.co.uk" target="_blank"]Sentinel Technology - Custom PCs and Laptops[/a]

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 01 February 2006 - 04:33 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 wickning1

wickning1
  • Members
  • PipPipPip
  • Advanced Member
  • 405 posts

Posted 02 February 2006 - 02:51 AM

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.

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 02 February 2006 - 04:04 AM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#5 gnuffo1

gnuffo1
  • Members
  • PipPip
  • Member
  • 10 posts

Posted 02 February 2006 - 11:30 AM

[!--quoteo(post=341978:date=Feb 2 2006, 04:04 AM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Feb 2 2006, 04:04 AM) View Post[/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.
[/quote]

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
[a href="http://www.sentinelpc.co.uk" target="_blank"]Sentinel Technology - Custom PCs and Laptops[/a]

#6 audiopanik

audiopanik
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 27 July 2006 - 03:39 PM

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.

#7 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 27 July 2006 - 03:46 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#8 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 27 July 2006 - 04:01 PM

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

#9 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 27 July 2006 - 04:18 PM

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.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#10 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 27 July 2006 - 04:22 PM

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.

#11 cirene

cirene
  • Members
  • PipPip
  • Member
  • 17 posts

Posted 12 July 2008 - 02:25 AM

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!

#12 vikramjeet.singla

vikramjeet.singla
  • Members
  • PipPipPip
  • Advanced Member
  • 101 posts
  • LocationIndia

Posted 12 July 2008 - 05:51 AM

you may use mysql adminstrator, mysql query browser....
mysql front and mysql yog but i m not sure whether they are free or not

#13 next

next
  • Members
  • PipPipPip
  • Advanced Member
  • 141 posts

Posted 12 July 2008 - 06:38 AM

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.

#14 bluejay002

bluejay002
  • Members
  • PipPipPip
  • Advanced Member
  • 452 posts

Posted 12 July 2008 - 08:41 AM

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. :)
Trust in the Lord with all thine heart and lean not unto thine own understanding; In all thy way acknowledge Him and He shall direct thy path.

----- PS ----- VISIT MY BLOGS --> http://bluejay002.wordpress.com

Codes and/or query posted are mostly untested so test them first before using. I am pretty lazy reading long posts, please refrain from posting long posts and get directly to the point. :)

#15 sathishnadu

sathishnadu
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 14 March 2014 - 12:59 PM

I use SQLyog for this. They do have a free version which is available here: https://code.google..../wiki/Downloads



#16 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,017 posts

Posted 19 March 2014 - 05:34 PM

MySQL Admin is fine for editing records.

 

Open a connection under "SQL Development"

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


If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#17 sathishnadu

sathishnadu
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 21 March 2014 - 06:33 AM

There are many options. You can use HeidiSQL or SQLyog or navicat. HeidiSQL and SQLyog have free version but navicat is paid.



#18 sathishnadu

sathishnadu
  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 21 March 2014 - 07:20 AM

I have used SQLyog for this. They do have a free version and you can download it from here: https://code.google..../wiki/Downloads



#19 gristoi

gristoi
  • Members
  • PipPipPip
  • Advanced Member
  • 848 posts

Posted 21 March 2014 - 02:36 PM

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

 

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


To err is human... to really foul up requires the root password

#20 gristoi

gristoi
  • Members
  • PipPipPip
  • Advanced Member
  • 848 posts

Posted 21 March 2014 - 04:22 PM

mysql Workbench


To err is human... to really foul up requires the root password




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users