| View previous topic :: View next topic |
| Author |
Message |
player1
-
Joined: 29 Nov 2004
Posts: 6
Location: London
|
 Posted: Tue Nov 30, 2004 7:50 pm Post subject: 1251 - help plz forum |
 |
|
MySQL said:
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
I followed the tutorial but used phpMyAdmin 2.6.0-pl3 and everything was fine until I went to secure Mysql 4.1 via phpMyAdmin.
I set permissions: password: for Mysql and was booted out of phpMyAdmin as expected, I then changed the config to include the password.
MySQL said:
#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
And it keeps saying the same thing.
I set the authentication to http to see if it liked it, it did'nt and I kept getting error 401
phpMyAdmin documentation said mysqli was the reccomended extention so, I changed config to reflect this and it still gets the hump:
cannot load mysqli extension,
please check PHP Configuration
Documentation
and I tried again by changing the host to 127.0.0.1
no joy
what have I missed?
If I am being dumb and/or there is a post out there I've missed please let me know.
Thanks - total novice who is amazed at how far I've got.
_________________
need free content feeds plz - not that i'm not looking... |
|
| Back to top |
   |
 |
TRUSTAbyss
-
Joined: 29 Oct 2003
Posts: 3752
Location: USA, GA
|
| Posted: Tue Nov 30, 2004 7:56 pm Post subject: |
|
|
I don't have time to dig up an old post so im going to tell you now , PHP v5 has issues , it won't work on some
scripts and you need to load the proper extension to use MySQL for PHP v5 , switch back to PHP v4 , LateR! |
|
| Back to top |
 |
|
player1
-
Joined: 29 Nov 2004
Posts: 6
Location: London
|
| Posted: Tue Nov 30, 2004 8:03 pm Post subject: I am running php4 |
|
|
Thanks for the swift responce but I am running php4
_________________
need free content feeds plz - not that i'm not looking... |
|
| Back to top |
|
|
olly86
-
Joined: 25 Apr 2003
Posts: 993
Location: Wiltshire, UK
|
| Posted: Wed Dec 01, 2004 5:13 pm Post subject: |
|
|
if your using MySQL 4.1 or newer PHP 4 will NOT be able to connect to it. You need to use the new MySQLi extensions in PHP 5.
on another note, i've been using php 5.0.2 and have found no errors with it. I'll agree that php 5 and 5.0.1 where unstable, but php 5.0.2 is fine.
_________________
Olly |
|
| Back to top |
|
|
player1
-
Joined: 29 Nov 2004
Posts: 6
Location: London
|
| Posted: Wed Dec 01, 2004 9:15 pm Post subject: weird... |
|
|
because I'm running PHP4.3, MySql 4.1 and oscommerce and they get on fine so far... next bit is to get phpMyAdmin back. I changed the config, in phpadmin to include the pswrd but my old mate 1251 keeps lurking around like a wet fart...
_________________
need free content feeds plz - not that i'm not looking... |
|
| Back to top |
|
|
|
