My server went down last night because of a power failure and now I can't seem to connect to MySQL at all. When I try through DOS or phpMyAdmin I get this:
Host 'localhost' is not allowed to connect to this MySQL server
My error log shows this:
050405 19:05:23 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...
050405 19:05:23 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43677.
InnoDB: Doing recovery: scanned up to log sequence number 0 43677
InnoDB: Last MySQL binlog file position 0 79, file name .\serv2-bin.000001
050405 19:05:24 InnoDB: Flushing modified pages from the buffer pool...
050405 19:05:24 InnoDB: Started; log sequence number 0 43677
050405 19:05:25 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
050405 19:05:25 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
C:\MySql\bin\mysqld.exe: ready for connections.
Version: '4.1.9-max' socket: '' port: 3306 Source distribution
I didn't update my user table before to the new password scheme, but it wasn't a problem as this database had been up and running for over a month straight. Is it related to this? Help!
Thanks!
