Add authentication to phpMyAdmin

phpMyAdmin is a very useful tool for www access to your MySQL database.

We know that MySQL is the great free database system and was developed under linux first. It comes with only command prompt interface. Of course for those who is familar with it this does not gives any trouble. But for a newbie like me emoticon , it was so difficult to remember these keystrikes.

Thanks to the phpMyAdmin. With it we can do nearly everything by browser like IE or FF.

But normally,to use phpMyAdmin we need to modify the config.inc.php and write your user name and password into it, otherwise you will get an error message which tells you "#1045 - Access denied for user ‘ODBC’@'localhost’ (using password: NO)". It is the normal way, but sometimes we want to enter the appropriate information when using phpMyAdmin.

So here is the right way, very easy:

Open the config.inc.php with a editor. I suggest to use EmEditor. Of course you can use and editor, like UltraEdit or Edit Plus, even notepad
Search the keyword "auth_type" and change its value from ‘config’ to ‘http’. This step enables you to enter username and password by browser.
Save the config file and refresh your browser.