up vote 3 down vote favorite
share [g+] share [fb]

Hi I am using XAMPP on Windows XP. Since I changed the version from 1.73 to 1.77 MySQL does not start properly. That means that the status says, it is started, but the safety check says it is not . Because of that I cannot set any password, which is unacceptable.

Any idea?

That's mysql_error.log:

111007  9:42:56 [Note] Plugin 'FEDERATED' is disabled.
111007  9:42:56 InnoDB: The InnoDB memory heap is disabled
111007  9:42:56 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111007  9:42:56 InnoDB: Compressed tables use zlib 1.2.3
111007  9:42:56 InnoDB: Initializing buffer pool, size = 16.0M
111007  9:42:56 InnoDB: Completed initialization of buffer pool
111007  9:42:57 InnoDB: highest supported file format is Barracuda.
111007  9:42:57  InnoDB: Waiting for the background threads to start
111007  9:42:58 InnoDB: 1.1.8 started; log sequence number 1595675
111007  9:42:58 [Note] Event Scheduler: Loaded 0 events
111007  9:42:58 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.16'  socket: ''  port: 3306  MySQL Community Server (GPL)
link|improve this question
If the mysql log doesn't show any issues, does the Windows event log have any relevant messages? – sinping Oct 7 '11 at 1:16
Windows event log shows only three times ´event 100´. I compared this with a working version and there is no difference. – Erik Svenson Oct 9 '11 at 20:34
Are you sure it isn't actually starting? – WerkkreW Oct 25 '11 at 17:59
Have you checked on Check on Administrative Tools > Services? On Windows 7 if UAC is enabled there is a possibility that the install didn't register the service properly. You could also try to run the installer right-clicking on it and 'Run as Administrator'. – ruionwriting Nov 23 '11 at 2:28
In the last line, the value of the socket: is very interesting: no socket? In starting my version of MySQL on Ubuntu, it had a value there. – David Jan 10 at 17:09
feedback

migrated from stackoverflow.com Oct 7 '11 at 0:27

This question came from our site for professional and enthusiast programmers.

1 Answer

up vote 0 down vote

This Thread might help you, if you are still trying to resolve the issue.

http://www.apachefriends.org/f/viewtopic.php?p=186527

Try logging into the phpMyAdmin within XAMPP to get a better answer to why your MySQL isn't running / starting properly. Otherwise, [usually last hope], back up your DB and reinstall xampp. Once you have a fresh install with the latest version - import your DB back into MySQL.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.