MySQL stopped working in XAMPP [pending]

Question

MySQL stopped working in XAMPP [pending]

Navigation

#1 by (0 votes)

-1

17:48:20  [mysql]   Error: MySQL shutdown unexpectedly.
17:48:20  [mysql]   This may be due to a blocked port, missing dependencies, 
17:48:20  [mysql]   improper privileges, a crash, or a shutdown by another method.
17:48:20  [mysql]   Press the Logs button to view error logs and check
17:48:20  [mysql]   the Windows Event Viewer for more clues
17:48:20  [mysql]   If you need more help, copy and post this
17:48:20  [mysql]   entire log window on the forums

mysql xampp

asked by anonymous 06.03.2018 / 21:52

1 answer

Doubt over ByPass strcmp from php I can not do insert with array

score 0 · Answer 1

This error occurs when there is a port being blocked to resolve to terminate any program running on port 3306

Or change the door to another To make the change run your xampp-control.exe usually stays in c: / xampp

Go to config > > myini see image below

Thetexteditorwillopen

searchforthisline

#password=your_passwordport=3306socket="C:/xampp/mysql/mysql.sock"

and change port = 3306 to the port that is open as 8080 or any other

Start Mysql should work remembering that now you will have to use Mysql as following url

localhost:suaporta

EDIT

To check blocked pots run cmd.exe as an administrator (search the start menu, right click, run as admin)

Set your directory to c: / with the command cd c:/ now run the following command netstat -b > lista.txt

and you will see a list of used ports look for the service and finish it