Help... Access denied for user

------=_NextPart_000_0E0D_01C50D04.EBDFF340
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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\dr ivers\adodb-m=
ysql.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=20
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\dr ivers\adodb-m=
ysql.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=20
Warning: Cannot modify header information - headers already sent by =
(output started at C:\Program =
Files\egroupware-1.0.00.006\egroupware\phpgwapi\inc\adodb\dr ivers\adodb-m=
ysql.inc.php:354) in C:\Program =
Files\egroupware-1.0.00.006\egroupware\phpgwapi\inc\class.se tup_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


------=_NextPart_000_0E0D_01C50D04.EBDFF340--

Re: Help... Access denied for user

--=_alternative 0059A10E85256FA1_=
Content-Type: text/plain; charset="US-ASCII"

See response interspersed and below......

"Matthew Ferry" wrote on 02/07/2005
11:05:23 AM:

> 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.ph p 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))

This is Error #1

>
> 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.ph p 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)

This is Error #2

>
> 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.ph p:354)
> in C:\Program Files\egroupware-1.0.00.
> 006\egroupware\phpgwapi\inc\class.setup_html.inc.php on line 117
>

This is Error #3

>
> 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????
>
Yes, it is.


> 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 believe you should.

> I tried this..but...i don't know if it changed anything or not....

Did you remember to also perform a FLUSH PRIVILEGES command?


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

Error #1 is caused by your software attempting to connect to MySQL by
using a MySQL account that has a password on it but not sending the
password as part of the connection. This also tells me that your
application is attempting to login as the MySQL user "root". Do not let it
do that. Create a new user account for your application and let it log in
as that, NEVER as root. Save your root login for emergencies or
uber-administration only.

Error #2 is caused by the OLD_PASSWORD problem you have found so much
documentation about. Your PHP libraries are PRE-4.1 client libraries. I
can't say how to upgrade PHP to use the new authentication protocols but
if you create your new mysql user password (see above) with the
OLD_PASSWORD() function then do a FLUSH PRIVILEGES, everything should be
able to connect.

http://dev.mysql.com/doc/mysql/en/old-client.html

Error #3 is a PHP error. That one I can't help with (I don't use PHP
enough). However, it seems as though you are attempting to send two sets
of HTML headers to the client (perhaps because of your other errors on a
partially completed page?). I just don't know enough to say for sure.

>
> Matt
>

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 0059A10E85256FA1_=--

Re: Help... Access denied for user

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"
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\d rivers\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\d rivers\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\d rivers\adodb-mysql.inc.php:354)
>in C:\Program
>Files\egroupware-1.0.00.006\egroupware\phpgwapi\inc\class.s etup_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
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org