phpMyAdmin not allowing access
i am using WAMP/ phpMyAdmin but failed to access it :(开发者_如何学Go it requires a password and giving root username and blacnk password denies access !!!
have a look at http://dev.mysql.com/doc/refman/5.1/en/adding-users.html
create a new account then open the config.inc.php from phpMyAdmin directory and made these changes
<?php
/* Servers configuration */
$i = 0;
/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = 'localhost';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
$cfg['Servers'][$i]['AllowNoPassword'] = true;
/* End of servers configuration */
$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>
reinstall Wamp might be a solution, i like everything in it's default condition
精彩评论