xampp will not start mysql

[drybank]

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

[Altrea]

mysql_error.log contents?

[drybank]

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?

mysql_error.log contents?

mysql_error.log contents?

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

[efremmc2]

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.

[drybank]

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

[efremmc2]

Awesome. It is always good to take snapshot backups of configuration settings!