MYSQL problems - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MYSQL problems (/showthread.php?tid=289380)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MYSQL problems (/showthread.php?tid=289380)
MYSQL problems - Saurik - 11.10.2011
I'm having a few mysql issues. Basically my server can't connect to the database. My website connects to the DB well and retrieves stats well..
Код:
[11:31:20] >> mysql_connect( ) [11:31:20] CMySQLHandler::CMySQLHandler() - constructor called. [11:31:20] CMySQLHandler::CMySQLHandler() - Connecting to "HOST" | DB: "DB NAME" | Username: "USER" ... [11:31:20] CMySQLHandler::Connect() - Access denied for user 'USERNAME'@'HOST' (using password: YES) (Error ID: 1045) [11:31:20] [11:31:20] --------------------------- [11:31:20] MySQL Debugging activated (10/11/11) [11:31:20] --------------------------- [11:31:20] [11:31:20] >> mysql_connect( ) [11:31:20] CMySQLHandler::CMySQLHandler() - constructor called. [11:31:20] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "DATABASE NAME" | Username: "USERNAME" ... [11:31:20] CMySQLHandler::Connect() - Connection was successful. [11:31:20] CMySQLHandler::Connect() - Auto-Reconnect has been enabled. [11:32:29] >> mysql_query( Connection handle: 1 ) [11:32:29] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead) [11:32:29] >> mysql_store_result( Connection handle: 1 )
Re: MYSQL problems - Lenny the Cup - 11.10.2011
You have provided an invalid username or password to the MySQL server.
Re: MYSQL problems - Baboon - 11.10.2011
Watch closely whether you have set the right username and password.
Try another plugin, which one are you using? I recommend G_Stylezz..
Re : MYSQL problems - Saurik - 11.10.2011
Thanks for the reply.
I am using the correct login details. All I did yesterday is restart the sever and this happened. Didn't edit my gm. And I am using gstylezz Plugin
Also I exported everything to another volt host DB and it still does this
Re: MYSQL problems - XFlawless - 11.10.2011
Try changing password of your db.
Re: MYSQL problems - Saurik - 11.10.2011
Changed that a while ago. No luck
Re: MYSQL problems - XFlawless - 11.10.2011
Open a ticket on volt-host see if their mysql server is up or something...
Re: MYSQL problems - Lenny the Cup - 11.10.2011
I seriously doubt that your host address is "HOST", username is "USER" and DB name is "DB NAME". You have to configure the connection details in your script.
Re: MYSQL problems - Saurik - 11.10.2011
Quote:
|
Originally Posted by Lenny the Cup
 I seriously doubt that your host address is "HOST", username is "USER" and DB name is "DB NAME". You have to configure the connection details in your script.
|
I put in that to replace my real info so no one will see it. Why would I post my real user or host
I'm using correct info. I never changed anything and it worked fine for weeks.
Re: MYSQL problems - Baboon - 11.10.2011
show us your defines (no password ofcourse).