Bug #1463 when you are a real newbie to mysql - and alone - a vital install hint
Submitted: 2 Oct 2003 3:35 Modified: 11 Aug 2005 14:37
Reporter: Michael Felt Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S4 (Feature request)
Version: OS:
Assigned to: CPU Architecture:Any

[2 Oct 2003 3:35] Michael Felt
Feature Request: for Documentation

When you are really new to mysql, and follow the "instructions" from mysql_install_db to add a password it would be extremely "learner friendly" to have the -p option for mysqladmin also explained "in the manual" and not deep in the user comments on the website.

Now that I know what to look for I can find other things in the documentation regarding this. But I got stuck at step

BINDIR/mysqladmin -u root version

for too long a time. Life would have been great if the hint had been there all the time.

How to repeat:
After repeating the two hints in mysql_install_db

bin/mysqladmin -u root password 'new-pass'
bin/mysqladmin -h "hotname" -u root password 'new-pass'

Try the next commands in the installation. If you dont know there is a -p option
you only get errors.

michael@felt125:[/usr/local/mysql]./bin/mysqladmin -u root version
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

(At this point I think the error is because the connection is wiht "localhost" instead of felt125 and try all kinds of options with -u and -h)

Suggested fix:
Just add a linethat if a user has a password using -p will cause mysql to ask for it, or you can provide it on the command line.

And how to remove it from the command line!
[2 Oct 2003 10:24] Alexander Keremidarski

[11 Aug 2005 14:37] Jon Stephens
This is well documented already. Not a bug.
[11 Aug 2005 20:05] Michael Felt
Never said it was a bug. But two years ago it was a great hassle (for me) to figure out why I couldnt do anything more.

Glad to hear it has been better documented. :)