[dpilon]

ok, thanks for all your help. I've decided to reformat and install Vista. Vista has a more advanced networking setup than xp. I was never fond of xp anyways.

Thanks again. 🙂

Don

[dpilon]

-The game scripts don't connect now

-I can't connect using other clients

-Not sure about “do you know if MySQL as shipped with Mango runs as a service?”

-I can't start or stop the service in the command line.

EDIT: here are some pictures of the errors and mangos

[dpilon]

Yeh, it really does seem strange to me that it was able to connect fine, then all of a sudden it has this connection issue. My ports are all forwarded for 3306, so i can't see why that is a problem. One more thing, not sure if this is relevant to my connection issue, but it started happening after my power turned off and on due to a thunderstorm. My internet was working fine after, my system was completely fine. No corrupt files, I thought maybe sqlyog was messed up due to the power problem, but I get the same error (2003 cant connect to localhost) when i try to use navicat, or any other sql programs.

I am thinking about upgradeing to Vista. Vista has much better network settings so I am thinking this will solve my problem. Could my problem just be because I am using XP SP2?

To answer you question, before the connection issu, Mangos was able to access the database and run perfectly. Now it just cannot connect to my sql database.

[dpilon]

I cleared the error and tried to start SQLyog again, checked the .err file and it was blank.. so that must have been from before. Basically all my SQLyog program does is:

When i click on the shortcut on my desktop, brings up the GUI, i click connect.. and then I get this error ..

'Error no. 2003

Can't connect to MySQL server on localhost '

I don't know how else to explain my problem, I should be able to open and access/edit my sql database which i created and made in SQLyog before it started giving me this error. Im not tryin to connect to a server, im tryin to connect localy. Everything is being done on one computer.

Sorry if this isn't helping.

Don

[dpilon]

Im running Mango's server emulator. Using SQLyog community edition 5.30, on microsoft windows xp home edition, using only windows firewall (which i tried turning off, as well as forwarding port 3306). I opened up the .err file in my sqlyog folder and this is what it said:

Code:

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2007-05-12 15:05:14
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2007-05-12 15:05:18
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2007-05-12 15:07:29
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2007-05-12 15:07:30
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2007-05-12 15:07:36
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2007-05-12 13:10:17
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2007-05-12 13:10:23
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Hope that helps.

[Author]

Posts