Jump to content

Recommended Posts

Im using a mac and whenever I go to phpmyadmin and try to change the password, there is a code that says (posted below)

 

Error

MySQL said:

 

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

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.

 

If I uninstall and then install xampp, it works fine again until I try to add a password, because then the same problem occurs.

 

Thanks

Link to comment
https://forums.phpfreaks.com/topic/244089-cant-change-the-password-for-phpmyadmin/
Share on other sites

You will have to add your password into the phpmyadmin config file.

 

It's windows location is "serverRootFolder/apps/phpmyadmin(versionNumber)/config.inc.php". Not sure if that helps with Mac.

 

There is an array that holds all the data.  Self explanatory.

If you change it in the database via phpmyadmin, then you will still have to configure phpmyadmin to work with the new password.  As it isn't the database, but rather a program that accesses the database.  If you cannot access phpmyadmin, you can still use mysql via the console (mysql.exe).

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.