3 messages in com.mysql.lists.win32Re: Help... Access denied for user
FromSent OnAttachments
Matthew Ferry07 Feb 2005 08:05 
SGr...@unimin.com07 Feb 2005 08:15 
Pradeep Bojan07 Feb 2005 09:32 
Subject:Re: Help... Access denied for user
From:Pradeep Bojan (prad@atheros.com)
Date:02/07/2005 09:32:50 AM
List:com.mysql.lists.win32

Hi Math,

This is due to password encryption method used in MySQL 4.1.9. To get over this problem, try installing MySQL Administrator

http://dev.mysql.com/downloads/administrator/1.0.html

After installing, do the following

1) Logon to Administrator Utility 2) Select View > Startup Variables 3) Select "Security" tab from startup variable pane. 4) Check "use old passwords" option. 5) Apply changes 6) Restart MySQL service.

Hope this should solve the problem.

Regards, Pradeep Bojan

On Mon, 7 Feb 2005 11:05:23 -0500 "Matthew Ferry" <matt@mrf-corporation.com> wrote:

Hello Everyone....

I'm new to MySQL and I have a simple problem, but I can't get it figured out. I have search google for about a week now. I have found stuff about my problem, but I didn't understand how to use what I had found.

I am running Microsoft Windows 2003 Server (iis 6), PHP 4.3, MySQL 4.1.9 PHP and web server is working fine (As far as I can tell)

I want to install egroupware...

When I run the egroupware setup (web based...php) I get this:

Warning: mysql_pconnect(): Access denied for user 'root'@'localhost' (using password: NO) in C:\Program Files\egroupware-1.0.00.006\egroupware\phpgwapi\inc\adodb\drivers\adodb-mysql.inc.php on line 354

Database error: ADOdb::PConnect(localhost:3306, root, $Password, mysql) failed. mysql Error: 1045 (Access denied for user 'root'@'localhost' (using password: NO))

Function: db::query / db::create_database Warning: mysql_pconnect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\Program Files\egroupware-1.0.00.006\egroupware\phpgwapi\inc\adodb\drivers\adodb-mysql.inc.php on line 354

Database error: ADOdb::PConnect(localhost:3306, egroupware, $Password, egroupware) failed. mysql Error: 1251 (Client does not support authentication protocol requested by server; consider upgrading MySQL client)

Function: db::create_database Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\egroupware-1.0.00.006\egroupware\phpgwapi\inc\adodb\drivers\adodb-mysql.inc.php:354) in C:\Program Files\egroupware-1.0.00.006\egroupware\phpgwapi\inc\class.setup_html.inc.php on line 117

It says - consider upgrading MySQL client ...I'm not using a MySQL Client This is PHP talking to the MySQL Server... is PHP my client????

The research I did...says about the hashing of the password field... and you have to set the password back with the "OLD_PASSWORD" command... Do I have to do this???? I tried this..but...i don't know if it changed anything or not....

thanks so much...I got to get this up and running soon....

Matt