MySQL wont start (Server 2003) 1.7.7 [SOLVED]

[Keelan]

OS: Windows 2003 Server Data Edition Service Pack 2
Xampp: 1.7.7
Control Panel: v3.0.2 (BETA)
Uninstalled & Reinstalled: Yes
Rebooted After Install/Uninstall: Yes
Disabled World Wide Web Publishing Service: Yes
Apache Starts: Yes

Error log:

Code: Select all

111112 19:36:37 [Note] Plugin 'FEDERATED' is disabled.
111112 19:36:37 InnoDB: The InnoDB memory heap is disabled
111112 19:36:37 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111112 19:36:37 InnoDB: Compressed tables use zlib 1.2.3
111112 19:36:37 InnoDB: Initializing buffer pool, size = 16.0M
111112 19:36:37 InnoDB: Completed initialization of buffer pool
111112 19:36:37 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
111112 19:36:37  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
111112 19:36:38  InnoDB: Waiting for the background threads to start
111112 19:36:39 InnoDB: 1.1.8 started; log sequence number 1630865
111112 19:36:39 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)


Netstat:

Code: Select all

Active Connections

  Proto  Local Address          Foreign Address        State
  TCP    0.0.0.0:21             0.0.0.0:0              LISTENING
  TCP    0.0.0.0:25             0.0.0.0:0              LISTENING
  TCP    0.0.0.0:79             0.0.0.0:0              LISTENING
  TCP    0.0.0.0:80             0.0.0.0:0              LISTENING
  TCP    0.0.0.0:105            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:106            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:110            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:135            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:143            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:443            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:445            0.0.0.0:0              LISTENING
  TCP    0.0.0.0:1025           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:2224           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:3389           0.0.0.0:0              LISTENING
  TCP    0.0.0.0:8078           0.0.0.0:0              LISTENING
  TCP    127.0.0.1:1026         0.0.0.0:0              LISTENING
  TCP    127.0.0.1:14147        0.0.0.0:0              LISTENING
  TCP    216.24.199.47:139      0.0.0.0:0              LISTENING
  TCP    216.24.199.47:1096     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1097     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1106     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1107     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1108     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1109     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1110     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1111     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1112     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1113     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1114     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1115     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1152     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1153     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1210     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1211     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1233     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1234     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1309     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1310     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1347     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1348     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1373     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1374     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1375     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1376     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1379     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1380     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1381     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1382     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:1383     69.164.211.252:80      CLOSE_WAIT
  TCP    216.24.199.47:1384     50.116.67.156:80       CLOSE_WAIT
  TCP    216.24.199.47:3389     173.32.139.199:55702   ESTABLISHED
  UDP    0.0.0.0:445            *:*
  UDP    0.0.0.0:500            *:*
  UDP    0.0.0.0:4500           *:*
  UDP    127.0.0.1:123          *:*
  UDP    216.24.199.47:123      *:*
  UDP    216.24.199.47:137      *:*
  UDP    216.24.199.47:138      *:*

Issue:

Code: Select all

7:42:53 PM  [mysql]    Status change detected: running
7:42:56 PM  [mysql]    Status change detected: stopped


It was working fine i didn't do anything in particular, i had apache running after help from this viewtopic.php?f=16&t=48935 then i logged into phpMyadmin and created a database etc and then. I started having issues with it starting. Any more help would be greatly appreciated

[Sharley]

Try this:
Using a text editor, open \xampp\phpMyAdmin\config.inc.php and change this line to 'cookie' or 'http' your choice

Code: Select all

$cfg['Servers'][$i]['auth_type'] = 'config';

Next open \xampp\mysql\bin\my.ini and remove the # (comment character) from the start of this line

Code: Select all

#bind-address="127.0.0.1"

Save both files and now try and Start MySQL.

A reboot may also help.

You may also have corrupted a table when creating your database.

If so then in the \mysql\data folder you will find a folder that is named as the database you just created.

Drag that folder out of the data folder and then try and start MySQL.

If it starts then you know that the database you created is at fault.


Here's another trick if it is in relation to the default databases:

Download the zip version and extract the default databases from the zip file into the mysql\data folder.

Restart MySQL if possible.

Good luck.

[Keelan]

No joy:

Code: Select all

$cfg['Servers'][$i]['auth_type'] = 'config';

Was already set to cookie.

Rebooted it turns green for a couple of seconds then stops again.

[Sharley]

You should set that back to 'cookie' if you changed it.

You get the same error message?

Code: Select all

Fatal error: Can't open and lock privilege tables: Can't find file: 'host' (errno: 2)

Did you try all the methods in my post including the zip archive trick?

[Keelan]

Awesome that worked perfectly (downloading and overwriting the DB).

[Sharley]

That error usually means that a host file in the mysql\data\mysql folder is missing or corrupt.

That's good news and now you're on your way again.

Thanks once again for the feedback.

Best wishes.

[Sharley]

Readers and members may be wondering how the host.MYD file in the data folder of MySQL could be missing.

Well a possible reason and solution can be found in this well researched topic.
viewtopic.php?f=16&t=48955

Worth a read if you use the very popular archive extraction utility IZArc.