Fresh installation? Then you don't need -p option. If not, what password
are you using when it ask you to enter the password. It's not newpassword
as you typed in the prompt, it's your old password
----- Original Message -----
From: "Neil Zanella" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, January 11, 2001 12:31
Subject: please help setting password
>
> Hello,
>
> I have installed the RPMs and I am now trying to set the MySQL root
> password as the output of the RPM files tells me to do...
>
> [root@tulip /root]# su mysql
> [mysql@tulip /root]$ /usr/bin/mysqladmin -u root -p password newpassword
> Enter password:
> /usr/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: YES)'
> [mysql@tulip /root]$ exit
> [root@tulip /root]# /usr/bin/mysqladmin -u root -p password newpassword
> Enter password:
> /usr/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: YES)'
> [root@tulip /root]#
>
> I cannot get this to work. Other than that I can login as root and
> create a database or login with "mysql -u root" as a regular user
> with no password and use databases etc... The only problem I am
> facing right now is the security risk of not being able to set
> a root password. And what does (Using password: YES) mean. I tried
> entering YES as my password but it did not work. Also, how come
> I am instructed to enter the MySQL root password on the command line?
> Isn't this a security risk because the characters are echoed?
>
> I have looked at the documentation and searched the archivesbut for
> some reason I was not able to find a concrete clear answer on how to
> do this and my PHP book seems to skip this step. Maybe I should look
> at a book on MySQL but then the book might be outdated since 3.20 is
> no longer supported.
>
> Thanks for your help,
>
> Neil
>
>
> --
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/documentation/manual.php" before
> posting. To request this thread, e-mail [EMAIL PROTECTED]
>
> To unsubscribe, send a message to:
> <[EMAIL PROTECTED]>
>
> If you have a broken mail client that cannot send a message to
> the above address (Microsoft Outlook), you can use:
> http://lists.mysql.com/php/unsubscribe.php
--
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php" before
posting. To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, send a message to:
<[EMAIL PROTECTED]>
If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
http://lists.mysql.com/php/unsubscribe.php
