[cobalt-users] MYSQL Access Problems

["David Hayden" <dhayden@xxxxxxxxxxxxxxx>]

I am having a problem with my ASP/MYSQL on my RaQ4

I have previously set up a DSN and successfully changed the root password as
described at
http://pkg.nl.cobalt.com/howto/casp_mysql_howto.html

This all worked very well and I was able to connect to the database using
the root user ID and new password.

I then had to connect to this database from one of the virtual servers set
up on the box. Again this worked OK.

Last week I had to reinstall the cgi stuff on my virtual server and since
then I have not been able to get the thing to work again. I  keep getting
the message

"Access denied for user: 'root@xxxxxxxxxxxxxxx' (Using password: YES)
(1045)"

I thought I would try resetting the root password but when I telnet in and
within SU I type
"mysqladmin -uroot -pcobalt-mysql password NEW-PASSWORD"

I get the error message
"error: 'Access denied for user: 'root@localhost' (Using password: YES)' "

I have tried stopping/restarting the server.
I have tried deleting and recreating the DSN
But keep getting the same problem.

Does anyone have any idea as to what I am doing wrong.

Any help will be gratefully appreciated.

David Hayden