SA-MP Forums Archive
MySQL problem. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL problem. (/showthread.php?tid=73075)


MySQL problem. - kacperoo - 12.04.2009

Hi, I have problem with SA-MP mySQL

Here comes the log:
[18:36:56]
Connection to MySQL database: Failed !
[18:36:56] Client does not support authentication protocol requested by server; consider upgrading MySQL client
[18:36:56] Error in mysql_select_db: MySQL server has gone away
[18:36:56] MYSQL: Connection error, retrying...
[18:36:58]
Connection to MySQL database: Failed !
[18:36:58] Client does not support authentication protocol requested by server; consider upgrading MySQL client
[18:36:58] Error in mysql_select_db: MySQL server has gone away
[18:36:58] MYSQL: Could not reconnect to server, terminating server...



Re: MySQL problem. - tom_jonez - 12.04.2009

this should help you
http://dev.mysql.com/doc/refman/5.1/en/old-client.html

Re: MySQL problem. - HB - 12.04.2009

Seen on this line:
Quote:
Originally Posted by kacperoo
[18:36:56] Error in mysql_select_db: MySQL server has gone away
the database does not exist?

Re: MySQL problem. - tom_jonez - 12.04.2009

Quote:
Originally Posted by иєσz
Seen on this line:
Quote:
Originally Posted by kacperoo
[18:36:56] Error in mysql_select_db: MySQL server has gone away
the database does not exist?
No, it is saying this because the connection to the server failed. So this is the server's logic:

I'm attempting to connect to the server.
Hm, I can't connect because of this: Client does not support authentication protocol requested by server; consider upgrading MySQL client.
Ok, so I have no connection.
Now I am going to connect to the database specified.
I can't connect to the database because I don't have a MySQL connection opened.

So the problem is you need to upgrade your server password algorithm.

Re: MySQL problem. - HB - 12.04.2009

Quote:
Originally Posted by R4nk3d
Quote:
Originally Posted by иєσz
Seen on this line:
Quote:
Originally Posted by kacperoo
[18:36:56] Error in mysql_select_db: MySQL server has gone away
the database does not exist?
No, it is saying this because the connection to the server failed. So this is the server's logic:

I'm attempting to connect to the server.
Hm, I can't connect because of this: Client does not support authentication protocol requested by server; consider upgrading MySQL client.
Ok, so I have no connection.
Now I am going to connect to the database specified.
I can't connect to the database because I don't have a MySQL connection opened.

So the problem is you need to upgrade your server password algorithm.
Ooh like that. My bad, misunderstood :P

Re: MySQL problem. - tom_jonez - 12.04.2009

Quote:
Originally Posted by иєσz
Quote:
Originally Posted by R4nk3d
Quote:
Originally Posted by иєσz
Seen on this line:
Quote:
Originally Posted by kacperoo
[18:36:56] Error in mysql_select_db: MySQL server has gone away
the database does not exist?
No, it is saying this because the connection to the server failed. So this is the server's logic:

I'm attempting to connect to the server.
Hm, I can't connect because of this: Client does not support authentication protocol requested by server; consider upgrading MySQL client.
Ok, so I have no connection.
Now I am going to connect to the database specified.
I can't connect to the database because I don't have a MySQL connection opened.

So the problem is you need to upgrade your server password algorithm.
Ooh like that. My bad, misunderstood :P
No problem, hope i helped.