phpMyAdmin config problem
submitted 1 year 1 month 7 hours ago by: sadiaTabasum : 3 commentsHay to every one!!!
i m working with WAMP, when we run it first time, phpmyadmin starts with NO PASSWORD, what i had done in my previouse practise? i just made changes in congfig.inc.php for the following variables to set the password:
$cfg['Servers'][$i]['password'] = 'abc123';// it waz empty, i set its value.
$cfg['SQLValidator']['username'] = 'root'; // it waz empty, i set its value
$cfg['SQLValidator']['password'] = abc123; // it waz empty, i set its value
these changes were working sucessfully, but now after making these changes i get following error:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
kindly some one do the favor and guide me that how can i set password, i ve also set password by phpmyadmin interface by applying MD5 function, but it also had no effect. i had also change these varible's values in phpmyadmin\...\libraries\config.defult.php, i had change the value of $cfg['Servers'][$i]['nopassword'] = FALSE; but :(
so kindly tell me the solution except these ones.
Best Regards,
Sadia Tabasum
Comments
In order to set mysql password
1.locate bin folder in mysql directory. That might locate in ur C Drive.
2.Open a command prompt window.
3.Now locate bin directory in command prompt.
4. Your path might be look like this in command prompt. C:\ program files\wamp\mysql\bin>
5.now wirte this command in command prompt
mysql --user=your_database_user_name --password=your_database_password
6.Type this command and press enter
7.your resulting screen might be look like this
C:\ program files\wamp\mysql\bin>mysql --user=root --password=123
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 5.0.41-community-nt MySQL Community Edition (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
8.Now type this command
SET PASSWORD FOR ''your_database_user_name@'localhost' = PASSWORD('newpassword');
9. Your resulting screen might be look like this
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpassword');
Query OK, 0 rows affected (0.03 sec)
mysql>
this might help u.
i ve done with phpMySQL interface and by applying password function instead of MD5, and then just enter this password in config.inc.php file. its working succesfully
Best Regards,
Sadia Tabasum
Re Install Windows XP :P