Something Better Than phpMyAdmin

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jbflam
Forum Newbie
Posts: 7
Joined: Wed Jan 10, 2007 3:48 am
Location: Singapore

Something Better Than phpMyAdmin

Post 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
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Sorry, MySQL command-line is it.
jmut
Forum Regular
Posts: 945
Joined: Tue Jul 05, 2005 3:54 am
Location: Sofia, Bulgaria
Contact:

Post 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?
User avatar
kaszu
Forum Regular
Posts: 749
Joined: Wed Jul 19, 2006 7:29 am

Post 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.
jbflam
Forum Newbie
Posts: 7
Joined: Wed Jan 10, 2007 3:48 am
Location: Singapore

Post 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 )
User avatar
CoderGoblin
DevNet Resident
Posts: 1425
Joined: Tue Mar 16, 2004 10:03 am
Location: Aachen, Germany

Post 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.
jbflam
Forum Newbie
Posts: 7
Joined: Wed Jan 10, 2007 3:48 am
Location: Singapore

Post 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 ;-) ?
jmut
Forum Regular
Posts: 945
Joined: Tue Jul 05, 2005 3:54 am
Location: Sofia, Bulgaria
Contact:

Post 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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post 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.
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

you might try heidiSQL
User avatar
AKA Panama Jack
Forum Regular
Posts: 878
Joined: Mon Nov 14, 2005 4:21 pm

Post 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. ;)
User avatar
dibyendrah
Forum Contributor
Posts: 491
Joined: Wed Oct 19, 2005 5:14 am
Location: Nepal
Contact:

Post 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.
User avatar
CoderGoblin
DevNet Resident
Posts: 1425
Joined: Tue Mar 16, 2004 10:03 am
Location: Aachen, Germany

Post 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.
User avatar
daedalus__
DevNet Resident
Posts: 1925
Joined: Thu Feb 09, 2006 4:52 pm

Post by daedalus__ »

MySQL GUI Tools/Command Line FTW!!!!
Post Reply