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]
Password error
Hello MySQL Listers, Using myODBC 3.51.07, Win2k SP4, ADO 2.7 mySQL5 If I make the connection when user account does not have a password it works. If I set a password I get the error below ??? Which MySQL client is it referring to?? Any suggestions regarding connection string ?? err No -2147467259 [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client cnn.ConnectionString = DRIVER={MySQL ODBC 3.51 Driver}; _ SERVER= strServerName ; _ DATABASE= strDBName ; _ UID= strLogin ; _ PWD= strPassword ; _ OPTION=3 also tried ' OPTION= 1 + 2 + 8 + 32 + 2048 + 163841 -- Best regards, Arthur mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Password error
You can try using the old-passwords option in the my.cnf file or you can try building your ODBC driver from the bitkeeper source. I would check the documentation to verify that the ODBC build you have supports the 4.1.+ servers. -Original Message- From: Arthur Maloney To: [EMAIL PROTECTED] Sent: 5/19/04 12:28 PM Subject: Password error Hello MySQL Listers, Using myODBC 3.51.07, Win2k SP4, ADO 2.7 mySQL5 If I make the connection when user account does not have a password it works. If I set a password I get the error below ??? Which MySQL client is it referring to?? Any suggestions regarding connection string ?? err No -2147467259 [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client cnn.ConnectionString = DRIVER={MySQL ODBC 3.51 Driver}; _ SERVER= strServerName ; _ DATABASE= strDBName ; _ UID= strLogin ; _ PWD= strPassword ; _ OPTION=3 also tried ' OPTION= 1 + 2 + 8 + 32 + 2048 + 163841 -- Best regards, Arthur mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Password error
I have resently installed mysql 3.23.41 on Redhat 7.1 When I installed it, I could access the example databases 'mysql' and 'test'. Mysql said to change the root password right away with : mysqladmin -h host -u root -p password 'new password' so I did it, but now mysql won't let me log in as any user, not even root. I have tried to re-install with rpm -i --force, and uninstall with rpm -e, neither will change the permissions of mysql. What should I do? -Mike Ryerse __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.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
Re: Password error
Mike Ryerse wrote: I have resently installed mysql 3.23.41 on Redhat 7.1 When I installed it, I could access the example databases 'mysql' and 'test'. Mysql said to change the root password right away with : mysqladmin -h host -u root -p password 'new password' THis will fail since there was no password, so you probably still have no password for root. The manual has a section that explains how to reset the root password if you have forgotten it. so I did it, but now mysql won't let me log in as any user, not even root. I have tried to re-install with rpm -i --force, and uninstall with rpm -e, neither will change the permissions of mysql. What should I do? -Mike Ryerse __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.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 -- Gerald L. Clark [EMAIL PROTECTED] - 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: Password error
Mike Ryerse wrote: I have resently installed mysql 3.23.41 on Redhat 7.1 When I installed it, I could access the example databases 'mysql' and 'test'. Mysql said to change the root password right away with : mysqladmin -h host -u root -p password 'new password' Note, do not put a space between the -p and the password normally: mysqladmin -h host -u root -ppassword OR mysqladmin -h host -u root --password=password That may be why you cannot connect. so I did it, but now mysql won't let me log in as any user, not even root. Did you really put a space in the password? Or was that for demonstration purposes only? I have tried to re-install with rpm -i --force, and uninstall with rpm -e, neither will change the permissions of mysql. What should I do? As Gerald Clark said, the manual has a section on how to reset the password. --Bill - 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: Password error
On Thu, Sep 06, 2001 at 12:50:47PM -0700, Adams, Bill TQO wrote: Mike Ryerse wrote: I have resently installed mysql 3.23.41 on Redhat 7.1 When I installed it, I could access the example databases 'mysql' and 'test'. Mysql said to change the root password right away with : mysqladmin -h host -u root -p password 'new password' Note, do not put a space between the -p and the password normally: mysqladmin -h host -u root -ppassword OR mysqladmin -h host -u root --password=password That may be why you cannot connect. I tried it with 3.23.41 and BACKFIRE. so I did it, but now mysql won't let me log in as any user, not even root. Did you really put a space in the password? Or was that for demonstration purposes only? I have tried to re-install with rpm -i --force, and uninstall with rpm -e, neither will change the permissions of mysql. What should I do? As Gerald Clark said, the manual has a section on how to reset the password. --Bill - 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 -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - 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: Password error
Someone the other day said this worked: started safe_mysqld with --skip-grant-tables and then did: mysql -u root mysql mysql UPDATE user SET password=PASSWORD('abc') WHERE User='root' - AND Host='whichever host you want to match' - Original Message - From: Mike Ryerse [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 12:23 PM Subject: Password error I have resently installed mysql 3.23.41 on Redhat 7.1 When I installed it, I could access the example databases 'mysql' and 'test'. Mysql said to change the root password right away with : mysqladmin -h host -u root -p password 'new password' so I did it, but now mysql won't let me log in as any user, not even root. I have tried to re-install with rpm -i --force, and uninstall with rpm -e, neither will change the permissions of mysql. What should I do? -Mike Ryerse __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.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 - 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
reset root password error
Following the manual at http://www.mysql.com/doc/R/e/Resetting_permissions.html, I still get the following error: # mysqladmin -h 127.0.0.1 -u root password 'newpass' mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others' Can anyone help with this error? A search through the mail archives and google yield nothing. The system is a OpenBSD 2.9 running mysql: # /usr/local/libexec/mysqld -V /usr/local/libexec/mysqld Ver 3.23.37 for unknown-openbsd2.9 on i386 Thanks for your help, -Chad - 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