Apache Friends Support Forum

-------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.

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

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.

??????

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.

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?