Page 1 of 1

#1251 - Client does not support authentication protocol...

Posted: Tue May 24, 2005 8:46 pm
by robster
Hello :)

I am trying to run phpMyAdmin 2.6.2-pl1 (or older versions) on Apache 1.3x, PHP 4.x and MySQL 4.1 (in Windows XP Pro)

I fill in my config file for phpMyAdmin 2.6.2-pl1 and the error it returns when trying to run it is:

Code: Select all

Error

MySQL said: Documentation
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
I've looked around for help on this and all I could find was this thread on this forum:
http://codingforums.com/showpost.php?p= ... ostcount=2 (see last line of his post)


Does anyone have any knowlege on this? I've just come back to windozeland after running OSX for a few years and I'm starting to shake my head and wonder why ;) I'm sure it's an easy enough fix though, if only I could get some advice, or better yet, an answer to what's wrong.

Thanks so much, I really need to get working and this is really slowing me up!

:roll:

Posted: Tue May 24, 2005 8:49 pm
by Burrito
try running this command in your mysql command line:

Code: Select all

set password for username@localhost = old_password('password');

Posted: Tue May 24, 2005 9:04 pm
by AISBERG
or you can try set $cfg['Servers'][$i]['auth_type'] to config in config.inc.php from phpmyadmin folder. and leave the root username without a password, not recomended.. but, it works on localhost, as far as only you can access to the PC :)

Posted: Tue May 24, 2005 9:08 pm
by robster
Burrito: I know this sounds bad but... (ahem) ;) How do I run the Command line for MySQL?

AISBERG: When I try that I get this error:

Code: Select all

Error

MySQL said: Documentation
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

Posted: Tue May 24, 2005 9:16 pm
by AISBERG
when i first install mysql and phpmyadmin, i had the same problem. reinstalled mysql and choose not to change the user settings. so, my localhost is without a pass (don't try to get to it :wink: ), and this resolves my problem.

Posted: Tue May 24, 2005 9:17 pm
by robster
OK, It seems I RTFM for MySQL and found the shell for it. Basically, for anyone in the future, simply go to your MySQL Bin folder with your command prompt and type:
mysql -h localhost -u root -p mysql

(root is the username you wish to change, mysql is the database I presume?)

Then enter your password, then enter the command that the kind Burrito left which is:
set password for username@localhost = old_password('password');

Change username to root and password to what you want, and you're away :)

Thanks so much everyone.

Posted: Tue May 24, 2005 9:19 pm
by Burrito
go to a command prompt, browse to your mysql/bin folder:

since it's 4.1 by default it should be c:\program files\mysql\mysql 4.1\bin *I think*

then type "mysql -u root -p"
it will prompt for a password
enter your root password
you'll see a prompt like this:
mysql>
type this in:
"mysql>set password for username@localhost = old_password('password');"

where username is the user for which you want to set the password, localhost is the host (I assumed localhost), and password is the password for that user.

edit: doh! you beat me too it...hate it when I'm typing and can't type fast enough :D
gj though

Posted: Tue May 24, 2005 9:28 pm
by robster
LOL 8)

At least it works, and it's here for others in the future (written twice even!:))