| View previous topic :: View next topic |
| Author |
Message |
neceolite
Joined: 04 Aug 2007
Posts: 2
|
| Posted: Sat Aug 04, 2007 2:33 pm Post subject: MYSQL - cant connect |
|
|
| Hi need ur advise ... i just installed apache2triad and found out it is quiet useful rather than need to install one by one application ... fyi .. i just setup my apache and virtualhost blablabla .... but then i have a problem which i cant start mySQL server ... when i click on start the service it seem wont work .... please advise what shud i do next |
|
| Back to top |
|
cigraphics
Joined: 21 Aug 2005
Posts: 147
Location: Romania, Pitesti
|
| Posted: Sun Aug 05, 2007 7:54 am Post subject: |
|
|
| look into the logs to see what error it gives |
|
| Back to top |
|
neceolite
Joined: 04 Aug 2007
Posts: 2
|
| Posted: Sun Aug 05, 2007 8:23 am Post subject: |
|
|
the mysql icon / indicator shows red ... and does not turn green as it supposed to be ... when i go to command prompt and typed mysql ... it shows ... error 2003 : cant connect to mysql server on 'localhost' <10061>
please advise |
|
| Back to top |
|
weir-07
Joined: 16 Sep 2007
Posts: 3
|
| Posted: Sun Sep 16, 2007 3:59 pm Post subject: |
|
|
I have this same problem - please help.
It happened after i configured the server for access via a hostname. Even after i reverted everyhing back to 'localhost' - the problem persisted. |
|
| Back to top |
|
cigraphics
Joined: 21 Aug 2005
Posts: 147
Location: Romania, Pitesti
|
| Posted: Sun Sep 16, 2007 4:05 pm Post subject: |
|
|
| can u tell me what you modified ? |
|
| Back to top |
|
weir-07
Joined: 16 Sep 2007
Posts: 3
|
| Posted: Sun Sep 16, 2007 4:19 pm Post subject: |
|
|
| i used the change domain name tool in the CP, and changed my email address. |
|
| Back to top |
|
cigraphics
Joined: 21 Aug 2005
Posts: 147
Location: Romania, Pitesti
|
| Posted: Sun Sep 16, 2007 4:48 pm Post subject: |
|
|
the tool does not change anything in mysql maybe the port that mysql uses is already used by another program or you made some changes to my.ini
Go to %WINDIR% and edit my.ini
You must have this settings
Code:
...
bind-address = 127.0.0.1
port = 3306
...
|
|
| Back to top |
|
| |
