IPB

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> mySQL won't run, I can't get mySQL to run
Gonzell
post Oct 28 2006, 12:51 AM
Post #1


Newbie
Group Icon

Group: Member
Posts: 3
Joined: 28-October 06
Member No.: 1,221



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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Ric
post Oct 28 2006, 08:29 AM
Post #2


Project Developer
Group Icon

Group: Developer
Posts: 1,097
Joined: 30-April 06
From: Cambridge,UK
Member No.: 582
SourceForge ID: mpgcan
Wiki ID: Ric
Main OS: Windows XP



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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Gonzell
post Oct 28 2006, 09:10 AM
Post #3


Newbie
Group Icon

Group: Member
Posts: 3
Joined: 28-October 06
Member No.: 1,221



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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Gonzell
post Oct 28 2006, 09:49 AM
Post #4


Newbie
Group Icon

Group: Member
Posts: 3
Joined: 28-October 06
Member No.: 1,221



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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Ric
post Oct 28 2006, 04:26 PM
Post #5


Project Developer
Group Icon

Group: Developer
Posts: 1,097
Joined: 30-April 06
From: Cambridge,UK
Member No.: 582
SourceForge ID: mpgcan
Wiki ID: Ric
Main OS: Windows XP



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
User is offlineProfile CardPM
Go to the top of the page
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



Lo-Fi Version Time is now: 2nd September 2010 - 07:20 PM
SourceForge.net Logo