Well this is derived from my other thread but it might as well be in its own thread because it's basically an entire different issue now...
Today I installed Apache, PHP, and MySQL. Everything works fine except the MySQL part. It's set to listen on port 3306 but when I fire it up, nothing, including its own admin tools can access it. I do "telnet localhost 3306" and it says "Could not open connection to the host on port 3306: Connect Failed."
I have Windows Firewall and Microsoft Anti-Spyware. Running Windows XP.
Apache 2, PHP 5, MySQL version 4.1.
Can anyone please help? Thanks.
Well now I've gotten further...
Apparently MySQLD was not starting up. It still won't.
When I type "mysqld --console" it returns this error in the cmd box:
C:\Program Files\MySQL\MySQL Server 4.1\bin>mysqld --console
InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
050319 16:57:46 [ERROR] Can't init databases
050319 16:57:46 [ERROR] Aborting
050319 16:57:46 [Note] mysqld: Shutdown complete
So I just deleted the log files. Then it returns this error in the cmd box:
C:\Program Files\MySQL\MySQL Server 4.1\bin>mysqld --console
050319 17:04:15 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
050319 17:04:15 [ERROR] Can't init databases
050319 17:04:15 [ERROR] Aborting
050319 17:04:15 [Note] mysqld: Shutdown complete
