pcelements
asked on
Unable to access phpMyAdmin
Hi:
When I try to access phpMyAdmin I get the following error:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
This is my config.inc.php file :
* cookie
*/
$cfg['blowfish_secret'] = 'a8b7dafdferHJHJ^&U^45776T IUuiYc6d'; /* YOU MUST FI$
COOKIE AUTH! */
/*
* Servers configuration
*/
$i = 0;
/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_ type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host' ] = 'localhost';
$cfg['Servers'][$i]['conne ct_type'] = 'tcp';
$cfg['Servers'][$i]['compr ess'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['exten sion'] = 'mysql';
/* User for advanced features */
// $cfg['Servers'][$i]['contr oluser'] = 'pma';
// $cfg['Servers'][$i]['contr olpass'] = 'pmapass';
/* Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb '] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookm arktable'] = 'pma_bookmark';
^G Get Help ^O WriteOut ^R Read File ^Y Prev Page ^K Cut Text ^C Cur Pos
^X Exit ^J Justify ^W Where Is ^V Next Page ^U UnCut Text^T To Spell
Thanks.
When I try to access phpMyAdmin I get the following error:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
This is my config.inc.php file :
* cookie
*/
$cfg['blowfish_secret'] = 'a8b7dafdferHJHJ^&U^45776T
COOKIE AUTH! */
/*
* Servers configuration
*/
$i = 0;
/*
* First server
*/
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_
/* Server parameters */
$cfg['Servers'][$i]['host'
$cfg['Servers'][$i]['conne
$cfg['Servers'][$i]['compr
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['exten
/* User for advanced features */
// $cfg['Servers'][$i]['contr
// $cfg['Servers'][$i]['contr
/* Advanced phpMyAdmin features */
// $cfg['Servers'][$i]['pmadb
// $cfg['Servers'][$i]['bookm
^G Get Help ^O WriteOut ^R Read File ^Y Prev Page ^K Cut Text ^C Cur Pos
^X Exit ^J Justify ^W Where Is ^V Next Page ^U UnCut Text^T To Spell
Thanks.
If this is a new set up then it may be that root has no password set. Try logging into phpMyAdmin as root with no password. If that fails then try logging in as root with the existing root password.
If your setup is on Windows with IIS and PHP 5.3 it will not accept 'localhost' ast the host. You should change this value to 127.0.0.1
So...
So...
$cfg['Servers'][$i]['host'] = 'localhost';
... becomes...$cfg['Servers'][$i]['host'] = '127.0.0.1';
Is this a shared or your own server you are trying to use phpMyAdmin on? Only the server administrator should have access to the MySQL root account.
If you have just installed MySQL then the password will be blank, simply use root for the username and no password. If you still cannot login then you can reset your root password using the instructions below, I have used them many times myself. Simply run the commands on the server, replace "new-password" with a blank or password of your choice.
http://www.howtoforge.com/reset-forgotten-mysql-root-password
Once you restart MySQL then it should let you login with the password you have specified.
If you have just installed MySQL then the password will be blank, simply use root for the username and no password. If you still cannot login then you can reset your root password using the instructions below, I have used them many times myself. Simply run the commands on the server, replace "new-password" with a blank or password of your choice.
http://www.howtoforge.com/reset-forgotten-mysql-root-password
Once you restart MySQL then it should let you login with the password you have specified.
ASKER
This is my server and it is running Centos 5.5. The account root has a password. It is a new setup. Thanks!!
The MySQL root password is different to your centos root user password, if it is a new mysql setup then the default mysql root user password will be blank.
If it still does not work then try the fix I posted as a link.
If it still does not work then try the fix I posted as a link.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Unable to find solution.