Top 10 phpMyAdmin Tips and Tricks You May Not Know

“First released in 1998, phpMyAdmin is one of the longest
running and most popular PHP projects on the planet. One of the
first utilities mentioned within PHP and MySQL tutorials, and
ubiquitously available on Web hosting providers, over the years
phpMyAdmin has grown to be an indispensable tool within every PHP
developer’s toolbox. Despite approaching its 12th birthday,
phpMyAdmin is still under active development, with at least one
significant version released every year since the project’s
inception. In fact even after almost a decade of use I still marvel
over discovering features which I had no idea existed. In this
article I thought I’d highlight 10 useful phpMyAdmin features which
may have escaped you during your daily interaction with this
fantastic utility.

“1. Manage User Privileges

“MySQL offers a powerful user privilege management system which
allows you to manage a user’s ability to interact with MySQL at the
database, table, and even column level. These privileges are
managed using two MySQL commands, namely grant and revoke, and
unless you work with these commands on a regular basis, it’s almost
guaranteed you’ll be consulting the MySQL manual in order to recall
the syntax.

“Save yourself the hassle by clicking on phpMyAdmin’s Privileges
tab, located on the application’s top ribbon. There you’ll be able
to add and delete users, and use a simple series of checkboxes to
set and later modify a user’s privileges.

“2. Backup Your Databases”

Complete Story