MySQL not connecting

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL not connecting

Postby Bannerguy » 23. March 2016 03:08

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
 
Posts: 5
Joined: 11. March 2016 21:27
Operating System: windows 10

Re: MySQL not connecting

Postby Nobbie » 23. March 2016 11:04

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.
Nobbie
 
Posts: 13182
Joined: 09. March 2008 13:04

Re: MySQL not connecting

Postby Altrea » 23. March 2016 11:31

Followed this guide: [Q&A] Setting MySQL root password :?:
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: MySQL not connecting

Postby Bannerguy » 29. March 2016 23:42

I changed the root password before launching the myphpadmin, Though I now have discover that I would first need to launch the admin first.
Bannerguy
 
Posts: 5
Joined: 11. March 2016 21:27
Operating System: windows 10

Re: MySQL not connecting

Postby Bannerguy » 29. March 2016 23:43

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
 
Posts: 5
Joined: 11. March 2016 21:27
Operating System: windows 10

Re: MySQL not connecting

Postby Altrea » 31. March 2016 09:27

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 110 guests

cron