Linux Today: Linux News On Internet Time.

Top 10 phpMyAdmin Tips and Tricks You May Not Know

Feb 08, 2011, 23:04 (0 Talkback[s])
(Other stories by W. Jason Gilmore)

"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

Related Stories: