mySQL won't run

[Gonzell]

Hokay, I've looked through the other post on people having this problem and I was not able to find a solution.

 

When I click "Run MySQL" in the apanel, it says:

 

Starting MySQL

 

MySQL server started.

 

However, when I click phpMyAdmin, I get this error:

 

#2003 - The server is not responding

 

There are no LIBMYSQL.DLL files on my PC either (I seen that in some of the old posts)

 

And when I try to run mysqlrun.bat from the Command Prompt, I get this error:

 

W:\usr\local\mysql>mysqlrun.bat

Could not open required defaults file: my-small.cnf

Fatal error in defaults handling. Program aborted

 

Can someone please help me?

 

Thank you,

Gonzell

[Ric]

When using Server_Start.bat and starting MySql from apanel (Run MySql) you may receive this message:

 

MySQL said: #2003 - The server is not responding

 

This is because the MySql server is not running

 

Cause the dreaded http_refer problem check this page out:

 

http://center.uniformserver.com/uniserver/...er_problem.html

 

Note: If you use Disk Start.vbs it will force MySql server to start.

 

 

[Gonzell]

I know MySQL is not running, thats the problem. I can't get it to run, no matter what I try.

 

I tried using that Disk Start.vbs, but with no luck. MySQL is still not running and phpMyAdmin still gives me the same error.

 

Why won't MySQL start? How can I get it to start?

 

Gonzell

[Gonzell]

Great news, I got it working! It seems all I had to do was forward the port on my router. I don't know exactly why I have to do that seeing as this web server thing is all local...

 

Oh well, I don't really care as long as it worked.

 

For anyone else having the same problem, just forward port 3306 to your machine.

 

Gonzell

[Ric]

Great news, I got it working! It seems all I had to do was forward the port on my router. I don't know exactly why I have to do that seeing as this web server thing is all local...

 

Oh well, I don't really care as long as it worked.

 

For anyone else having the same problem, just forward port 3306 to your machine.

 

Gonzell

 

I am glad you resolved your problem; I have no problem with that. The real problem I have is what is the underlying mechanism causing it. To port forward port 3306 means you want to run MySQL as a separate instance (a MySQL server in its own right as a separate server).

 

When you say, “this web server thing is all local” true for a local test server but when you put it on line Apache is on line! MySQL remains local however you have chosen to forward 3306 I am thinking secure it.