> Also, if I (mysql -u root -p root) from localhost, then it prompts me > for a password. I enter password 'root' and then I get this error:
That's what's supposed to happen: You use ~> mysql -u username -p database_name Then you are prompted for the password for root and it will start in database 'database_name' If you want to enter the root password on the command line use: ~> mysql -u username -prootpass database_name Where root pass is the root password. Note no space after the -p If you don't want to select a database right away, just leave off database_name from either of those two commands. Russell. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
