Take the 2-minute tour ×

I am trying to set a password for my phpmyadmin.my config.ini file is

 * Generated configuration file
 * Generated by: phpMyAdmin setup script
 * Date: Sun, 22 Jul 2012 11:33:17 +0000

/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$cfg['Servers'][$i]['password'] = 'triple';

/* End of servers configuration */

$cfg['blowfish_secret'] = '500be38d07a469.36176220';
$cfg['DefaultLang'] = 'en';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

but the problem is, it letting me in using whatever input as password.like(khfjsdhfj).whats wrong?How can I set it?just for information previously i did not have any password to log in.

share|improve this question

1 Answer 1

The password is saved in the database. You can set the Permissions on your database with a query like this:

GRANT <permissions> ON <database>.<table> TO <user> IDENTIFIED BY PASSWORD '<password>';

You can also try to set the permissions and password with PHPMyAdmin. Look out for the database permissions and set a password there.

The reason why PHPMyAdmin logs you in is that you set

$cfg['Servers'][$i]['nopassword'] = true;   <-- If password fails try 
                                                username and empty Password

And you obviously don't have a password on your DB

share|improve this answer

Your Answer


