Mysql configure error in xampp

Asked

Viewed 584 times

1

I’m setting up the XAMPP v3.2.2 and my MySQL is not working, follows the error:

Error: MySQL shutdown unexpectedly.

5:46:11 PM [mysql] This may be due to a blocked port, Missing dependencies,

5:46:11 PM [mysql] Improper privileges, a crash, or a shutdown by Another method.

5:46:11 PM [mysql] Press the Logs button to view error logs and check

5:46:11 PM [mysql] the Windows Event Viewer for more Clues

5:46:11 PM [mysql] If you need more help, copy and post this

5:46:11 PM [mysql] entire log window on the forums

The solutions found on the Internet boil down to delete the ibdata1 file in the directory xampp/mysql/data. This solution did not work as I delete the file and run MySQL in the Control Panel of Xampp it creates that file again.

And the other solution would be to change the door which by default is 3306, was changed to 3307, but unsuccessfully too.

Would anyone have any possible solution?

mysql xampp
  • 1

    Make sure Skype is not using port 80, it usually hangs the xampp. Ultimately, delete the xampp and try to reinstall the latter website version:

  • I don’t have skype installed. I will reinstall XAMPP and comment again. Thank you.

  • 1

    Don’t forget to back up htdocs.

2 answers

0

Hello, I decided to go to the icon of Mysql Notifier and giving stop.

inserir a descrição da imagem aqui

0

Hello I recently had the same problem. Below is the solution to solve:

  1. Leave Xampp;
  2. Access your installation directory enter the Date folder,(Default: C: xampp mysql data);
  3. Select all files: aria_log, ib_buffer, ib_logfile, ibdata1, master-xxxx@xxx, multi-master, mysql_error, mysql-Relay-bin-2019@, Relay-log-xxxx@ (Except the Folders where the bds and my file are (mysql configuration)), excludes all; Note: x represents what is on your pc, can be date or other writing.
  4. Restart your PC;
  5. After logging in, just open Xampp normally. Only there you can delete all files from the recycle bin.

Any doubt just return ok! Whatever is possible I will help.

Browser other questions tagged mysql xampp

You are not signed in. Login or sign up in order to post.