Page 1 of 1

Something Better Than phpMyAdmin

Posted: Tue Jan 23, 2007 9:23 pm
by jbflam
I have been using phpmyadmin for the past 6 years.
These last few days i tried some other mysql database management software such as SQLyog, navicat and heidisql, and wasn't convinced by them finally. I find the interfaces too complexe and not user friendly enough.
Maybe i am too used to phpMyAdmin...

So now i am wondering if anyone used any application that they feel is "better" than phpMyAdmin.
Do you know anything more user friendly than phpMyAdmin ?

Please avoid mentioning shell ;) ...

Thanks

JB

Posted: Tue Jan 23, 2007 9:30 pm
by feyd
Sorry, MySQL command-line is it.

Posted: Wed Jan 24, 2007 1:27 am
by jmut
I would second feyd on command line.
But what is that you lack as functionality in phpmyadmin. Why don't you like it no more?

Posted: Wed Jan 24, 2007 1:45 am
by kaszu
I'm using "mysql query browser" and "mysql administrator", i have never had a need and never liked phpMyAdmin.
Unless you can't install a software, i would suggest these.

Posted: Wed Jan 24, 2007 2:41 am
by jbflam
jmut wrote:I would second feyd on command line.
But what is that you lack as functionality in phpmyadmin. Why don't you like it no more?
I still like it and use it.
I d like to find something where i store procedures, where i can a global view of my tables, something a bit more dynamic (ajax), i am open to desktop apps as well as it would simplify access to production servers (No more command lines ;) )

Just trying to find something with more functionalities... As i said i tried 3 desktop apps , and i think they are not very user friendly and messy...

Command line is all but user friendly. For example, take an intern guy in your office, show him phpmyadmin then tell him if he prefers to use mysql command line. In most cases the guy will use phpmyadmin... ( Looks like a debate on using "vi / emacs" or an IDE )

Posted: Wed Jan 24, 2007 3:30 am
by CoderGoblin
Another one for the command line. Something to bear in mind is if you are ever at a client, you may not have access to anything but the command line. You should know how to do everything from it.

Posted: Wed Jan 24, 2007 3:51 am
by jbflam
CoderGoblin wrote:Another one for the command line. Something to bear in mind is if you are ever at a client, you may not have access to anything but the command line. You should know how to do everything from it.
Ok but when you are in your office you can find better tools to work faster ?
Do you wear army boots while sitting in your sofa ;-) ?

Posted: Wed Jan 24, 2007 10:58 am
by jmut
jbflam wrote:
CoderGoblin wrote:Another one for the command line. Something to bear in mind is if you are ever at a client, you may not have access to anything but the command line. You should know how to do everything from it.
Ok but when you are in your office you can find better tools to work faster ?
Do you wear army boots while sitting in your sofa ;-) ?
well working comand line is ways faster..that is for sure.
The thing is you should invest more time upfront to get used to it and see the benefits.
I know mysql support guys (I suppose all them do) who uses command line only. And it is not only that he does not hava phpmyadmin where client is, the main reason is that it is just faster.

P.S. Don't take this as do not look for a good tool :). And no, I don't use command line.
Let us know when you find the one.

Posted: Wed Jan 24, 2007 11:07 am
by feyd
I only use the command-line. Why? The security hole often created to have phpMyAdmin running on the server with the data... plus there are some things phpMyAdmin just can't do without you performing the commands yourself.

Posted: Wed Jan 24, 2007 11:23 am
by Burrito
you might try heidiSQL

Posted: Wed Jan 24, 2007 11:36 am
by AKA Panama Jack
jmut wrote: well working comand line is ways faster..that is for sure.
Not hardly.

Some of the things I do with phpMyAdmin would be tedious and mind numbingly slow. One of the nice things about phpMyAdmin is you can select from the list view a number of totally disparate entries and change them all on one screen. It makes for some very, very fast editing.

If I had to resort to using the command line I would probably shoot myself in the head. The command line really isn't any faster. Especially if you have to make a bunch of changes to many different things. Plus the command line is more difficult to keep track of many different tables, databases and other data. With phpMyAdmin I can have a dozen different windows open on different databases, tables, etc and easily move data around between them.

Command Line = Doing trig calculations totally by hand.

phpMyAdmin = Doing trig calculations using a math calculator.

:)

The purists like doing it by hand but the people who want to get the most work done use the calculator. ;)

Posted: Thu Jan 25, 2007 12:51 am
by dibyendrah
There are mostly commercial software which are fascinating like Aqua Data studio, SQLyog, Navicat etc. and need a big price to pay. So, I rather stick with phpmyadmin in my Linux machine. I comfortably use mysql-query-browser, mysql-admin which are free and also easy to use GUIs.

Posted: Thu Jan 25, 2007 3:28 am
by CoderGoblin
jbflam wrote:Do you wear army boots while sitting in your sofa ;-) ?
If my wife would let me yes :wink:

I admit phpMyAdmin and it's ilk do have some advantages when it comes to finding out information if you are unsure of your database structure and for other tasks, such as renaming tables, it seems to be quicker. I could argue though that if you rely on always having the database structure supplied to you graphically, you are less likely to learn it and profit from the speed increase that knowledge brings. If you have to look things up to write a request in PHP, it will be slower that if you had that knowledge in your head and could just type it.

We could discuss this "until the cows come home" and it doesn't really answer your question but here is a possible useful link (although I do not know the status of it - workbench at the moment is only Alpha at the time of writing), MySQL GUI Tools Downloads. When the workbench is stable and fully released I can see it being a very useful tool even outside MySQL.

Posted: Thu Jan 25, 2007 1:44 pm
by daedalus__
MySQL GUI Tools/Command Line FTW!!!!