Resetting the password error
While trying to login to the server I got the following errors: Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\c:\mysql\bin\mysql -root -p Enter password: * ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) C:\c:\mysql\bin\mysql -root -p Enter password: ** ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) C:\c:\mysql\bin\mysqlshow c:\mysql\bin\mysqlshow: Access denied for user: '[EMAIL PROTECTED]' (Using password : NO) C:\c:\mysql\bin\mysqladmin -u root password my-password-here c:\mysql\bin\mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' C:\c:\mysql\bin\mysqladmin -u root -h fayec password my-password-here c:\mysql\bin\mysqladmin: connect to server at 'fayec' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' Then I started the service with: C:\c:\mysql\bin\mysqld-nt --skip-grant-tables I am now trying to reset my root password but I am getting errors when trying to do so. I followed the instructions on: http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html but when I get to the point I have to use: flush-privileges password newpwd I get the following error: 'flush-privileges' is not recognized as an internal or external command, operable program or batch file. I have no clue how to go on from hereanybody?? I am trying to login to be able to create a db but it won't let me through without a password and it won't accept the password I had set before (pretty sure about the old password as it is the same I use for all my local projects). Any tips will be extremely appreciated. Thanks in advance. FayeC -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Resetting the password error
Michael FayeC SQL wrote: While trying to login to the server I got the following errors: Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\c:\mysql\bin\mysql -root -p Enter password: * ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) C:\c:\mysql\bin\mysql -root -p Enter password: ** ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) -root doesn't mean anything, so this is trying to log in as the default user, [EMAIL PROTECTED] What you need is C:\c:\mysql\bin\mysql -u root -p C:\c:\mysql\bin\mysqlshow c:\mysql\bin\mysqlshow: Access denied for user: '[EMAIL PROTECTED]' (Using password : NO) Same here. Should be C:\c:\mysql\bin\mysqlshow -u root -p C:\c:\mysql\bin\mysqladmin -u root password my-password-here c:\mysql\bin\mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' [EMAIL PROTECTED] already has a password, so you can't change it without authenticating. Try C:\c:\mysql\bin\mysqladmin -u root -p password my-password-here C:\c:\mysql\bin\mysqladmin -u root -h fayec password my-password-here c:\mysql\bin\mysqladmin: connect to server at 'fayec' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' Here you change your connection method, but you still didn't give the password. You need -p (and [EMAIL PROTECTED] would have to be an authorized user). Then I started the service with: C:\c:\mysql\bin\mysqld-nt --skip-grant-tables I am now trying to reset my root password but I am getting errors when trying to do so. I followed the instructions on: http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html but when I get to the point I have to use: flush-privileges password newpwd I get the following error: 'flush-privileges' is not recognized as an internal or external command, operable program or batch file. I believe you've been bitten by bad formatting in the manual. The command should be C:\mysql\bin\mysqladmin -u root flush-privileges password newpwd I have no clue how to go on from hereanybody?? I am trying to login to be able to create a db but it won't let me through without a password and it won't accept the password I had set before (pretty sure about the old password as it is the same I use for all my local projects). Any tips will be extremely appreciated. Thanks in advance. FayeC Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
resetting a password
hello, following the instructions for resetting a password ( http://www.mysql.com/doc/R/e/Resetting_permissions.html ), i was not able to find the .pid file. is it possible to continue the process without killing it? what would be the command to restart the daemon using the --skip-grant-tables option? i wasn't able to figure it out. any help would be appreciated ... thx jeremy - 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
resetting a password
jeremy, Tuesday, February 05, 2002, 8:32:23 PM, you wrote: jr following the instructions for resetting a password ( jr http://www.mysql.com/doc/R/e/Resetting_permissions.html ), jr i was not able to find the .pid file. is it possible to continue the process jr without killing it? If you have running mysql server, you should take down mysqld. When you restart mysqld .pid file will be created. jr what would be the command to restart the daemon using the jr --skip-grant-tables option? i wasn't able to figure it out. safe_mysqld --skip-grant-tables jr any help would be appreciated ... jr thx jr jeremy -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
resetting a password
hello, following the instructions for resetting a password ( http://www.mysql.com/doc/R/e/Resetting_permissions.html ), i was not able to find the .pid file. is it possible to continue the process without killing it? what would be the command to restart the daemon using the --skip-grant-tables option? i wasn't able to figure it out. any help would be appreciated ... thx jeremy - 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: Resetting root password
Read section 6.3 of the manual - restart mysqld with --skip-grant-tables. Dave At 10:35 18/05/01 +1000, you wrote: Hi all, Just a quick question. A friend of mine installed a mysql on a new FreeBSD box, and for some reason the root password wasnt empty. He has root access on the box but cant get into mysql as root to make the needed changes to mysql ready for use. Is there any way a user logged on as root can reset the mysql root password so he can go in and reset it ? Thanks Chris - 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