MySQL Bugs: #1463: when you are a real newbie to mysql - and alone

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:	None
Category:	MySQL Server: Documentation	Severity:	S4 (Feature request)
Version:		OS:
Assigned to:		CPU Architecture:	Any

Description:
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!

This is well documented already. Not a bug.

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. :)