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]
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