[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


phpmyadmin vs query editor

Posted on 2011-10-28
Medium Priority
Last Modified: 2012-05-12
if phpmyadmin can not do triggers and stored procedures, how to do them

what are other limitations of phpmyadmin

without recommending other tools
because I am forced to use phpmyadmin so I need to tell the people why we should use mysql managment tools query editor
Question by:rgb192
  • 3
  • 2

Accepted Solution

PranjalShah earned 1000 total points
ID: 37048049
I think you can just tell the people that phpmyadmin is not the best tool to write procedures, triggers etc. You can find the arguments on google as well.
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 1000 total points
ID: 37048067
>>I need to tell the people why we should use mysql managment tools query editor

So you are in a debate with co-workers/management/???

What are your suggestions you want to use?  There is likely many comparisons out there between PhpMyAdminSucks and whatever it is.

In the past when I have had to defend a position, there is nothing like a real-world example not something found online or a story from someone else.

Have your other tool in your back pocket and someday the limitations of a web-only tool will present itself.

I'm far from a MySQL Expert but Oracle has it's own GUI web based tool and even it has 'faults' but then again, I'm an old command line guy from WAY back!

As a general overview I cannot say it much better than:


Expert Comment

ID: 37048071
@slightwv..very well said..
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37048079
>>@slightwv..very well said..

LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37048095
>>someday the limitations of a web-only tool will present itself.

oops...  forgot to finish that thought!

When the limitation does show up, you get to say: Now can we look into using 'X' that I suggested a few months/weeks (hopefully not years) ago?  This could have been avoided because 'X' allows for you to do <insert feature here>.

Just make your point as professional as you can stating the benefits of using 'X' over phpmyadmin.

and as BAD as you want to:  Don't say "nana nana boo boo"  told you so!!!  That could be career limiting.  ;)

Author Closing Comment

ID: 37048344
both describe the answer

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question