[kacperoo]

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...

[tom_jonez]

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

[HB]

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?

[tom_jonez]

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.

[HB]

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

[tom_jonez]

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.