You need to specify -p on the command line to have it ask for a
password after you set one.


On Mon, 21 Mar 2005 19:09:00 -0700 (MST), Rick Kelly
<rmk@toad.rmkhome.com> wrote:
> matthew sporleder said:
> 
> >Or if you want to continue starting manually, make sure you use
> >mysqld_safe -u mysql or whatever you like.
> 
> >> PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
> >> This is done with:
> >> /usr/pkg/bin/mysqladmin -u root  password 'new-password'
> >> /usr/pkg/bin/mysqladmin -u root -h wolf  password 'new-password'
> >> See the manual for more instructions.
> 
> I reinstalled and did the above successfully.
> 
> Now as mysql user:
> 
> $ mysqladmin shutdown
> mysqladmin: shutdown failed; error: 'Access denied for user: '@localhost' (Using password: NO)'
> 
> $ mysqladmin shutdown -u mysql
> mysqladmin: shutdown failed; error: 'Access denied for user: '@localhost' (Using password: NO)'
> 
> Note that it never asks me for a password.
> 
> As system root user:
> 
> wolf#  mysqladmin shutdown
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> 
> wolf# mysqladmin shutdown -u mysql
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> 
> wolf# mysqladmin shutdown -u root
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> 
> Never asks me for a password.
> 
> How do people use this software? The online manuals are useless.
> 
> This is: mysql-server-3.23.58
> 
> --
> Rick Kelly      rmk@rmkhome.com
>                 <http://www.rmkhome.com/>
>                 <http://rkba.rmkhome.com/>
> 


-- 
_Matt