Error: MySQL Shutdown Unexpectedly

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

Error: MySQL Shutdown Unexpectedly

Postby jnoble0007 » 27. March 2013 17:38

-------I am using the following:
xampp v1.8.1
xampp Control Panel v3.1.0 Beta 4
Windows 7

------I have Xampp installed on a flashdrive.

------The "Control Panel" will come up but when i try to "Start" MySQL i get the following error message:
12:26:15 PM [mysql] Error: MySQL shutdown unexpectedly.
12:26:15 PM [mysql] This may be due to a blocked port, missing dependencies,
12:26:15 PM [mysql] improper privileges, a crash, or a shutdown by another method.
12:26:15 PM [mysql] Check the "/xampp/mysql/data/mysql_error.log" file
12:26:15 PM [mysql] and the Windows Event Viewer for more clues

-----Also, if i try to run MySQL through a command prompt i get this error message:

E:\xampp\mysql\bin>mysql -u root
ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

If anyone can help that would be great. Ask me for any other info you may need in order to help me with this. I've looked for the answer myself and couldn't find it.
jnoble0007
 
Posts: 3
Joined: 27. March 2013 17:12
XAMPP Version: 5.6.3
Operating System: windows 7

Re: Error: MySQL Shutdown Unexpectedly

Postby JonB » 27. March 2013 20:03

This may be due to a blocked port


Did you have a previous XAMPP install or a MySQL install? That is the most likely cause. Look in the Windows Service manager to see if a MySQL server is still running.

The 10061 is a Windows OS error telling you that the port is likely blocked or busy.

http://msdn.microsoft.com/en-us/library ... 68(v=vs.85).aspx

Good Luck
:)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7

Re: Error: MySQL Shutdown Unexpectedly

Postby jnoble0007 » 04. April 2013 20:00

I did have both MySQL and XAMPP previously installed
-- I unistalled both of them and reinstalled

I am getting the same error message in XAMPP Control Panel

[b]mysql_error.log :

130404 14:41:00 [Note] Plugin 'FEDERATED' is disabled.
e:\xampp\mysql\bin\mysqld.exe: Table 'mysql.plugin' doesn't exist
130404 14:41:00 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130404 14:41:00 InnoDB: The InnoDB memory heap is disabled
130404 14:41:00 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130404 14:41:00 InnoDB: Compressed tables use zlib 1.2.3
130404 14:41:01 InnoDB: Initializing buffer pool, size = 16.0M
130404 14:41:01 InnoDB: Completed initialization of buffer pool
130404 14:41:01 InnoDB: highest supported file format is Barracuda.
130404 14:41:03 InnoDB: Waiting for the background threads to start
130404 14:41:04 InnoDB: 1.1.8 started; log sequence number 1595685
130404 14:41:04 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130404 14:41:04 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130404 14:41:04 [Note] Server socket created on IP: '0.0.0.0'.
130404 14:41:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

I have ran "mysql_upgrade" but It still throws back this same error message.

??????
jnoble0007
 
Posts: 3
Joined: 27. March 2013 17:12
XAMPP Version: 5.6.3
Operating System: windows 7

Re: Error: MySQL Shutdown Unexpectedly

Postby jnoble0007 » 04. April 2013 20:02

Also, I get this error message from a Command Prompt..

-- ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

I think the old MySQL is taking up that port i need.
jnoble0007
 
Posts: 3
Joined: 27. March 2013 17:12
XAMPP Version: 5.6.3
Operating System: windows 7

Re: Error: MySQL Shutdown Unexpectedly

Postby hackattack142 » 04. April 2013 23:55

130404 14:41:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

You appear to be missing required files.

1. How did you install XAMPP (Installer/zip/7z)?
2. Did you uninstall all related services before uninstalling XAMPP and the standalone components?
3. Could you provide the entire output of the XAMPP control panel log window?
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 702
Joined: 20. May 2011 23:29
XAMPP Version: 5.6.3
Operating System: Windows 7 Ultimate SP1 64-Bit


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 41 guests