Forum Moderators: coopster

Message Too Old, No Replies

how to set phpmyadmin password

         

kingkol

7:07 am on Jul 1, 2011 (gmt 0)

10+ Year Member



Hi,

new in php.I am unable to set up password for phpmyadmin.I have set up my cofig.ini file.

its like--
/* Servers configuration */
$i = 0;

/* Server: localhost [1] */
$i++;
$cfg['Servers'][$i]['verbose'] = '';
$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'] = 'dingdong';

/* End of servers configuration */

$cfg['DefaultLang'] = 'en-utf-8';
$cfg['ServerDefault'] = 1;
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>

when try to log in it gives
#1045 - Access denied for user 'root'@'localhost' (using password: YES)

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

how to fix it?many thanks in advance
kingkol

coopster

2:51 pm on Aug 31, 2011 (gmt 0)

WebmasterWorld Administrator 10+ Year Member



This merely sets up the password that phpMyAdmin is going to use to connect to the MySQL database server. You need to find out what the user id and password are that your MySQL database administrator (your hosting provider, most likely) set up for you.