This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
May 24, 2012 8:56am
Subscribe [6]#1 / May 24, 2012 8:56am
Does anyone know of a script or Mac app that allows the user to browse a MySql database (not EE)? I’ve searched high and low and not found anything.
Basically they need to browse or lookup certain bits of data, such as an email address, but not edit it. The user is non tecchy so needs to be relatively easy to use.
#2 / May 28, 2012 5:21pm
I am a fan of Navicat - http://www.navicat.com/
Depending on their needs you could create a View for them or else set the MySQL user permissions so that updates were not allowed.
#3 / May 29, 2012 3:51pm
I’ve used Sequel Pro before when phpMyAdmin wasn’t an option and found it useful:
http://www.sequelpro.com/
#4 / May 30, 2012 10:58am
The above are main ones, but i also like http://www.webyog.com/en/ SQLYOG
#5 / May 30, 2012 12:42pm
I am a fan of Navicat - http://www.navicat.com/
Depending on their needs you could create a View for them or else set the MySQL user permissions so that updates were not allowed.
big time. We use Navicat for everything from minor queries, to full db backups, synchronization etc.
it becomes one of those things that when you don’t have it due to a client restricting things, you feel like you’re missing your right hand
#6 / Jun 07, 2012 5:23am
Thanks everyone!
#7 / Jun 15, 2012 11:14pm
Sequel pro for sure. Everyone in our office uses it religiously. That and the command line.
#8 / Jul 03, 2012 3:06pm
If for viewing only, MySQL Workbench is good enough.