AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   MySQL auth errors... (https://forums.alliedmods.net/showthread.php?t=19660)

geekforce 10-22-2005 14:06

MySQL auth errors...
 
Cant find any info on this... I think i know what is causing the error, but other db plugins work :S

So.. i've got mysql 4.1.x.. and when i try to:
Code:

new Sql:g_sql;

public sql_connect()
{
        new Error[256];
       
        g_sql = dbi_connect(SQL_HOST, SQL_USER, SQL_PASS, SQL_NAME, Error, 255);
       
        if (g_sql <= SQL_FAILED)
        {
                server_print("[NW] %L", LANG_SERVER, "SQL_CANT_CON", Error);
        }
        ...
}

i get some error saying i should update my client (amx mysql thingy i guess)... wondering how to enable support for 4.1.x.. thx

Code:

L 10/22/2005 - 19:16:19: [MYSQL] DB Connection failed(1251): Client does not support authentication protocol requested by server; consider upgrading MySQL client
[NW] SQL error: can't connect: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client'
L 10/22/2005 - 19:16:19: [AMXX] Run time error 10 (native) (plugin "naturalworld.amxx") - debug not enabled.
L 10/22/2005 - 19:16:19: [MYSQL] Invalid database handle -11
L 10/22/2005 - 19:16:19: [AMXX] To enable debug mode, add " debug" after the plugin name in plugins.ini (without quotes).
L 10/22/2005 - 19:16:19: [AMXX] Run time error 10 (native) (plugin "naturalworld.amxx") - debug not enabled.
L 10/22/2005 - 19:16:19: [MYSQL] Invalid result handle -6
L 10/22/2005 - 19:16:19: [AMXX] To enable debug mode, add " debug" after the plugin name in plugins.ini (without

-- GeekFOrce

slurpycof 10-22-2005 16:04

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

To solve this problem, you should use one of the following approaches:

*

Upgrade all client programs to use a 4.1.1 or newer client library.
*

When connecting to the server with a pre-4.1 client program, use an account that still has a pre-4.1-style password.
*

Reset the password to pre-4.1 style for each user that needs to use a pre-4.1 client program. This can be done using the SET PASSWORD statement and the OLD_PASSWORD() function:

mysql> SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

Alternatively, use UPDATE and FLUSH PRIVILEGES:

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
-> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;

Substitute the password you want to use for “newpwd” in the preceding examples. MySQL cannot tell you what the original password was, so you'll need to pick a new one.

geekforce 10-23-2005 06:49

ok thanks. it works...

-- GeekFOrce


All times are GMT -4. The time now is 23:37.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.