----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 7:20
Subject: HELP!!!!! How to set root password?
>
>
> I've been reading the documentation for the last 3 hours in search for
> the answer to this question, to no avail. To preserve the little
> eyesight I have left, I've decided to post it.
>
>
> I've been trying to install mysql-max-3.23.39 on a Linux system
> (pc-linux-gnu-i686). The daemon runs fine, but how does one *set* the
> password for root after a fresh installation?
>
> The only information I've been able to find is:
>
> PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
> This is done with:
> ./bin/mysqladmin -u root -p password 'new-password'
> ./bin/mysqladmin -u root -h my.machine.com -p password 'new-password'
>
> from the output of mysql_install_db. What does it mean? The usage
> info for mysqladmin says:
>
> -p, --password[=...] Password to use when connecting to server
> If password is not given it's asked from the tty
>
> Does that mean that the word 'password' in
>
> ./bin/mysqladmin -u root -p password 'new-password'
>
> represents the initial root password?
No it isn't. It is a little misleading at first but if you use a password
on the command line (not a good idea BTW), then there is no space. eg
./bin/mysqladmin -u root -pA_PASSWORD password 'new-password'
But -p is not needed because it is a new installation.
> Isn't root supposed to start out with no password?
YES. see above.
> And what does 'new-password' refer to?
The root password. And, yes, don't put it in quotes.
>
> Anyway, if I ignore the fact that it's nonsensical, and I type the
> above I get:
>
> # ./bin/mysqladmin -u root -p password 'new-password'
> Enter password:
> ./bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: YES)'
>
> What is going on?
>
> Thanks,
>
> KJ
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
