MySQL Will Not Start

[waltercat]

I was able to install xampp locally very easily. And everything ran fine.

I am also needed to install vbulletin locally.

So I installed it and I was able to access everything perfect. I could post messages, reply, search etc.

However, once I stop MYSQL in the control panel of xampp or shut my computer down, MySQL shuts down and I cannot restart it.

Please help, I've been pulling my hair out for 2 days over this.

[capitalfellow]

C:\path\your\install\xampp\mysql\data\

Open the .err file in that directory with a text editor.
Look at the last few lines in the log file and see what MySQL is complaining about it.
If you don't understand them post them here.

[waltercat]

The err file does not display anything. However when I try to go to phpadmin via localhost/phpmyadmin, I get this error:

#1130 - host 'localhost' is not allowed to connect to this MySQL server."

The control panel says MYSQL is running.

However if I stop it and try to restart it with the "mysql_start.bat" it says

MySQL is starting with mysql\bin\my.cnf (console)...

mysql\bin\mysqld: ready for connections....

port 3306 MySQL Community Edition (GPL)

Nothing else. I think it is still looking for something because when I try to close the window Windows says that the program is still running and that I have to close it early if I want to close the window. So I End Now.

I think it comes back to my my.ini, config.inc.php,

I looked for "mysql\bin\my.cnf" but could not find it.

What is changing the files! Why would it work fine when I install but once I stop mySQL everything craps out???

Are there file conflicts somewhere?

[waltercat]

Okay, I figured it out and it was a bonehead reason...

In the config.php file for vbulletin I was naming the vbname 'mysql' and the folder was conflicting and overriding MYSQL's 'mysql' folder.

I thought the vbname was supposed to reference a database on the server. Rather it is supposed to reference the vbulletin part of the database.

That's where I was confused.

Oh well, I feel silly, but am glad I solved the problem.