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