You are here: Re: Connection Problem, Driving me insane « PHP SQL « IT news, forums, messages
Re: Connection Problem, Driving me insane

Posted by rincewind on 06/29/05 20:51

On Tue, 28 Jun 2005 14:25:17 -0700, Tony wrote:

> rincewind wrote:
>> On Mon, 27 Jun 2005 14:57:40 -0700, Tony wrote:
>>
>>> BJA wrote:
>>>>>
>>>> I get the following message
>>>>
>>>> Warning: mysql_connect(): Client does not support authentication
>>>> protocol requested by server; consider upgrading MySQL client in
>>>> C:\www\test4.php on line 12
>>>
>>> Have you tried Google yet?
>>
>> Done that! Tried that, doesn't work.
>
> So, you've tried
>
> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
>
> and
>
> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') WHERE Host =
> 'some_host' AND User = 'some_user';
> FLUSH PRIVILEGES;
>
> and you're still getting the error?

Thanks for the help, but I finally sorted it by uninstalling everything
(apache, MySQL and PHP) and installing a package called PHPHome from
http://phphome.sourceforge.net

Quote from the readme file "PHP Home Edition is a powerful and flexible
HTTP/1.1 compliant web server with integrated PHP scripting language
support and fast MYSQL database server in one package. This plug&play
software is bundled with special support libraries and powerfull phpMyAdmin
database GUI."

After installing this which had an older version of MySQL (which I have
since updated) an older version of Apache (which I haven't) and anewer
version of PHP (version 5) everything works fine.

I can only assume that I had not configured something quite right, but for
the life of me I can't see what it is.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация