Just a question, did you ever change your password for Mysql? If not don't use the -p option
mysqladmin -u root create testdb On Tue, 2002-11-05 at 11:08, Jack Chen wrote: > Thanks, but I still got complains that can't access server: > > 'Access denied for user: 'root@localhost' (Using password: YES) > > Is it possible that for some reason the password is wrong? > > You input is greatly appreaciated, > > Puzzled newbie, > > Jack > > ++++++++++++++++++++++++++++++++++++++++++++++++ > Jack Chen, Stein Lab, Cold Spring Harbor Labs > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > ++++++++++++++++++++++++++++++++++++++++++++++++ > > On 5 Nov 2002, Michael Gargiullo wrote: > > > right, sorry, I could have been more specific. > > > > like so: mysqladmin -u root -p command, command... > > > > example: mysqladmin -u root -p create mytestdatabase > > > > On Tue, 2002-11-05 at 10:33, Jack Chen wrote: > > > Stangely, it gave me a page of *information* like this: [any idea? > > > thanks!] > > > > > > mysqladmin Ver 8.23 Distrib 3.23.49, for redhat-linux-gnu on i386 > > > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB > > > This software comes with ABSOLUTELY NO WARRANTY. This is free software, > > > and you are welcome to modify and redistribute it under the GPL license > > > > > > Administration program for the mysqld daemon. > > > Usage: mysqladmin [OPTIONS] command command.... > > > > > > -#, --debug=... Output debug log. Often this is 'd:t:o,filename` > > > -f, --force Don't ask for confirmation on drop database; with > > > multiple commands, continue even if an error > > > occurs > > > -?, --help Display this help and exit > > > --character-sets-dir=... > > > Set the character set directory > > > -C, --compress Use compression in server/client protocol > > > -h, --host=# Connect to host > > > -p, --password[=...] Password to use when connecting to server > > > If password is not given it's asked from the tty > > > -P --port=... Port number to use for connection > > > -i, --sleep=sec Execute commands again and again with a sleep > > > between > > > -r, --relative Show difference between current and previous > > > values > > > when used with -i. Currently works only with > > > extended-status > > > -E, --vertical Print output vertically. Is similar to --relative, > > > but prints output vertically. > > > -s, --silent Silently exit if one can't connect to server > > > -S, --socket=... Socket file to use for connection > > > -u, --user=# User for login if not current user > > > -v, --verbose Write more information > > > -V, --version Output version information and exit > > > -w, --wait[=retries] Wait and retry if connection is down > > > > > > > > > ++++++++++++++++++++++++++++++++++++++++++++++++ > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > > > ++++++++++++++++++++++++++++++++++++++++++++++++ > > > > > > On 5 Nov 2002, Michael Gargiullo wrote: > > > > > > > use: mysqladmin -u root -p > > > > > > > > It will prompt you for the password > > > > > > > > On Tue, 2002-11-05 at 10:03, Jack Chen wrote: > > > > > Dear all, > > > > > > > > > > When I ran the follwing command: > > > > > > > > > > >$ mysqladmin -u root password PASSWORD > > > > > mysqladmin: connect to server at 'localhost' failed > > > > > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > > > > > > > > > > Could you inform me why? > > > > > > > > > > Thanks, > > > > > > > > > > Jack > > > > > ++++++++++++++++++++++++++++++++++++++++++++++++ > > > > > Jack Chen, Stein Lab, Cold Spring Harbor Labs > > > > > 1 Bungtown Road, Cold Spring Harbor, NY, 11724 > > > > > Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] > > > > > ++++++++++++++++++++++++++++++++++++++++++++++++ > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > Before posting, please check: > > > > > http://www.mysql.com/manual.php (the manual) > > > > > http://lists.mysql.com/ (the list archive) > > > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > > To unsubscribe, e-mail ><[EMAIL PROTECTED]> > > > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php