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/>