Thank you Ray, this worked! Colin
on 6/11/02 2:59 PM, Ray at [EMAIL PROTECTED] wrote: > mysql --password > (or just -p) > > On Tuesday 11 June 2002 7:30, you wrote: >> When I try to connect to mysql as 'root' I get the following: >>> [localhost:/Users/cooldaze] root# mysql >>> ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) >> >> I can connect as a normal user, but can't create any databases or do other >> necessary admin functions, so I need to be able to connect as root >> occasionally. I think the ending phrase is preventing me from doing this. >> >> What command do I issue to change the ending phrase to "(Using password: >> YES)" ?? >> >> TIA >> >> >> --------------------------------------------------------------------- >> 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