After an install, you should be able to connect to Mysql as root without a password. Example: mysql - u root. Then SET PASSWORD FOR root@"%" = PASSWORD('biscuit'); That will set the root password for any host to biscuit. To set the password for root@localhost SET PASSWORD FOR root@localhost = PASSWORD('biscuit');
-----Original Message----- From: plainfield [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 5:46 AM To: [EMAIL PROTECTED] Subject: assigning root password Hello, I have installed mysql source distribution. Now I tried assigning the root password for mysql. I tried with " mysqladmin -u root password 'password' " and I also tried " mysql -u root mysql" so that I can insert the password for the root user. Both of these are giving same error. "cannot connect to root@localhost (Using password 'yes') " Before issuing these commands I had started the mysql server "safemysqld &". Please let me know the possible solutions to this. Regards, Prakash --------------------------------------------------------------------- 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