I have recently been working on a web project that makes intensive use of MySQL database with a few stored functions and procedures. It’s not always straight forward to use and in fact here is my short story.
As I usually do, I started the project running it on my local machine. Once I started transferring operations of the web site to an online environment I started to have a few headaches. I discovered that there weren’t any evident ways I could use the stored routines that I previously created.
I love phpMyAdmin, it’s very powerful and the interface is really usable, ut unfortunately recent versions of this database management software do not support views, functions and stored procedures.
Beside this some hosting providers do not offer SSH/telnet support to connect to the database and perform more advanced operations.
So I have done some googling and some research on phpmyadmin wiki and decided to to install an older version of this database management software, precisely the 2.11.9.5. It worked perfectly for the job. All I had to do was to run my prepared queries in the SQL editor.
However another route is to build a bespoke script that runs on the server. I have found spEditor which is a script based on PHP and it seems to be a valid solution: easy to install and configure, but also less demanding than phpmyadmin.
