MySQL shutdown unexprectedly, do I have to change the port ?

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

MySQL shutdown unexprectedly, do I have to change the port ?

Postby Danppar66 » 08. November 2017 15:37

Goodafternoon, my SQL shutdown unexpectedly,
i don't know exactly if i have to change the port's number of mySQL.
Actually the port's number of mySQL is 3306.
This is the error messagge appear in XAMPP comand:
Error: MySQL shutdown unexpectedly.
15:23:51 [mysql] This may be due to a blocked port, missing dependencies,
15:23:51 [mysql] improper privileges, a crash, or a shutdown by another method.
15:23:51 [mysql] Press the Logs button to view error logs and check
15:23:51 [mysql] the Windows Event Viewer for more clues
15:23:51 [mysql] If you need more help, copy and post this
15:23:51 [mysql] entire log window on the forums

I need a help please , thank you very much for your attention
regards
Daniele
Danppar66
 
Posts: 3
Joined: 08. November 2017 15:29
XAMPP version: 5.6.31
Operating System: Windows 10 64bit

Re: MySQL shutdown unexprectedly, do I have to change the po

Postby HokuApps » 09. November 2017 11:39

Hey I just did this and it worked:

1. exit Xampp server
2. go to your C:\xampp\mysql\data directory
3. delete the ibdata1 file
4. restart xampp server
5. It should work
HokuApps
 
Posts: 22
Joined: 11. September 2017 07:23
XAMPP version: 1.8.0
Operating System: Windows

Re: MySQL shutdown unexprectedly, do I have to change the po

Postby Danppar66 » 24. November 2017 16:04

Thank you very much for your advise...
I was able to change the MySQL port number because it was occupied by another instance, and now the server works.

But Xampp's phpMyAdmin does not work properly because it fails to connect to my MySQL ...
I ask you for some tips on how to run phpMyAdmin thanks again to your help
Danppar66
 
Posts: 3
Joined: 08. November 2017 15:29
XAMPP version: 5.6.31
Operating System: Windows 10 64bit

Xampp phpMyAdmin fails to connect to MySQL server

Postby Danppar66 » 24. November 2017 16:19

Good evening,
my PC's Xampp phpMyAdmin fails to access MySQL.

This is the message that appears on the browser when loading localhost / phpMyAdmin:

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

mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)

mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO)

Do I have to reconfigure the configuration file?

Please ask your help on how to solve this problem
thanks for your attention
regards
Danppar66
 
Posts: 3
Joined: 08. November 2017 15:29
XAMPP version: 5.6.31
Operating System: Windows 10 64bit

Re: MySQL shutdown unexprectedly, do I have to change the po

Postby Altrea » 24. November 2017 16:54

You changed the MariaDB default port.
phpMyAdmin connects on IP and port.

So what do you think you are missing here!?
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: 11926
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 138 guests