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