Friday, July 3, 2009

PHP MySQL MyAdmin Login

If You are using WAMP , then this might be a trouble, once u change the root password, and then u try to connect to localhost , and get this message :

#1045 - Access denied for user 'root' 'localhost' (using password: NO)


you should navigate to " C:\wamp\apps\phpmyadmin3.1.3.1\config.inc.php or go to folder and use search to find the file
config.inc.php

here you just have to change the user to root, or one u have used , and password to what you have set.

$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'] = 'yourPassword';
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;


Try connecting to MySql Again .... bingo it works


No comments: