I installed Wampp and Joomla2,5,9 on my PC. Joomla seems to work correct, but accessing
phpMyadmin still prompt an error:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
pphpMyAdmin tried to connect to the MySQL server, but the server refused the connection. Check the machine, the username and password in config.inc.php and make sure that they correspond to the information provided by the administrator of the MySQL server was
3-It is useful to begin by assigning the new password using the following command:
SET PASSWORD FOR root @ localhost = PASSWORD ('yourpassword');
4-Then there is no need to reassign the superuser using the following command:
mysql> GRANT ALL PRIVILEGES ON *. * TO root @ localhost IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
Of course you have to insert the host name and user account with the default password set up in the file 'php.ini' to the next level:
; Default host for mysql_connect () (does not apply in safe mode).
mysqli.default_host = 'localhost'
; Default user for mysql_connect () (does not apply in safe mode).
mysqli.default_user = 'root'
; Default password for mysqli_connect () (does not apply in safe mode).
; That Note Generally this is a * bad * idea to store passwords in this file.
; * Any * user with PHP access can run 'echo get_cfg_var ("mysqli.default_pw")
; And reveal this password! And of course, any, users with read access to this
; File will be ble to reveal the password as well.
mysqli.default_pw = 'mypassword'
It only remains to make the implementation of host names and user account with the default password in the file 'config.inc.php' the following lines:
