xampp will not start mysql

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

xampp will not start mysql

Postby drybank » 21. August 2017 21:09

I have run xammp for years without problems.
Now I cannot get into mysql.
Can anyone help.



21:17:12 [main] Initializing Control Panel
21:17:12 [main] Windows Version: Windows 7 Home Premium SP1 64-bit
21:17:12 [main] XAMPP Version: 1.8.3
21:17:12 [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
21:17:12 [main] You are not running with administrator rights! This will work for
21:17:12 [main] most application stuff but whenever you do something with services
21:17:12 [main] there will be a security dialogue or things will break! So think
21:17:12 [main] about running this application with administrator rights!
21:17:12 [main] XAMPP Installation Directory: "c:\xampp\"
21:17:12 [main] Checking for prerequisites
21:17:12 [main] All prerequisites found
21:17:12 [main] Initializing Modules
21:17:12 [Apache] XAMPP Apache is already running on port 80
21:17:12 [Apache] XAMPP Apache is already running on port 443
21:17:12 [main] The FileZilla module is disabled
21:17:12 [main] The Mercury module is disabled
21:17:12 [main] The Tomcat module is disabled
21:17:12 [main] Enabling autostart for module "Apache"
21:17:12 [main] Enabling autostart for module "MySQL"
21:17:12 [main] Starting Check-Timer
21:17:12 [main] Control Panel Ready
21:17:12 [Apache] Autostart aborted: Apache is already running
21:17:12 [mysql] Autostart active: starting...
21:17:12 [mysql] Attempting to start MySQL app...
21:17:13 [mysql] Status change detected: running
21:17:15 [mysql] Status change detected: stopped
21:17:15 [mysql] Error: MySQL shutdown unexpectedly.
21:17:15 [mysql] This may be due to a blocked port, missing dependencies,
21:17:15 [mysql] improper privileges, a crash, or a shutdown by another method.
21:17:15 [mysql] Press the Logs button to view error logs and check
21:17:15 [mysql] the Windows Event Viewer for more clues
21:17:15 [mysql] If you need more help, copy and post this
21:17:15 [mysql] entire log window on the forums
drybank
 
Posts: 3
Joined: 21. August 2017 21:03
XAMPP version: 1.8.3
Operating System: windows

Re: xampp will not start mysql

Postby Altrea » 21. August 2017 22:09

mysql_error.log contents?
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: 8892
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: xampp will not start mysql

Postby drybank » 22. August 2017 20:01

mysql _error. log entry

4832 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist

I may have deleted this table inadvertently when cleaning up my databases.
Can it be reinstated?
If so how?



Altrea wrote:mysql_error.log contents?
Altrea wrote:mysql_error.log contents?
drybank wrote:I have run xammp for years without problems.
Now I cannot get into mysql.
Can anyone help.



21:17:12 [main] Initializing Control Panel
21:17:12 [main] Windows Version: Windows 7 Home Premium SP1 64-bit
21:17:12 [main] XAMPP Version: 1.8.3
21:17:12 [main] Control Panel Version: 3.2.1 [ Compiled: May 7th 2013 ]
21:17:12 [main] You are not running with administrator rights! This will work for
21:17:12 [main] most application stuff but whenever you do something with services
21:17:12 [main] there will be a security dialogue or things will break! So think
21:17:12 [main] about running this application with administrator rights!
21:17:12 [main] XAMPP Installation Directory: "c:\xampp\"
21:17:12 [main] Checking for prerequisites
21:17:12 [main] All prerequisites found
21:17:12 [main] Initializing Modules
21:17:12 [Apache] XAMPP Apache is already running on port 80
21:17:12 [Apache] XAMPP Apache is already running on port 443
21:17:12 [main] The FileZilla module is disabled
21:17:12 [main] The Mercury module is disabled
21:17:12 [main] The Tomcat module is disabled
21:17:12 [main] Enabling autostart for module "Apache"
21:17:12 [main] Enabling autostart for module "MySQL"
21:17:12 [main] Starting Check-Timer
21:17:12 [main] Control Panel Ready
21:17:12 [Apache] Autostart aborted: Apache is already running
21:17:12 [mysql] Autostart active: starting...
21:17:12 [mysql] Attempting to start MySQL app...
21:17:13 [mysql] Status change detected: running
21:17:15 [mysql] Status change detected: stopped
21:17:15 [mysql] Error: MySQL shutdown unexpectedly.
21:17:15 [mysql] This may be due to a blocked port, missing dependencies,
21:17:15 [mysql] improper privileges, a crash, or a shutdown by another method.
21:17:15 [mysql] Press the Logs button to view error logs and check
21:17:15 [mysql] the Windows Event Viewer for more clues
21:17:15 [mysql] If you need more help, copy and post this
21:17:15 [mysql] entire log window on the forums
drybank
 
Posts: 3
Joined: 21. August 2017 21:03
XAMPP version: 1.8.3
Operating System: windows

Re: xampp will not start mysql

Postby efremmc2 » 27. August 2017 00:09

You have a port conflict. First, do a 'netstat -a' from a command prompt, in some version of the xmapp control panel, there is a port checker option (netstat). Please make sure all services are off first, then start one at a time each checking netstat to see what ports are being opened.

Check the apache httpd.conf located in c:\xampp\apache\conf.
ServerName localhost:80
Listen 80

Look under c:\xampp\apps\ for configuration files. In, C:\xampp\apps\drupal\conf\httpd-vhosts.conf, If you have Drupal, change the VirtualHost listening port to something like 8081 and 8443.

For mysql, check my.ini file for port, the default port is 3306. You can change this port if needed.
efremmc2
 
Posts: 8
Joined: 25. August 2017 03:54
XAMPP version: 1.7.7
Operating System: Windows/Linux

Re: xampp will not start mysql

Postby drybank » 27. August 2017 20:03

Thanks for the suggestion.
I fixed the problem by copying (user.frm, user.MYD and user.MYI) from a backup file and pasting them into C:\xampp\mysql\data\mysql
This reinstalled the users table containing "users and global privileges" and enabled me to login at localhost/phpMyadmin
drybank
 
Posts: 3
Joined: 21. August 2017 21:03
XAMPP version: 1.8.3
Operating System: windows

Re: xampp will not start mysql

Postby efremmc2 » 29. August 2017 01:55

Awesome. It is always good to take snapshot backups of configuration settings!
efremmc2
 
Posts: 8
Joined: 25. August 2017 03:54
XAMPP version: 1.7.7
Operating System: Windows/Linux


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 37 guests