| View previous topic :: View next topic |
| Author |
Message |
PhatGunner
-
Joined: 25 Oct 2003
Posts: 16
|
 Posted: Fri Dec 19, 2003 3:15 am Post subject: cant connect to mysql server |
 |
|
im having trouble..
im using a 2wire homeportal and i accidentally put my computer out of DMZ mode...i quickly put it back in DMZ mode but now things are starting to mess up...
like phpmyadmin or my invision board cant connect to my sql server on localhost...
and i don't know what else is messed up that i havent found out about yet..
what can i do??
_________________
Everything that has a beginning has an end |
|
| Back to top |
  |
 |
PhatGunner
-
Joined: 25 Oct 2003
Posts: 16
|
| Posted: Fri Dec 19, 2003 3:56 am Post subject: |
|
|
this is the error i get:
| Quote: | mySQL query error: SELECT moderator.mid as is_mod, moderator.allow_warn, m.id, m.name, m.mgroup, m.password, m.email, m.restrict_post, m.view_sigs, m.view_avs, m.view_pop, m.view_img, m.auto_track,m.last_activity, m.dst_in_use, m.view_prefs, m.org_perm_id, m.temp_ban, g.*
FROM ibf_members
m.mod_posts, m.language, m.skin, m.new_msg, m.show_popup, m.msg_total, m.time_offset, m.posts, m.joined, m.last_post,
m.last_visit, m
LEFT JOIN ibf_groups g ON (g.g_id=m.mgroup)
LEFT JOIN ibf_moderators moderator ON (moderator.member_id=m.id OR moderator.group_id=m.mgroup )
WHERE m.id=1
mySQL error: Can't connect to MySQL server on 'localhost' (10061)
mySQL error code:
Date: Thursday 18th of December 2003 09:55:06 PM |
_________________
Everything that has a beginning has an end |
|
| Back to top |
|
|
Anonymoose
-
Joined: 09 Sep 2003
Posts: 2192
|
| Posted: Fri Dec 19, 2003 9:53 am Post subject: |
|
|
| In Windows, error 10061 is Connection Refused - in other words there's either nothing listening on the port you're trying to connect to or it is refusing to let you connect... It sounds like you've either shutdown your MySQL server by accident, your MySQL server isn't started or you modified your configuration so it isn't pointing to the server anymore. |
|
| Back to top |
|
|
PhatGunner
-
Joined: 25 Oct 2003
Posts: 16
|
| Posted: Fri Dec 19, 2003 11:59 pm Post subject: |
|
|
i tried reinstalling everything (abyss, php, mysql, phpmyadmin) and nothign will still connect to the mysql server...i think it has something to do with my router blocking the ports.
what ports does mysql run on?
*everytime i try starting the mysql service manager it also is not able to connect
_________________
Everything that has a beginning has an end |
|
| Back to top |
|
|
PhatGunner
-
Joined: 25 Oct 2003
Posts: 16
|
| Posted: Sat Dec 20, 2003 8:33 am Post subject: |
|
|
bumped - really need help...
btw, would not having a my.ini or my.cnf may be what's causing the trouble?
_________________
Everything that has a beginning has an end |
|
| Back to top |
|
|
PhatGunner
-
Joined: 25 Oct 2003
Posts: 16
|
| Posted: Sat Dec 20, 2003 6:01 pm Post subject: |
|
|
bumped - till i get help
_________________
Everything that has a beginning has an end |
|
| Back to top |
|
|
aprelium
-
Joined: 22 Mar 2002
Posts: 6800
|
| Posted: Sun Dec 21, 2003 5:20 pm Post subject: |
|
|
PhatGunner,
MySQL uses by default port 3306. If your web server and your MySQL server are both running on the same machine, use localhost or 127.0.0.1 as the machine name.
_________________
Support Team
Aprelium - http://www.aprelium.com |
|
| Back to top |
 |
|
|
