Password problems using Mac OS X
Hi all, I've been using MySQL for over a year now and I didn't install anything special recently, yet I suddenly find myself locked out of MySQL. I'm using version 3.23.49 and I'm running Mac OS 10.4.6 fully up-to- date. I normally connect using the root-user but this afternoon I first got a socket error. Not the first time so I just reboot the server, socket error is gone but now I'm getting Access denied for user 'root'@'localhost' . I restarted the server a few times and even rebooted my system. I can't connect using php, terminal, MySQL Administrator, ... After a quick search on the http://dev.mysql.com/doc/refman/4.1/en/ resetting-permissions.html page. I tried that but alas, no change... This might be a good time to update to MySQL 4 if I can get my data out, but I don't see that happening without me getting access to the server once again. Does anyone have a solution? Thank you for your time Kevin Felix [EMAIL PROTECTED] (e-mail) [EMAIL PROTECTED] (MSN-Messenger) ekefster (AIM)
Re: Password problems using Mac OS X
Kevin - You can start up the MySQL server without password protection using the --skip-grant-tables option. Note that will leave your server wide open, so you may also want to use the --skip-networking option and access it through the socket on the same machine. Something like this I think: mysqld_safe --skip-grant-tables --old-passwords --user=root --skip-networking I know that Apple has packaged at least one MySQL update into the OS X 10.4.x updates. Is it possible that you got upgraded to MySQL 4.x during an Apple update? Perhaps your 3.23 installation still lives somewhere but now 4.x gets started up by the OS? Dan Kevin Felix wrote: Hi all, I've been using MySQL for over a year now and I didn't install anything special recently, yet I suddenly find myself locked out of MySQL. I'm using version 3.23.49 and I'm running Mac OS 10.4.6 fully up-to-date. I normally connect using the root-user but this afternoon I first got a socket error. Not the first time so I just reboot the server, socket error is gone but now I'm getting Access denied for user 'root'@'localhost' . I restarted the server a few times and even rebooted my system. I can't connect using php, terminal, MySQL Administrator, ... After a quick search on the http://dev.mysql.com/doc/refman/4.1/en/resetting-permissions.html page. I tried that but alas, no change... This might be a good time to update to MySQL 4 if I can get my data out, but I don't see that happening without me getting access to the server once again. Does anyone have a solution? Thank you for your time Kevin Felix [EMAIL PROTECTED] (e-mail) [EMAIL PROTECTED] (MSN-Messenger) ekefster (AIM) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Password problems using Mac OS X
Dan, A thousand times thanks for the fast reply, I just reset my password with MySQL Administrator now, everything is back the way it was! On a sidenote: I also saw this as the version MySQL 5.0.17-max via socket. The version 3 was through phpinfo(). My php install and other MySQL do all use the same database though. Does it matter what version phpinfo() is giving me? Kevin Felix Op 14-jun-06, om 05:18 heeft Dan Buettner het volgende geschreven: Kevin - You can start up the MySQL server without password protection using the --skip-grant-tables option. Note that will leave your server wide open, so you may also want to use the --skip-networking option and access it through the socket on the same machine. Something like this I think: mysqld_safe --skip-grant-tables --old-passwords --user=root --skip- networking I know that Apple has packaged at least one MySQL update into the OS X 10.4.x updates. Is it possible that you got upgraded to MySQL 4.x during an Apple update? Perhaps your 3.23 installation still lives somewhere but now 4.x gets started up by the OS? Dan Kevin Felix wrote: Hi all, I've been using MySQL for over a year now and I didn't install anything special recently, yet I suddenly find myself locked out of MySQL. I'm using version 3.23.49 and I'm running Mac OS 10.4.6 fully up- to-date. I normally connect using the root-user but this afternoon I first got a socket error. Not the first time so I just reboot the server, socket error is gone but now I'm getting Access denied for user 'root'@'localhost' . I restarted the server a few times and even rebooted my system. I can't connect using php, terminal, MySQL Administrator, ... After a quick search on the http://dev.mysql.com/doc/refman/4.1/en/ resetting-permissions.html page. I tried that but alas, no change... This might be a good time to update to MySQL 4 if I can get my data out, but I don't see that happening without me getting access to the server once again. Does anyone have a solution? Thank you for your time Kevin Felix [EMAIL PROTECTED] (e-mail) [EMAIL PROTECTED] (MSN-Messenger) ekefster (AIM) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ARGGH! - User password problems
All, I've been attempting to assign a password to a user with the following statement: UPDATE mysql.user SET password=PASSWORD('foo') WHERE user = 'acc_name'; I get the typical: Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 However, when the user attempts the login using the password they are unable (access is denied to acc_name with password yes). If they attempt to login without a password, they are successful - WTF!. There is only 1-entry in the user table for this user so I didn't specify a host. Next, for the same user account, if I try to login from a remote machine (via ODBC) I am denied access (event with the blank password!). The user has the following host '%' (no other hosts present), yet I receive an error that reads: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) HELP before I lose my mind and start pretending I am a glass of orange juice. Regards, Adam -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ARGGH! - User password problems
Hi Did you remember to flush??? - Original Message - From: Adam Fortuno KOVICK [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: July 31, 2003 4:33 PM Subject: ARGGH! - User password problems All, I've been attempting to assign a password to a user with the following statement: UPDATE mysql.user SET password=PASSWORD('foo') WHERE user = 'acc_name'; I get the typical: Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 However, when the user attempts the login using the password they are unable (access is denied to acc_name with password yes). If they attempt to login without a password, they are successful - WTF!. There is only 1-entry in the user table for this user so I didn't specify a host. Next, for the same user account, if I try to login from a remote machine (via ODBC) I am denied access (event with the blank password!). The user has the following host '%' (no other hosts present), yet I receive an error that reads: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) HELP before I lose my mind and start pretending I am a glass of orange juice. Regards, Adam -- 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]
MySQL 3.23.49 Installation - password problems
Lee, Tuesday, April 02, 2002, 8:54:44 PM, you wrote: LPR I just installed MySQL 3.23.49 on NT and executed the following LPR commands: LPR UPDATE USER SET password=password(test1) WHERE host=localhost; LPR UPDATE USER SET password=password(test1) WHERE host=%; LPR Now, after doing 'mysqladmin reload', I cannot connect... LPR mysql -p LPR Enter password: * LPR Error 1045: Access denied for user: 'ODBC@localhost' (Using password: LPR YES) If you use -p option you should also specify user name, for example: mysql -utest1 -p LPR mysql -p[test1] LPR Error 1045: Access denied for user: 'ODBC@localhost' (Using password: LPR YES) Don't use square brackets when you enter your password. LPR mysql -u root -p[test1] LPR Error 1045: Access denied for user: 'root@localhost' (Using password: LPR YES) LPR Have I done something wrong? Can I connect to the database, or do I have LPR to re-install? LPR Thanks very much in advance for any advice. LPR - Best regards, LPRLee Reilly -- 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
MySQL 3.23.49 Installation - password problems
Hi, I just installed MySQL 3.23.49 on NT and executed the following commands: UPDATE USER SET password=password(test1) WHERE host=localhost; UPDATE USER SET password=password(test1) WHERE host=%; Now, after doing 'mysqladmin reload', I cannot connect... mysql -p Enter password: * Error 1045: Access denied for user: 'ODBC@localhost' (Using password: YES) mysql -p[test1] Error 1045: Access denied for user: 'ODBC@localhost' (Using password: YES) mysql -u root -p[test1] Error 1045: Access denied for user: 'root@localhost' (Using password: YES) Have I done something wrong? Can I connect to the database, or do I have to re-install? Thanks very much in advance for any advice. - Best regards, Lee Reilly - 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: Help Password Problems!!
At 16:57 15/12/2001 -0500, Gary Wheeler wrote: Hi, shell BINDIR/safe_mysqld --skip-grant-tables shell BINDIR/mysql -u root mysql Make sure you run mysqladmin flush-privileges or mysqladmin reload afterward to tell the server to reload the grant tables. Regards, Miguel Hi All, I've done a fool thing and changed the root password to mysql server, and evidently miss typed, because now it will not let me in. How can I get back into mysql to change this?? Please help as this is a production server!! Thanks, Gary - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ 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
Re: Help Password Problems!!
Gary Wheeler wrote: I've done a fool thing and changed the root password to mysql server, and evidently miss typed, because now it will not let me in. How can I get back into mysql to change this?? Please help as this is a production server!! See the standard documentation page at http://www.mysql.com/doc/R/e/Resetting_permissions.html -- Shankar. - 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
Help Password Problems!!
Hi All, I've done a fool thing and changed the root password to mysql server, and evidently miss typed, because now it will not let me in. How can I get back into mysql to change this?? Please help as this is a production server!! Thanks, Gary - 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
Password problems
Hi all, The resolution to my problem is probably simple for many of you. However, I'm new to MySQL and php and am having difficulties. However, I'm ignorant, not stupid, and can follow directions. My setup is as follow: I had My SQL, php4 (with Zend) and phpMyAdmin installed on my Red Hat Linux dedicated server last year by the NOC tech support dept. I'm now about to use them. Yesterday, phpMyAdmin and MySQL were working. I created a couple of databases at a friend's house (he knows a bit of programming and also has phpMyAdmin. I returned home and began reading the docs. In so doing, I discovered that I had no root password set, and followed the instructions to create one. I did it via telnet and used the command shell mysqladmin -u root password George Naturally, George is not the real password. It's just less confusing to use something other than the word password to represent the password. Addendum - okay, I found out that I set my password literally to password, so I need to change it to "George". Afterwards, I was unable to access phpMyAdmin. I now get the message: Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in lib.inc.php on line 255 Error What a way to spend my birthday! Would anyone be kind enough to help me out? It would be much appreciated. Step by step literal instructions on setting up a user name and password would be appreciated also. I've been reading the docs and I don't think they do it as such. Eddie - 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 problems
It looks like MySQL is working fine, phpMyAdmin just needs to know your new password so that it can connect to the database. Just edit the "config.inc.php" file in the phpMyAdmin directory. Find the lines: $cfgServers[1]['user'] = 'root';// MySQL user (only needed with basic auth) $cfgServers[1]['password'] = 'george';// MySQL password (only needed with basic auth) Also, for security, make sure that no one but you can access phpMyAdmin from the web. Maybe use .htaccess Hope this helps, --Daniel -Original Message- From: Eddie Rhodes [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 10, 2001 8:38 PM To: [EMAIL PROTECTED] Subject: Password problems Hi all, The resolution to my problem is probably simple for many of you. However, I'm new to MySQL and php and am having difficulties. However, I'm ignorant, not stupid, and can follow directions. My setup is as follow: I had My SQL, php4 (with Zend) and phpMyAdmin installed on my Red Hat Linux dedicated server last year by the NOC tech support dept. I'm now about to use them. Yesterday, phpMyAdmin and MySQL were working. I created a couple of databases at a friend's house (he knows a bit of programming and also has phpMyAdmin. I returned home and began reading the docs. In so doing, I discovered that I had no root password set, and followed the instructions to create one. I did it via telnet and used the command shell mysqladmin -u root password George Naturally, George is not the real password. It's just less confusing to use something other than the word password to represent the password. Addendum - okay, I found out that I set my password literally to password, so I need to change it to "George". Afterwards, I was unable to access phpMyAdmin. I now get the message: Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in lib.inc.php on line 255 Error What a way to spend my birthday! Would anyone be kind enough to help me out? It would be much appreciated. Step by step literal instructions on setting up a user name and password would be appreciated also. I've been reading the docs and I don't think they do it as such. Eddie - 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: Password problems
Just to add to that, suggest you create another user, other than root, and use that instead. Look up Grant in chapter 7 of the manual on how to create users. - Original Message - From: "Daniel Von Fange" [EMAIL PROTECTED] To: "Eddie Rhodes" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, February 11, 2001 9:59 Subject: RE: Password problems It looks like MySQL is working fine, phpMyAdmin just needs to know your new password so that it can connect to the database. Just edit the "config.inc.php" file in the phpMyAdmin directory. Find the lines: $cfgServers[1]['user'] = 'root';// MySQL user (only needed with basic auth) $cfgServers[1]['password'] = 'george';// MySQL password (only needed with basic auth) Also, for security, make sure that no one but you can access phpMyAdmin from the web. Maybe use .htaccess Hope this helps, --Daniel -Original Message- From: Eddie Rhodes [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 10, 2001 8:38 PM To: [EMAIL PROTECTED] Subject: Password problems Hi all, The resolution to my problem is probably simple for many of you. However, I'm new to MySQL and php and am having difficulties. However, I'm ignorant, not stupid, and can follow directions. My setup is as follow: I had My SQL, php4 (with Zend) and phpMyAdmin installed on my Red Hat Linux dedicated server last year by the NOC tech support dept. I'm now about to use them. Yesterday, phpMyAdmin and MySQL were working. I created a couple of databases at a friend's house (he knows a bit of programming and also has phpMyAdmin. I returned home and began reading the docs. In so doing, I discovered that I had no root password set, and followed the instructions to create one. I did it via telnet and used the command shell mysqladmin -u root password George Naturally, George is not the real password. It's just less confusing to use something other than the word password to represent the password. Addendum - okay, I found out that I set my password literally to password, so I need to change it to "George". Afterwards, I was unable to access phpMyAdmin. I now get the message: Warning: MySQL Connection Failed: Access denied for user: 'root@localhost' (Using password: NO) in lib.inc.php on line 255 Error What a way to spend my birthday! Would anyone be kind enough to help me out? It would be much appreciated. Step by step literal instructions on setting up a user name and password would be appreciated also. I've been reading the docs and I don't think they do it as such. Eddie - 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 - 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