On Mon, Jul 23, 2001 at 09:36:00PM -0700, Timothy Bolz wrote:
> I'm trying to set up phpnuke but mysql seems to be the problem. I set up a
> database a while back and now I can't even use it. I read the mysql page
> about password I did everything it said still it's giving me the same thing.
> I even tried apt-get remove mysql-client mysq-server then apt-get install
> mysql-client mysql-server and I still get the same thing.
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
> I think the configuration files must have been left behind.
> Any suggestion would help.
>
I think there's a typo in install-db. IIRC it says:
Set the root password with:
# mysqladmin -u root -p password '<password>'
it should say
# mysqladmin -u root password '<password>'
Note that this will only work the first time, ie, there is no password
set yet. The reason you get the password error is because the -p switch
means you're going to authenticate with a password. Obviously, if there
is no password (which is different than NULL or ''), you cannot use
password authentication. The password never gets set, because you were
never authenticated to run the command. Just leave out the -p the first
time, and use it after that.
<[EMAIL PROTECTED]>
