Please see the following link from Super User. I cannot get anything working:
Update: This link has been dramatically changed! Please see the link.
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.
On Debian or Ubuntu you can also do this on the command line to login as the administrator:
Then you reset the password as randy has indicated.
Your innodb_log_file_size is set incorrectly, so InnoDB isn't starting up. You haven't even gotten to the part where the password reset would matter.
It's very simple if you can restart your MySQL daemon.
Simply add 'skip-grant-tables' to your mysql configuration file (*nix: /etc/my.cnf). http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_skip-grant-tables
Then, get into mysql:
Next, reset your password:
Finally, remove the 'skip-grant-tables' from your configuration and restart mysqld.
For an extended level of verbosity, see Rolando's answer: Stuck outside MySQL! XAMPP - help please
I have posted an answer at the link you have provided, with the following info:
In your case, before you can even reset the password, you need to fix the start up issue.
Note the first error listed in MySQL error log:
This means that you may have copied your database files from another location or you have edited my.cnf settings and they no longer match the real ib_logfile0 file size. Focus on this issue first.