Apache Friends Support Forum

I reinstalled xampp and tried to launch MySQL after I have changed the root password. Upon doing so,
I have received access denied via web browser, that says phpmyadmin tried to connect to mysql server but failed.
Could anyone please help me in troubleshooting launching MySQL?

Bannerguy wrote:after I have changed the root password.

How and where did you change the root password?

Bannerguy wrote:Upon doing so,
I have received access denied via web browser, that says phpmyadmin tried to connect to mysql server but failed.
Could anyone please help me in troubleshooting launching MySQL?

An error message from Phpmyadmin DOES NOT mean, that MySQL hat not been launched successfully. The Xampp Controlbox should show up whether MySQL has been started or not. After changing the root password in MySQL you also have to adapt the config file config.inc.php from Phpmyadmin and provide the new password, otherwise Phpmyadmin cannot login to MySQL.

Finally, dont fumble and play around with root passwords etc. as long as you have no idea, what you are doing there. There is no need for changing the root password for MySQL in an development environment.

Followed this guide: [Q&A] Setting MySQL root password

I changed the root password before launching the myphpadmin, Though I now have discover that I would first need to launch the admin first.

Also, is it recommended to setup a root password? I notice that the mysql has a user already. I'm looking to use this for developing a website.
Thanks for the help guys, mucho appreciated.

Bannerguy wrote:Also, is it recommended to setup a root password?

- phpMyAdmin can only get accessed from localhost
- MySQL logins for root user will only be permitted from localhost

So, if no other user than you is able to place a script inside your Apache requestable folder
And no other user will login on that computer
Then there is no need to set a root password.

Bannerguy wrote:I notice that the mysql has a user already.

!? MySQL Users and phpMyAdmin users are the same.