Raised This Month: $ Target: $400
 0% 

MySQL auth errors...


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
geekforce
Junior Member
Join Date: Oct 2005
Old 10-22-2005 , 14:06   MySQL auth errors...
Reply With Quote #1

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
__________________
C# allows you to shoot yourself in the foot rather easy, C++ allows you to reuse the bullet.
geekforce is offline
slurpycof
Senior Member
Join Date: Nov 2004
Old 10-22-2005 , 16:04  
Reply With Quote #2

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.
slurpycof is offline
geekforce
Junior Member
Join Date: Oct 2005
Old 10-23-2005 , 06:49  
Reply With Quote #3

ok thanks. it works...

-- GeekFOrce
__________________
C# allows you to shoot yourself in the foot rather easy, C++ allows you to reuse the bullet.
geekforce is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


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