Help - Search - Members - Calendar
Full Version: mySQL won't run
The Uniform Server BBoard > Support > Uniform Server - Windows > MySQL
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:

QUOTE
Starting MySQL

MySQL server started.


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

QUOTE
#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:

QUOTE
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.


smile.gif
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
QUOTE(Gonzell @ Oct 28 2006, 09:49 AM) *

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.

wink.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2010 Invision Power Services, Inc.