2

I come here from this topic

Where user has exactly the same problem.

I have installed Winamp (Apache+Mysql). I moved my /data subfolders (backup) to mysql/data (installed folder). I originally had error that my port is in use, so I changed to 3307. The cause for this error could be freeze of mysqld-nt (not closed, stayed in memory)

  • port is 3307
  • data folder is in my.ini is set correctly
  • client run results in close because mysql-nt doesnt run
  • mysqld-nt Freezes console.
  • cannot run console
  • mysqld-nt is closed (manually)

I am Windows user. My Mysql is part of Wamp server and has no any mysql_install_db in bin folder. I don't use linux so I cannot use linux commands. Also I cannot run client bevazse server connection is not established so cannot type the command for client.

Please help.

Community
  • 1
  • 1
John Boe
  • 3,501
  • 10
  • 37
  • 71

1 Answers1

0

The fact that port 3306 is in use could be a clue that your old Mysql server process is still running and hogging the port. Because it's windows, you may have to reboot.

Your data backup might have been corrupted, or not copied over correctly.

dar7yl
  • 3,727
  • 25
  • 20
  • I restarted. No daemon in memory. Port is free. 120110 21:32:09 InnoDB: Started; log sequence number 0 43655 120110 21:32:09 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist – John Boe Jan 10 '12 at 20:33
  • WAMP installed to foler: c:\wampserver but log is in c:\wampserver\wamp\logs ... c:\wampserver\wamp\ is the old location of the previous server (same version BTW). Now I dont know how it is possible that (?) this mysql is running (?) ,,, I installed to c:\wampserver\ – John Boe Jan 10 '12 at 20:50
  • Also I found my.ini is saved in the same (incorrect) location like log file. – John Boe Jan 10 '12 at 21:39
  • 1
    SOLVED. I CANT POST HERE MY ANSWER. NO RIGHTS – John Boe Jan 10 '12 at 22:24