I use phpMyAdmin for managing many of my databases, as it’s quick and easy to setup, and I don’t have to enable Internet access to the MySQL server (directly anyways). I use it in both development & production, which brings up an interesting problem. I often have multiple PMA tabs open at one time, and sometimes get development/production mixed up and make changes I shouldn’t. Normally I’m pretty careful about this, but sometimes your co-worker goes in and drops all of your databases by mistake…. Tip #1, keep good backups. Luckily I had that tip down pat. Tip #2, don’t give co-workers drop privileges on your database if they don’t need it. Lesson learned. 🙂
Both of these tips are great advice, but they don’t address the issue of mixing up your tabs. Thankfully, I found a solution.
This banner shows up on every page within phpMyAdmin, and I didn’t even have to hack any core files to do it! In your main phpMyAdmin directory, create a file called
config.header.inc.php
and put the following in it to achieve the same effect:
<style> #floating_menubar { top: 41px!important; } </style> <div style="height:40px;"></div> <h1 style="position:fixed;top:0;left:0;width:100%;z-index:510000;background:#ffc0cb;margin:0;color:#000;line-height:40px;padding:0 10px;border-bottom: 1px solid #800000;font-weight:normal;"> Warning! You Are In Production. Proceed With Caution. </h1>
Hopefully this will help to avoid the same mishap in the future!
Thanks for that post. I am one and know several of those idiots that Matthew recognises so clearly.
I had been looking to find out where the header file should be located. After playing with the html for a bit, I was not happy with how to remainder of the page flows after the header.
I have since copied a theme and replaced the file logo-left.png with one that identifies the database. Just three steps required:
1. Copy an existing theme
2. Drop a new image called logo-left.png into the img folder for the new theme
3. Edit info.inc.php in the theme root to change the theme_name
What kind of idiot drops a database full of tables 🙂