----- Original Message ----- From: "Chuck Roberts" <[EMAIL PROTECTED]> To: "alan4100" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 9:36 AM Subject: RE: mysql -u root DENIED
> > > > -----Original Message----- > > From: alan4100 [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, March 19, 2002 11:50 AM > > To: [EMAIL PROTECTED] > > Subject: mysql -u root DENIED > > > > > > I just rmdir/s the old mysql and downloaded from > > Wisconsin mirror site... > > > > Then I tried C:\mysql\bin>mysql -u root > > ERROR 1045: Access denied for user: 'root@localhost' > > (Using password: NO) > > That's because you must specify a password like: > mysql -u root -p * Is that true about the need to specify the password? I understand that mysql -u root -p will prompt password inquiry. But I dont have to reply the password at all. I can skip it by entering the <ENTER> key. So I dont need to specify the password. Hope I am correct. I can just as well use mysql -u root. Both are equilvalent. I may have to check on that again. Your information on the rest is informative, but I am using Windows XP. Your mentioning of mysql_install_db script is for UNIX exclusive. Windows XP dont have it. * > will ask you for the password. > mysql -u root -ppassword > > will supply the password on the command line. > > mysql -u root -ppassword db > > will use the database 'db' when you log in. > > Plus the user 'root' must have been put in mysql by successfully > running the bin/mysql_install_db script. > > Chuck > --------------------------------------------------------------------- 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
