Re: Changing root password
If you have just finished installing, then root has no current password and you can leave out the -p altogether: root@localhost bin]# ./mysqladmin -u root password 'new-password' good luck Richard Ward Jay Paulson [EMAIL PROTECTED] 01/16/02 12:57AM I'm trying to change the root password for mysql. This is the first time I've tried to change the password and I can't get it to work. Below is the error message I get: [root@localhost bin]# ./mysqladmin -u root -p password 'new-password' Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I've looked at the manual and it doesn't say much that I've already done. I've also looked up the --skip-grant-tables but the only mysqld file I have to run is in the /etc/rc.d/init.d/ directory and it doesn't take the --skip-grant-tables flag. So I'm at a lost at what to do next. thanks. -- Content-Type: text/plain; Content-Disposition: attachment; filename=disclaimer.txt . 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
Re: Changing root password
Skip the -p. You have no current password . Jay Paulson wrote: I'm trying to change the root password for mysql. This is the first time I've tried to change the password and I can't get it to work. Below is the error message I get: [root@localhost bin]# ./mysqladmin -u root -p password 'new-password' Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I've looked at the manual and it doesn't say much that I've already done. I've also looked up the --skip-grant-tables but the only mysqld file I have to run is in the /etc/rc.d/init.d/ directory and it doesn't take the --skip-grant-tables flag. So I'm at a lost at what to do next. thanks. - 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
RE: Changing root password
The file in the /etc/rc.d/init.d is likely called S95mysql, and you CAN add that parameter to that file. You'll need to edit the file, and add something like this: /opt/mysql/bin/mysqld \ --basedir=opt/mysql \ ... --skip-grant-tables \ ... /var/log/mysql/mysql.err 21 The ...'s above are other parameters that may or may not be there. -Original Message- From: Jay Paulson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 4:57 PM To: [EMAIL PROTECTED] Subject: Changing root password I'm trying to change the root password for mysql. This is the first time I've tried to change the password and I can't get it to work. Below is the error message I get: [root@localhost bin]# ./mysqladmin -u root -p password 'new-password' Enter password: ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I've looked at the manual and it doesn't say much that I've already done. I've also looked up the --skip-grant-tables but the only mysqld file I have to run is in the /etc/rc.d/init.d/ directory and it doesn't take the --skip-grant-tables flag. So I'm at a lost at what to do next. thanks. - 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
