MySQL password issue
Hi All, Today I ran into an interesting problem with my MySQL installation. I'll start off with the usual suspects: this is my development laptop running Windows 7 Ultimate 64-bit this is a fresh install, fully updated from Windows Update. I downloaded the Windows Installer version of MySQL which is MySQL 5.5.28 Community Server. I ran the setup choosing Developer install, made a root password, then created two users for Backup and Replication. The install completed successfully, and I was able to start MySQL Workbench logging in as root once. I made a user in Server Administration and then imported a .sql backup file. I then went to SQL Development to review the result of the restore. I wasn't able to view the imported tables, Workbench seemed stuck on Retrieving Tables. This database is driving a website I'm working on, and I was able to load the site in a browser on my laptop - again once. Next, I went to add another user, and then tried to import another .sql backup file. This time, when I clicked Start Import, Workbench prompted me to enter my root password again. Odd I thought, as I'd originally told Workbench to save the password in its vault. Unfortunately, Workbench won't accept the root password. I receive the following message in a popup window: Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at localhost:3306: Access denied for user 'root'@'localhost' (using password: YES) The MySQL Service is still running, I've tried stopping, starting, and just restarting the service. I've tried rebooting. All with the same result. What could have happened to this install to make MySQL no longer accept my password? I have already tried uninstalling via the MySQL Installer, confirming that C:\ProgramData\MySQL was removed, and then shutting Windows down completely before trying to re-install. The same result happens - I'm able to log in once, then several minutes later it will no longer accept a password. This is a fresh install again, so there's not a lot of pain in uninstalling and reinstalling. Any thoughts on why this is happening, or more importantly, how to correct the problem? TIA, -Tim
RE: MySQL password issue
Hi Tim, It looks like your '.sql backup file' has changed the password for root user and why it is persisting is perhaps you have data directory outside the install directory. How you correct the problem: Stop the service, start the service with option '--skip-grant-tables', login with root user and change the password from inside mysql. Hope that helps. -Original Message- From: Tim Thorburn [mailto:webmas...@athydro.com] Sent: Thursday, October 25, 2012 12:08 PM To: mysql@lists.mysql.com Subject: MySQL password issue Hi All, Today I ran into an interesting problem with my MySQL installation. I'll start off with the usual suspects: this is my development laptop running Windows 7 Ultimate 64-bit this is a fresh install, fully updated from Windows Update. I downloaded the Windows Installer version of MySQL which is MySQL 5.5.28 Community Server. I ran the setup choosing Developer install, made a root password, then created two users for Backup and Replication. The install completed successfully, and I was able to start MySQL Workbench logging in as root once. I made a user in Server Administration and then imported a .sql backup file. I then went to SQL Development to review the result of the restore. I wasn't able to view the imported tables, Workbench seemed stuck on Retrieving Tables. This database is driving a website I'm working on, and I was able to load the site in a browser on my laptop - again once. Next, I went to add another user, and then tried to import another .sql backup file. This time, when I clicked Start Import, Workbench prompted me to enter my root password again. Odd I thought, as I'd originally told Workbench to save the password in its vault. Unfortunately, Workbench won't accept the root password. I receive the following message in a popup window: Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at localhost:3306: Access denied for user 'root'@'localhost' (using password: YES) The MySQL Service is still running, I've tried stopping, starting, and just restarting the service. I've tried rebooting. All with the same result. What could have happened to this install to make MySQL no longer accept my password? I have already tried uninstalling via the MySQL Installer, confirming that C:\ProgramData\MySQL was removed, and then shutting Windows down completely before trying to re-install. The same result happens - I'm able to log in once, then several minutes later it will no longer accept a password. This is a fresh install again, so there's not a lot of pain in uninstalling and reinstalling. Any thoughts on why this is happening, or more importantly, how to correct the problem? TIA, -Tim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: MySQL password issue
Not sure how the .sql backup file would have done that, but it seems to be working now. I'll just step away slowly and carry on. Thanks for the help! On 10/25/2012 2:45 AM, Nitin Mehta wrote: Hi Tim, It looks like your '.sql backup file' has changed the password for root user and why it is persisting is perhaps you have data directory outside the install directory. How you correct the problem: Stop the service, start the service with option '--skip-grant-tables', login with root user and change the password from inside mysql. Hope that helps. -Original Message- From: Tim Thorburn [mailto:webmas...@athydro.com] Sent: Thursday, October 25, 2012 12:08 PM To: mysql@lists.mysql.com Subject: MySQL password issue Hi All, Today I ran into an interesting problem with my MySQL installation. I'll start off with the usual suspects: this is my development laptop running Windows 7 Ultimate 64-bit this is a fresh install, fully updated from Windows Update. I downloaded the Windows Installer version of MySQL which is MySQL 5.5.28 Community Server. I ran the setup choosing Developer install, made a root password, then created two users for Backup and Replication. The install completed successfully, and I was able to start MySQL Workbench logging in as root once. I made a user in Server Administration and then imported a .sql backup file. I then went to SQL Development to review the result of the restore. I wasn't able to view the imported tables, Workbench seemed stuck on Retrieving Tables. This database is driving a website I'm working on, and I was able to load the site in a browser on my laptop - again once. Next, I went to add another user, and then tried to import another .sql backup file. This time, when I clicked Start Import, Workbench prompted me to enter my root password again. Odd I thought, as I'd originally told Workbench to save the password in its vault. Unfortunately, Workbench won't accept the root password. I receive the following message in a popup window: Cannot Connect to Database Server Your connection attempt failed for user 'root' from your host to server at localhost:3306: Access denied for user 'root'@'localhost' (using password: YES) The MySQL Service is still running, I've tried stopping, starting, and just restarting the service. I've tried rebooting. All with the same result. What could have happened to this install to make MySQL no longer accept my password? I have already tried uninstalling via the MySQL Installer, confirming that C:\ProgramData\MySQL was removed, and then shutting Windows down completely before trying to re-install. The same result happens - I'm able to log in once, then several minutes later it will no longer accept a password. This is a fresh install again, so there's not a lot of pain in uninstalling and reinstalling. Any thoughts on why this is happening, or more importantly, how to correct the problem? TIA, -Tim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Fwd: ODBC MySQL Password as plain text
I wondered if anyone else had any thoughts on this issue ? Cheers Neil On Thu, Nov 19, 2009 at 12:40 PM, Jay Ess li...@netrogenic.com wrote: Tompkins Neil wrote: Following my previous email. I've now configured my database connection using a ODBC DNSLESS SSL connection. However the problem still remains, the password is stored in the ASP file in plain text. Does anyone have any recommendations on how to overcome this issue ? Secure the access to the ASP-source file. You *could* encrypt it but then you have to store the key for it somewhere the ASP can access and . Catch 22. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=neil.tompk...@googlemail.com
Re: Fwd: ODBC MySQL Password as plain text
Don Thanks for your response. The issue I have is that the password for our database is stored either in the ODBC registry or within our ASP page as plain text. One option I have is to encrypt the password in the database connnection string and have a function with a key in a external file that can unlock it. The problem remains though - that if the web server is hacked, the hacker can still navigation there way to the file containing the key to unlock the password. Does that make any sense ? Cheers Neil On Fri, Nov 20, 2009 at 3:18 PM, Don Cohen don-mysq...@isis.cs3-inc.comwrote: Tompkins Neil writes: I wondered if anyone else had any thoughts on this issue ? Following my previous email. I've now configured my database connection using a ODBC DNSLESS SSL connection. However the problem still remains, I'm not sure what dnsless means (that you allow only certain ip addresses?) or what difference it makes. the password is stored in the ASP file in plain text. Does anyone have any recommendations on how to overcome this issue ? Is the issue that you're worried that your web server will serve the contents of the asp file? And I gather that you want the file to access the DB without the user having to supply a password. I'll just guess that asp files are similar to php files. One thing you could do is have that file read the password from another file that is in some place where the web server does not look. Secure the access to the ASP-source file. You *could* encrypt it but then you have to store the key for it somewhere the ASP can access and . Catch 22.
Fwd: ODBC MySQL Password as plain text
Following my previous email. I've now configured my database connection using a ODBC DNSLESS SSL connection. However the problem still remains, the password is stored in the ASP file in plain text. Does anyone have any recommendations on how to overcome this issue ? Cheers Neil -- Forwarded message -- From: Tompkins Neil neil.tompk...@googlemail.com Date: Wed, Nov 18, 2009 at 5:59 PM Subject: ODBC MySQL Password as plain text To: [MySQL] mysql@lists.mysql.com Hi The MySQL ODBC connection password is stored as plain text in the Windows registry. What is the best way to overcome this issue - to ensure the password is saved securely Thanks, Neil
Re: Fwd: ODBC MySQL Password as plain text
Tompkins Neil wrote: Following my previous email. I've now configured my database connection using a ODBC DNSLESS SSL connection. However the problem still remains, the password is stored in the ASP file in plain text. Does anyone have any recommendations on how to overcome this issue ? Secure the access to the ASP-source file. You *could* encrypt it but then you have to store the key for it somewhere the ASP can access and . Catch 22. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Fwd: ODBC MySQL Password as plain text
Hi Jay, This was my thought. Maybe encrypt the pasword in the DNSless connection and have a key somewhere within a external file. However if someone found the key in this file they could still access it. Any other thoughts on how to overcome this ? Cheers Neil On Thu, Nov 19, 2009 at 12:40 PM, Jay Ess li...@netrogenic.com wrote: Tompkins Neil wrote: Following my previous email. I've now configured my database connection using a ODBC DNSLESS SSL connection. However the problem still remains, the password is stored in the ASP file in plain text. Does anyone have any recommendations on how to overcome this issue ? Secure the access to the ASP-source file. You *could* encrypt it but then you have to store the key for it somewhere the ASP can access and . Catch 22. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=neil.tompk...@googlemail.com
ODBC MySQL Password as plain text
Hi The MySQL ODBC connection password is stored as plain text in the Windows registry. What is the best way to overcome this issue - to ensure the password is saved securely Thanks, Neil
Newbie question: how to change the mysql password
Hello everyone, I'm new to mysql so please forgive the basic question. I'm running redhat 8.0 with Mysql 4. The install was done with the mysql user. However every time I try to get access, I get denied. Can someone tell me how to change the password? Thanks, James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Newbie question: how to change the mysql password
You need to set up the initial privileges. Just follow the directions here: http://www.mysql.com/doc/en/Default_privileges.html Note: you shouldn't need to run mysql_install_db if you installed the rpm. (I think) -Original Message- From: James Marcinek [mailto:[EMAIL PROTECTED] Sent: Saturday, December 20, 2003 8:53 PM To: [EMAIL PROTECTED] Subject: Newbie question: how to change the mysql password Hello everyone, I'm new to mysql so please forgive the basic question. I'm running redhat 8.0 with Mysql 4. The install was done with the mysql user. However every time I try to get access, I get denied. Can someone tell me how to change the password? Thanks, James -- 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]
Re: MySQL Password
mysqladmin password secret should work if not then mail i'll work out a bit and reply. -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Thanks for your quick response dear harsh. I have the root privilege and forgot the MySQL password. Is there anyway to clear the password, or retrieve it? DT At 11:13 AM 7/2/2003, harsh wrote: You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- 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] --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
I m sorry ,try the earlier solution posted by someone else i.e to restart mysql server with grant tables disabled.and then reset the password. that;s the only method given in the documentation 2 at mysql.com,though i cdn't get it working. again sorry for misdirections harsh On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: access denied... DT At 11:56 AM 7/2/2003, harsh wrote: mysqladmin password secret should work if not then mail i'll work out a bit and reply. -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Thanks for your quick response dear harsh. I have the root privilege and forgot the MySQL password. Is there anyway to clear the password, or retrieve it? DT At 11:13 AM 7/2/2003, harsh wrote: You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards --- --- harsh http://www.cse.iitb.ac.in/~harsh --- --- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- 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] --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
Hi harsh, perhaps I made a litttle mistake (havent done it recently ). try the --skip-grant-tables option for safe_mysqld like this safe_mysqld --skip-grant-tables That should be doing it. Best regards Nils Valentin Tokyo/japan 2003 7 2 17:02harsh : I m sorry ,try the earlier solution posted by someone else i.e to restart mysql server with grant tables disabled.and then reset the password. that;s the only method given in the documentation 2 at mysql.com,though i cdn't get it working. again sorry for misdirections harsh On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: access denied... DT At 11:56 AM 7/2/2003, harsh wrote: mysqladmin password secret should work if not then mail i'll work out a bit and reply. -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Thanks for your quick response dear harsh. I have the root privilege and forgot the MySQL password. Is there anyway to clear the password, or retrieve it? DT At 11:13 AM 7/2/2003, harsh wrote: You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards --- --- harsh http://www.cse.iitb.ac.in/~harsh --- --- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- 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] --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
Well its not your fault,its actually confusing the documentation says run the mysqld command with the skip-grant-tables option but there is no such command available (atleast in my box) i found the command hidden in /usr/libexec/mysqld but that 2 gives error. safe_mysqld is indeed the command for this,thanks for the help harsh -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Nils Valentin wrote: Hi harsh, perhaps I made a litttle mistake (havent done it recently ). try the --skip-grant-tables option for safe_mysqld like this safe_mysqld --skip-grant-tables That should be doing it. Best regards Nils Valentin Tokyo/japan 2003年 7月 2日 水曜日 17:02、harsh さんは書きました: I m sorry ,try the earlier solution posted by someone else i.e to restart mysql server with grant tables disabled.and then reset the password. that;s the only method given in the documentation 2 at mysql.com,though i cdn't get it working. again sorry for misdirections harsh On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: access denied... DT At 11:56 AM 7/2/2003, harsh wrote: mysqladmin password secret should work if not then mail i'll work out a bit and reply. -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Thanks for your quick response dear harsh. I have the root privilege and forgot the MySQL password. Is there anyway to clear the password, or retrieve it? DT At 11:13 AM 7/2/2003, harsh wrote: You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards --- --- harsh http://www.cse.iitb.ac.in/~harsh --- --- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- 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] --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- 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]
Re: MySQL Password
Hi Harsh, Hi MySQL AB ;-) I agree this section could be made a bit clearer. Is this hint big enough for MySQL AB ;-) ?? Best regards Nils Valentin Tokyo/Japan 2003 7 2 18:08harsh : Well its not your fault,its actually confusing the documentation says run the mysqld command with the skip-grant-tables option but there is no such command available (atleast in my box) i found the command hidden in /usr/libexec/mysqld but that 2 gives error. safe_mysqld is indeed the command for this,thanks for the help harsh --- --- harsh http://www.cse.iitb.ac.in/~harsh --- --- On Wed, 2 Jul 2003, Nils Valentin wrote: Hi harsh, perhaps I made a litttle mistake (havent done it recently ). try the --skip-grant-tables option for safe_mysqld like this safe_mysqld --skip-grant-tables That should be doing it. Best regards Nils Valentin Tokyo/japan 2003 7 2 17:02harsh : I m sorry ,try the earlier solution posted by someone else i.e to restart mysql server with grant tables disabled.and then reset the password. that;s the only method given in the documentation 2 at mysql.com,though i cdn't get it working. again sorry for misdirections harsh On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: access denied... DT At 11:56 AM 7/2/2003, harsh wrote: mysqladmin password secret should work if not then mail i'll work out a bit and reply. -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Thanks for your quick response dear harsh. I have the root privilege and forgot the MySQL password. Is there anyway to clear the password, or retrieve it? DT At 11:13 AM 7/2/2003, harsh wrote: You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards --- --- harsh http://www.cse.iitb.ac.in/~harsh --- --- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- 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] --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html --- Deependra b. Tandukar International Centre for Integrated Mountain Development (ICIMOD) http://www.icimod.org -- http://www.prempanda.net http://www.mtnforum.org/apmn http://www.hkh-friend.net/ http://www.pardyp.org http://www.southasianfloods.org/ http://www.icimod-gis.net/web/index.html -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
Nils Valentin [EMAIL PROTECTED] wrote: I agree this section could be made a bit clearer. Is this hint big enough for MySQL AB ;-) ?? What exactly is not clear enough for you? --skip-grant-tables is option of mysqld, not safe_mysqld. safe_mysqld is the script that runs mysqld. 2003? 7? 2? ??? 18:08?harsh : Well its not your fault,its actually confusing the documentation says run the mysqld command with the skip-grant-tables option but there is no such command available (atleast in my box) i found the command hidden in /usr/libexec/mysqld but that 2 gives error. safe_mysqld is indeed the command for this,thanks for the help -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
Hi Victoria, I enclose a sample. http://www.mysql.com/doc/en/Resetting_permissions.html ... 2. Restart mysqld with the --skip-grant-tables option. ... How would you understand this ? restarting mysqld or starting safe_mysqld ?? Don't get me wrong the manual is not bad, but it leaves a lot of interpretation or vague guessing room for some descriptions. Anyway having spoken to somebody from MySQL AB I understand that they are working on it and hopefully make the manual better than it already is. ;-) Best regards Nils Valentin Tokyo/Japan 2003 7 2 18:57Victoria Reznichenko : Nils Valentin [EMAIL PROTECTED] wrote: I agree this section could be made a bit clearer. Is this hint big enough for MySQL AB ;-) ?? What exactly is not clear enough for you? --skip-grant-tables is option of mysqld, not safe_mysqld. safe_mysqld is the script that runs mysqld. 2003? 7? 2? ??? 18:08?harsh : Well its not your fault,its actually confusing the documentation says run the mysqld command with the skip-grant-tables option but there is no such command available (atleast in my box) i found the command hidden in /usr/libexec/mysqld but that 2 gives error. safe_mysqld is indeed the command for this,thanks for the help -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
Nils Valentin [EMAIL PROTECTED] wrote: Hi Victoria, I enclose a sample. http://www.mysql.com/doc/en/Resetting_permissions.html ... 2. Restart mysqld with the --skip-grant-tables option. ... How would you understand this ? restarting mysqld or starting safe_mysqld ?? Start mysqld with --skip-grant-tables option :) safe_mysqld hasn't option --skip-grant-tables. You can start mysqld using safe_mysqld and mysql.server scripts or mysqld directly. There is another section in the MySQL manual that describes how to start MySQL server. Don't get me wrong the manual is not bad, but it leaves a lot of interpretation or vague guessing room for some descriptions. Anyway having spoken to somebody from MySQL AB I understand that they are working on it and hopefully make the manual better than it already is. ;-) Sure. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
Hi Victoria, 2003 7 2 22:05Victoria Reznichenko : Nils Valentin [EMAIL PROTECTED] wrote: Hi Victoria, I enclose a sample. http://www.mysql.com/doc/en/Resetting_permissions.html ... 2. Restart mysqld with the --skip-grant-tables option. ... How would you understand this ? restarting mysqld or starting safe_mysqld ?? Start mysqld with --skip-grant-tables option :) safe_mysqld hasn't option --skip-grant-tables. Thats the point it should be mentioned explicitely f.e as a example safe_mysqld --skip-grant-tables You can start mysqld using safe_mysqld and mysql.server scripts or mysqld directly. There is another section in the MySQL manual that describes how to start MySQL server. The point is to provide all necessary information easy understandable in a single document WITHOUT having to look through several documents or pages. I know its hard to write a good documentation this way, but I hope the documentation can improve a bit in this way. Best regards Nils Valentin Tokyo/Japan Don't get me wrong the manual is not bad, but it leaves a lot of interpretation or vague guessing room for some descriptions. Anyway having spoken to somebody from MySQL AB I understand that they are working on it and hopefully make the manual better than it already is. ;-) Sure. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Password
Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Password
You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards -- harsh http://www.cse.iitb.ac.in/~harsh -- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- 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]
Re: MySQL Password
Hi there, Restart the mysql server with option --skip-grant-tables. You can then login without password. And then you reset your password with the update command like this: UPDATE user SET password='' WHERE user='root'; Restart the server again. Set a new password with mysqladmin like this: mysqladmin -u root password xxx mysqladmin -u root flush-privileges (xxx is your new password) That should be it. Mysql has a nice manual by the way where it is all described detailed, comes in very handy to have such a print close, just in case ;-) Best regards Nils Valentin Tokyo/Japan 2003 7 2 14:28harsh : You can set password again using root and mysqladmin command.try mysqladmin --help. correct me if i m wrong regards --- --- harsh http://www.cse.iitb.ac.in/~harsh --- --- On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: Dear all, I am running RedHat 7.2 with MySQL, Apache and PHP. I forgot MySQL password, how can it be retrieved? Looking forward to hearing from you all. Regards, DT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re: MySQL password confusion.
On Sunday 22 December 2002 06:29, William Bradley wrote: At the present time I am using Mandrake 9.0 and installed the MySql programmes that con the three disks: MySQL-3.23.52-1mdk.i586.rpm* MySQL-bench-3.23.52-1mdk.i586.rpm* MySQL-client-3.23.52-1mdk.i586.rpm* MySQL-Max-3.23.52-1mdk.i586.rpm #mysql_install_db has been run. The last time I did this it said to change the root password in the book I am using: Sams Teach Yourself MySQL in 21 Days with the following: #mysqladmin -password newpassword As the old password is supposed to be empty I used the following on the command line: #mysqladmin -password green but something was not right and later executions it would not accept this password. The above was installed as root. So now when I do the following: # or $ mysqld -p It asks for a password and I can't get it to work. To ensure the server is working if I do the following: $ps -aux | grep mysql It gives me: william 3083 0.0 0.4 1672 pts/1 S 23:24 0:00 grep mysql If anyone can help put order into my disorder over all this, it will be truly appreciated. First of all check that password for 'root' was really changed, because mysqladmin -password newpassword is not correct command to change password. How to change the password read here: http://www.mysql.com/doc/en/Passwords.html If the password was changed, you can reset it follow the instruction at: http://www.mysql.com/doc/en/Resetting_permissions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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 password confusion.
At the present time I am using Mandrake 9.0 and installed the MySql programmes that con the three disks: MySQL-3.23.52-1mdk.i586.rpm* MySQL-bench-3.23.52-1mdk.i586.rpm* MySQL-client-3.23.52-1mdk.i586.rpm* MySQL-Max-3.23.52-1mdk.i586.rpm #mysql_install_db has been run. The last time I did this it said to change the root password in the book I am using: Sams Teach Yourself MySQL in 21 Days with the following: #mysqladmin -password newpassword As the old password is supposed to be empty I used the following on the command line: #mysqladmin -password green but something was not right and later executions it would not accept this password. The above was installed as root. So now when I do the following: # or $ mysqld -p It asks for a password and I can't get it to work. To ensure the server is working if I do the following: $ps -aux | grep mysql It gives me: william 3083 0.0 0.4 1672 pts/1 S 23:24 0:00 grep mysql If anyone can help put order into my disorder over all this, it will be truly appreciated. Thank you, Bill. -- William Bradley http://www.catholicmissionleaflets.org - 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: Decrypt MYSQL Password
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ben, From the MySQL man online @ http://www.mysql.com/doc/en/Miscellaneous_functions.html#IDX1330 : PASSWORD() encryption is non-reversible. To create a forgot your password page, the best method is to generate a net password and send that new password. To make it easier to your users to remember their passwords, the best way is to set that password as a temporary one, that only allows them to set the original password. (maybe using a diferent field, so they can keep the original password if someone else goes to your site and request the password, just because he was bored. MPNeves On Wednesday 13 November 2002 07:27 am, Ben C. wrote: I am using the MySQL password() function for the my passwords on the user names. How do I decrypt the password in PHP to send it in an e-mail. I am making a forgot your password page and want to have the user enter their e-mail and have the password sent to them. Please help! - -- Merlin, the Mage themage.camelot.co.pt -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE90hleKOMrqDFTeBARAoc7AKDozVXEVP8Tfv8Qjx9DE4ChPF8zsACaAh/C efo5W0z4+dO3UEvTnDz9qJk= =i4Oj -END PGP SIGNATURE- - 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
AW: Decrypt MYSQL Password
Hi Ben, As far as I know the algorithm used for the decrypting is a one-way hash function, thus there is no way of decrypting it. You may consider to reset the password and mail the user the new one instead of mailing the old password. The second solution is to store the password a second time as clear-text at the user's property. Regards, Wolf -Originalnachricht- Von: Ben C. An: [EMAIL PROTECTED] Gesendet: 13.11.2002 08:27 Betreff: Decrypt MYSQL Password I am using the MySQL password() function for the my passwords on the user names. How do I decrypt the password in PHP to send it in an e-mail. I am making a forgot your password page and want to have the user enter their e-mail and have the password sent to them. Please help! -- The content of this email message and any attachments are confidential and may be legally privileged, intended solely for the addressee. If you are not the intended recipient, be advised that any use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you receive this message in error, please notify the sender immediately by reply email and destroy the message and its attachments. - 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: Decrypt MYSQL Password
Ben C. wrote: I am using the MySQL password() function for the my passwords on the user names. How do I decrypt the password in PHP to send it in an e-mail. I am Short answer: You don't. Long answer: search the archives for this mailing list; it was asked about a week ago and I gave a longer much more accurate answer then. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: Decrypt MYSQL Password
I am a little new to MySQL and PHP. How do I make the password a temporary password. So when they login the first time they need to reset the password? Thanks for you help in advance. Ben From: Merlin, The Mage [EMAIL PROTECTED] Date: 2002/11/13 Wed AM 04:20:20 EST To: Ben C. [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Decrypt MYSQL Password -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ben, From the MySQL man online @ http://www.mysql.com/doc/en/Miscellaneous_functions.html#IDX1330 : PASSWORD() encryption is non-reversible. To create a forgot your password page, the best method is to generate a net password and send that new password. To make it easier to your users to remember their passwords, the best way is to set that password as a temporary one, that only allows them to set the original password. (maybe using a diferent field, so they can keep the original password if someone else goes to your site and request the password, just because he was bored. MPNeves On Wednesday 13 November 2002 07:27 am, Ben C. wrote: I am using the MySQL password() function for the my passwords on the user names. How do I decrypt the password in PHP to send it in an e-mail. I am making a forgot your password page and want to have the user enter their e-mail and have the password sent to them. Please help! - -- Merlin, the Mage themage.camelot.co.pt -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE90hleKOMrqDFTeBARAoc7AKDozVXEVP8Tfv8Qjx9DE4ChPF8zsACaAh/C efo5W0z4+dO3UEvTnDz9qJk= =i4Oj -END PGP SIGNATURE- - 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: Decrypt MYSQL Password
At 23:27 -0800 11/12/02, Ben C. wrote: I am using the MySQL password() function for the my passwords on the user names. How do I decrypt the password in PHP to send it in an e-mail. I am making a forgot your password page and want to have the user enter their e-mail and have the password sent to them. Please help! It's always a good idea to read the manual before assuming that a function behaves in a certain way. In this case, what you ask is impossible. The manual makes it clear that PASSWORD() encryption is non-reversable: http://www.mysql.com/doc/en/Miscellaneous_functions.html Alternatives: ENCODE()/DECODE() AES_ENCRYPT()/AES_DECRYPT() DES_ENCRYPT()/DES_DECRYPT() - 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
AW: Decrypt MYSQL Password
Ben, create a column in the user table, that holds a flag called mustChangePassword (or whatever you want to name it). Then write your PHP code that way, that a login of a user who must change his password will be redirected to the change password page and store the new password and reset the flag to false. Regards Hans -Ursprüngliche Nachricht- Von: Ben C. [mailto:benc;cox.net] Gesendet: Mittwoch, 13. November 2002 18:27 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Betreff: Re: Decrypt MYSQL Password I am a little new to MySQL and PHP. How do I make the password a temporary password. So when they login the first time they need to reset the password? Thanks for you help in advance. Ben From: Merlin, The Mage [EMAIL PROTECTED] Date: 2002/11/13 Wed AM 04:20:20 EST To: Ben C. [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Decrypt MYSQL Password -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ben, From the MySQL man online @ http://www.mysql.com/doc/en/Miscellaneous_functions.html#IDX1330 : PASSWORD() encryption is non-reversible. To create a forgot your password page, the best method is to generate a net password and send that new password. To make it easier to your users to remember their passwords, the best way is to set that password as a temporary one, that only allows them to set the original password. (maybe using a diferent field, so they can keep the original password if someone else goes to your site and request the password, just because he was bored. MPNeves On Wednesday 13 November 2002 07:27 am, Ben C. wrote: I am using the MySQL password() function for the my passwords on the user names. How do I decrypt the password in PHP to send it in an e-mail. I am making a forgot your password page and want to have the user enter their e-mail and have the password sent to them. Please help! - -- Merlin, the Mage themage.camelot.co.pt -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE90hleKOMrqDFTeBARAoc7AKDozVXEVP8Tfv8Qjx9DE4ChPF8zsACaAh/C efo5W0z4+dO3UEvTnDz9qJk= =i4Oj -END PGP SIGNATURE- - 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: Decrypt MYSQL Password
Hi, You can make your own authentification system.A table which can have a binary char/varchar field for encrypted password(effect similar like password from mysql.user) and another char for ASCII password. If you not use grant statement for adding new user, you can use the MySQL authentification system and you can make relation between this table and mysql.user using encrypted password like foreign key. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Merlin, The Mage [EMAIL PROTECTED] To: Ben C. [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 7:53 PM Subject: Re: Decrypt MYSQL Password Well, my ideia was to have two diferent fields, the first one to the real password, and the second to the tmp passwd. When the user logs normally, the tmppasswd is set to null, and when the user request a new passwd, this field is set to the temporary password. This will sent an email to the user with a link that allow the user to type the temporary passwd and if correct, set the real one. mpneves On Wednesday 13 November 2002 05:26 pm, Ben C. wrote: I am a little new to MySQL and PHP. How do I make the password a temporary password. So when they login the first time they need to reset the password? Thanks for you help in advance. Ben From: Merlin, The Mage [EMAIL PROTECTED] Date: 2002/11/13 Wed AM 04:20:20 EST To: Ben C. [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Decrypt MYSQL Password -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Ben, From the MySQL man online @ http://www.mysql.com/doc/en/Miscellaneous_functions.html#IDX1330 : PASSWORD() encryption is non-reversible. To create a forgot your password page, the best method is to generate a net password and send that new password. To make it easier to your users to remember their passwords, the best way is to set that password as a temporary one, that only allows them to set the original password. (maybe using a diferent field, so they can keep the original password if someone else goes to your site and request the password, just because he was bored. MPNeves On Wednesday 13 November 2002 07:27 am, Ben C. wrote: I am using the MySQL password() function for the my passwords on the user names. How do I decrypt the password in PHP to send it in an e-mail. I am making a forgot your password page and want to have the user enter their e-mail and have the password sent to them. Please help! - -- Merlin, the Mage themage.camelot.co.pt -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE90hleKOMrqDFTeBARAoc7AKDozVXEVP8Tfv8Qjx9DE4ChPF8zsACaAh/C efo5W0z4+dO3UEvTnDz9qJk= =i4Oj -END PGP SIGNATURE- -- Merlin, the Mage themage.camelot.co.pt - 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
Decrypt MYSQL Password
I am using the MySQL password() function for the my passwords on the user names. How do I decrypt the password in PHP to send it in an e-mail. I am making a forgot your password page and want to have the user enter their e-mail and have the password sent to them. Please help! -- The content of this email message and any attachments are confidential and may be legally privileged, intended solely for the addressee. If you are not the intended recipient, be advised that any use, dissemination, distribution, or copying of this e-mail is strictly prohibited. If you receive this message in error, please notify the sender immediately by reply email and destroy the message and its attachments. - 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 password ( )
I have used the mysql password(\$pass \) function in the past to encrypt passwords into the db. but can not decrypt them if needed. I know this is not something new. Is there a better way to protect passwords in the db and then decrypt them if needed ? Thanks Mark - 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: mysql password ( )
I dont know if it helps, but I dont decrypt, instead, I compare the crypted value on the DB against the output of the function PASSWORD() filled with the pwd I get from the user... It works for me (and I'm using APACHE and MySQL all in plain ANSI C). Leonardo Javier Belén. AFIP-AR - Original Message - From: Mark Stringham [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 28, 2002 1:47 PM Subject: mysql password ( ) I have used the mysql password(\$pass \) function in the past to encrypt passwords into the db. but can not decrypt them if needed. I know this is not something new. Is there a better way to protect passwords in the db and then decrypt them if needed ? Thanks Mark - 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: mysql password ( )
Hi, The password() function is a one way encoder. In other words it just generates some kind of checksum of the input parameter. So you cannot decrypt them, but it is much safer than encrypting and decrypting strings, because even the attacker cannot decrypt them. :-) You can use it this way for example: Let's say my password is: abcdef Password('abcdef') - 0bc7a0b7062090d5 (You must store this checksum in the database.) When you want to check if the password entered by the user is correct, you need to do this: The password entered by the user: abcdeg You call the password function: Password('abcdeg') - 0bc7a2b806208ed6 Compare the stored checksum and this one: NOT EQUAL - entered password is bad Notice that if there is only a small difference between the right and the entered words the checksum will be different in many aspects. That's why it is quite safe. But you can get better protecting if you use the MD5 function. It works the same way than the password function, but generates 32 character long checksum instead of 16. At 10:47 2002.08.28._ -0600, you wrote: I have used the mysql password(\$pass \) function in the past to encrypt passwords into the db. but can not decrypt them if needed. I know this is not something new. Is there a better way to protect passwords in the db and then decrypt them if needed ? Thanks Mark - 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: mysql password ( )
so md5 would be the securest way to handle password security for a website? Randy - Original Message - From: Daniel Kiss [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 12:19 AM Subject: Re: mysql password ( ) Hi, The password() function is a one way encoder. In other words it just generates some kind of checksum of the input parameter. So you cannot decrypt them, but it is much safer than encrypting and decrypting strings, because even the attacker cannot decrypt them. :-) You can use it this way for example: Let's say my password is: abcdef Password('abcdef') - 0bc7a0b7062090d5 (You must store this checksum in the database.) When you want to check if the password entered by the user is correct, you need to do this: The password entered by the user: abcdeg You call the password function: Password('abcdeg') - 0bc7a2b806208ed6 Compare the stored checksum and this one: NOT EQUAL - entered password is bad Notice that if there is only a small difference between the right and the entered words the checksum will be different in many aspects. That's why it is quite safe. But you can get better protecting if you use the MD5 function. It works the same way than the password function, but generates 32 character long checksum instead of 16. At 10:47 2002.08.28._ -0600, you wrote: I have used the mysql password(\$pass \) function in the past to encrypt passwords into the db. but can not decrypt them if needed. I know this is not something new. Is there a better way to protect passwords in the db and then decrypt them if needed ? Thanks Mark - 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
Re: mysql password ( )
Securest? Yes, maybe. But first of all the security of a web site does not depend on the password encoding system (PASSWORD or MD5) you use in the MySQL database. (I mean firewalls, good OS, so on.) At 00:32 2002.08.29. -0400, you wrote: so md5 would be the securest way to handle password security for a website? Randy - Original Message - From: Daniel Kiss [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 29, 2002 12:19 AM Subject: Re: mysql password ( ) Hi, The password() function is a one way encoder. In other words it just generates some kind of checksum of the input parameter. So you cannot decrypt them, but it is much safer than encrypting and decrypting strings, because even the attacker cannot decrypt them. :-) You can use it this way for example: Let's say my password is: abcdef Password('abcdef') - 0bc7a0b7062090d5 (You must store this checksum in the database.) When you want to check if the password entered by the user is correct, you need to do this: The password entered by the user: abcdeg You call the password function: Password('abcdeg') - 0bc7a2b806208ed6 Compare the stored checksum and this one: NOT EQUAL - entered password is bad Notice that if there is only a small difference between the right and the entered words the checksum will be different in many aspects. That's why it is quite safe. But you can get better protecting if you use the MD5 function. It works the same way than the password function, but generates 32 character long checksum instead of 16. At 10:47 2002.08.28._ -0600, you wrote: I have used the mysql password(\$pass \) function in the past to encrypt passwords into the db. but can not decrypt them if needed. I know this is not something new. Is there a better way to protect passwords in the db and then decrypt them if needed ? Thanks Mark - 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 - 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: mysql password file
Hi, If I understood your message right, the answer is no. The only place passwords are stored is the mysql database, so they're physically located in the mysql.MYD file. They're encrypted there, too. Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** On Sun, 11 Aug 2002, Dave Reinhardt wrote: is there a password file accessable from root for mysql? - 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
mysql password file
is there a password file accessable from root for mysql? - 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 password
Hi, I have a table with username and password. The password is encrypted using mySQL's password function. But when I try to perform a match using PHP, e.g., $query = select count(*) from auth where usrname='$logname' and usrpass=password('$logpass'); $result = mysql_query($query) or exit (Cannot run query.); $count = mysql_result($result, 0, 0); if ($count 0) { echo Success; die(); } else { echo Unsuccess; die(); } I always get Unsuccess. It seems password() does not give the same result. Would someone please point out what I am doing wrong here? Regards, Norman - 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 PASSWORD function
Hi all, I can't find a description of the algorithm used in the mySQL PASSWROD function. I understand it's a hashing algorithm of some kind, but I don't know which algorithm (and I suspect it's *not* MD5.) Can anyone tell me what algorithm PASSWORD uses? The reason I ask is that we're trying to implement role-based security using our existing MySQL table of users, accessed via Java Servlet auth functions, which can read the User table through JDBC. BUT they don't know anything about PASSWORD-encrypted passwords, so I need to write something that hashes the password entered in the same way MySQL hashes a password (or abandon the use of servlet auth :-) Any clues? John Kemp, Director, Software Development Streetmail Inc. http://www.streetmail.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: MySQL PASSWORD function
In the last episode (Jan 29), John Kemp said: Hi all, I can't find a description of the algorithm used in the mySQL PASSWROD function. I understand it's a hashing algorithm of some kind, but I don't know which algorithm (and I suspect it's *not* MD5.) The algorithm is in the sql/password.c file. Can anyone tell me what algorithm PASSWORD uses? The reason I ask is that we're trying to implement role-based security using our existing MySQL table of users, accessed via Java Servlet auth functions, which can read the User table through JDBC. BUT they don't know anything about PASSWORD-encrypted passwords, so I need to write something that hashes the password entered in the same way MySQL hashes a password (or abandon the use of servlet auth :-) Just have mysql do it: select (PASSWORD('thepassword') = password) from user where user='theuser'; will return 1 if 'theuser's password is 'thepassword', and 0 otherwise. -- Dan Nelson [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: MySQL PASSWORD function
John Kemp writes: Hi all, I can't find a description of the algorithm used in the mySQL PASSWROD function. I understand it's a hashing algorithm of some kind, but I don't know which algorithm (and I suspect it's *not* MD5.) Can anyone tell me what algorithm PASSWORD uses? The reason I ask is that we're trying to implement role-based security using our existing MySQL table of users, accessed via Java Servlet auth functions, which can read the User table through JDBC. BUT they don't know anything about PASSWORD-encrypted passwords, so I need to write something that hashes the password entered in the same way MySQL hashes a password (or abandon the use of servlet auth :-) Any clues? John Kemp, Director, Software Development Streetmail Inc. http://www.streetmail.com Hi! We use our own hash algorithm with usage of salt. Take a look at sql/password.c ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ 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: MySQL PASSWORD function
I think mysql uses the system crypt() function. This is, no-doubt, available through some well hidden Java class. Just do man crypt to learn about crypt(). Chris On Tue, 29 Jan 2002 10:59:55 -0500 John Kemp [EMAIL PROTECTED] wrote: Hi all, I can't find a description of the algorithm used in the mySQL PASSWROD function. I understand it's a hashing algorithm of some kind, but I don't know which algorithm (and I suspect it's *not* MD5.) Can anyone tell me what algorithm PASSWORD uses? The reason I ask is that we're trying to implement role-based security using our existing MySQL table of users, accessed via Java Servlet auth functions, which can read the User table through JDBC. BUT they don't know anything about PASSWORD-encrypted passwords, so I need to write something that hashes the password entered in the same way MySQL hashes a password (or abandon the use of servlet auth :-) Any clues? John Kemp, Director, Software Development Streetmail Inc. http://www.streetmail.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 -- Chris Wilson [EMAIL PROTECTED] http://www.wapmx.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: MySQL PASSWORD function
Hi all, I can't find a description of the algorithm used in the mySQL PASSWROD function. I understand it's a hashing algorithm of some kind, but I don't know which algorithm (and I suspect it's *not* MD5.) Can anyone tell me what algorithm PASSWORD uses? The reason I ask is that we're trying to implement role-based security using our existing MySQL table of users, accessed via Java Servlet auth functions, which can read the User table through JDBC. BUT they don't know anything about PASSWORD-encrypted passwords, so I need to write something that hashes the password entered in the same way MySQL hashes a password (or abandon the use of servlet auth :-) Any clues? How about using the PASSWORD function directly? SELECT PASSWORD('thepassword'), Password FROM user WHERE User='username'; -- if they match, the unencrypted password matches. Alternatively, SELECT PASSWORD('thepassword')=Password FROM user WHERE User='username'; will return 1 on a match, 0 on non-match (watch out for nonexisting usernames). / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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: Mysql password problem
Are you sure the password for root is christ1 ? Did you try it without the -p ? Kory Wheatley wrote: I have MYSQL installed on a hpux 11.0 unix system I installed the binary and everything started up correctly using /opt/mysql/bin/safe_mysqld but when I try to connect as an user /opt/mysql/bin/mysql -u root -pchrist1 It will not work . Even if I do the following command I get an error /opt/myql/bin/mysqladmin version I receive this error on everything I do error: 'Access denied for user: ' root@localhost:' (Using password =yes) Does any have a solution? -- # Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - 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 mysql-unsubscribe-##L=##[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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql password problem
I have MYSQL installed on a hpux 11.0 unix system I installed the binary and everything started up correctly using /opt/mysql/bin/safe_mysqld but when I try to connect as an user /opt/mysql/bin/mysql -u root -pchrist1 It will not work . Even if I do the following command I get an error /opt/myql/bin/mysqladmin version I receive this error on everything I do error: 'Access denied for user: ' root@localhost:' (Using password =yes) Does any have a solution? -- # Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - 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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql password
Some other details that might be of interest in this case: - it's not a good idea to type the password at the shell prompt (it's then in the command history) rather type mysqladmin -u USERNAME -p Mysql then asks you for a password with it's own prompt the same is for mysql client. - mysql client and myslqadmin returns an error when you try to log in as a user that has no password set but use the -p flag (maybe one would expect that it just lets you in without asking greets, henning - 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 password
Im attempting to install mysql. The service started and everything seems to be going ok except for that I can't set the root password for the mysql server. To reset password i type: /usr/bin/mysqladmin -u root -p mypassword Then I get the following error: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' Anyone, anyone? Bueller? Fry? JJ - 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: mysql password
try: mysqladmin -u root password new_password_here - Original Message - From: Jeremiah Jester [EMAIL PROTECTED] To: 'MySQL' [EMAIL PROTECTED] Sent: Tuesday, December 18, 2001 10:50 AM Subject: mysql password Im attempting to install mysql. The service started and everything seems to be going ok except for that I can't set the root password for the mysql server. To reset password i type: /usr/bin/mysqladmin -u root -p mypassword Then I get the following error: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' Anyone, anyone? Bueller? Fry? JJ - 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: mysql password
Hy, Am 18 Dec 2001 10:50:40 -0800 schrieb Jeremiah Jester: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' in the default installation at the first start there is no password set for the mysql root user. Note that the mysql root user isn't the same as the System root User! You can set Your initial Password with the mysqladmin program. greets, henning - 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: mysql password
Im attempting to install mysql. The service started and everything seems to be going ok except for that I can't set the root password for the mysql server. To reset password i type: /usr/bin/mysqladmin -u root -p mypassword Then I get the following error: /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' I wonder when the mysql team will get around to changing that message... - Don't use '-p'. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - 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
Fixed MYSQL password problem!
I fixed the problem I just posted with MySql new installs not seeing my passwords. I had simply forgotten to flush the permissions after I set the password. mysqladmin -u root flush-privileges Cheers, -Richard - 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: mysql password
victor writes: can mysql use the linux password /etc/passwd for the authentication No, and it'd be a _really_ bad thing to do anyway. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - 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 password
can mysql use the linux password /etc/passwd for the authentication - 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: mysql password
On Thu, Sep 20, 2001 at 10:21:07AM +0800, victor wrote: can mysql use the linux password /etc/passwd for the authentication No. Because it cannot guarantee that users are who they say they are. If you think of authorization and authentication as two separate problems, the reasons are a little more clear. And if you check the mailing list archives, you'll see that this comes up all the time. Really. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 14 days, processed 255,651,006 queries (210/sec. avg) - 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
Lost mySQL password on Cobalt Qube 3
Hello all, Recently I made an attempt at setting up phpMyAdmin to allow my colleagues to interface with mySQL easily. In doing so I set a password for the root user, and placed the settings in my config file. When a new version of phpMyAdmin was released, I upgraded without backing up my old configuration file. Now, I can't seem to remember my password. I have tried to shut down the mySQL server, and also tried to kill the process, but my server does not show mySQL running in the processes list. This is even when logged in as root. The only way I can connect to mySQL is using the command mysql -u -p, which allows me to connect, but not to manipulate anything or stop the service. If anyone has any ideas as to what I should do to recover my lost password, or reset it, please let me know. As some of you may know, cobalt servers are slightly different than regular unix servers, and their support is less than first class. Thanks again for your help. Thanks, Chris Lathem Network Administrator SkyHawke Technologies [EMAIL PROTECTED] 601.605.6100 Ext. 109 Fax: 601.605.9225
Re: Lost mySQL password on Cobalt Qube 3
Dear Chris, 1. Stop the MySQL server and restart mysqld with the --skip-grant-tables option. 2. Use the GRANT command to set up a new root user / superuser. 3. Stop the MySQL server and restart it. Manual pages: http://www.mysql.com/doc/R/e/Resetting_permissions.html and http://www.mysql.com/doc/G/R/GRANT.html Have fun! :-) Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Chris Lathem [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, August 15, 2001 9:21 PM Subject: Lost mySQL password on Cobalt Qube 3 Hello all, Recently I made an attempt at setting up phpMyAdmin to allow my colleagues to interface with mySQL easily. In doing so I set a password for the root user, and placed the settings in my config file. When a new version of phpMyAdmin was released, I upgraded without backing up my old configuration file. Now, I can't seem to remember my password. I have tried to shut down the mySQL server, and also tried to kill the process, but my server does not show mySQL running in the processes list. This is even when logged in as root. The only way I can connect to mySQL is using the command mysql -u -p, which allows me to connect, but not to manipulate anything or stop the service. If anyone has any ideas as to what I should do to recover my lost password, or reset it, please let me know. As some of you may know, cobalt servers are slightly different than regular unix servers, and their support is less than first class. Thanks again for your help. Thanks, Chris Lathem Network Administrator SkyHawke Technologies [EMAIL PROTECTED] 601.605.6100 Ext. 109 Fax: 601.605.9225 - 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: cannot set root mysql password
Date |Thu, 2 Aug 2001 20:20:51 -0700 From |[EMAIL PROTECTED] Hello! Description: E I cannot set the root password, or any password after installing from RPM. I have installed the following RPM packages: E MySQL-3.23.40-1.i386.rpm E MySQL-client-3.23.40-1.i386.rpm E MySQL-shared-3.23.40-1.i386.rpm How-To-Repeat: E this is where i am seeing the problem, immediately after a fresh RPM install. E [root@cadillac /root]# /usr/bin/mysqladmin -u root -p password 'new-password' E Enter password: E /usr/bin/mysqladmin: connect to server at 'localhost' failed E error: 'Access denied for user: 'root@localhost' (Using password: YES)' E [root@cadillac /root]# Fix: E i am _really_ new to mysql, and have no idea. any help would be greatly appreciated. thank you in advance. No. You need to remove -p from this command line. So /usr/bin/mysqladmin -u root password 'new-password' works like a dream -); ___ For technical support contracts, visit https://order.mysql.com/ This email is sponsored by SWSoft, http://www.asplinux.ru/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Grigory Bakunov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB / SWSoft /_/ /_/\_, /___/\___\_\___/ ___/ 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: cannot set root mysql password
Hello, On Fri, Aug 03, 2001 at 10:48:55AM +0500, Grigory Bakunov wrote: No. You need to remove -p from this command line. So /usr/bin/mysqladmin -u root password 'new-password' works like a dream -); So, this must be corrected on the install script ($bindir/mysql_install_db): - echo PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! echo This is done with: echo $bindir/mysqladmin -u root -p password 'new-password' echo $bindir/mysqladmin -u root -h $hostname -p password 'new-password' echo See the manual for more instructions. - Hugo - 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: installing mysql(password??)
On Sun, 27 May 2001, David Loszewski wrote: when you first install mysql server does it assign a default password becuase it tells me to enter these in to make a password for my server, but I don't know what the heck to do with them, but when I try them it says access denied /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h Precious -p password 'new-password' Dave Bonjour, You can set a root-password starting the server with safe_mysqld --skip-grant-tables then connect to mysql:mysql -u root then: mysql update user set password=password(the-password-I-want) where user = 'root'; You use the password() function to set a new password. -- jean-michel - 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
installing mysql(password??)
when you first install mysql server does it assign a default password becuase it tells me to enter these in to make a password for my server, but I don't know what the heck to do with them, but when I try them it says access denied /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h Precious -p password 'new-password' Dave - 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: installing mysql(password??)
Go to http://www.mysql.com/doc/C/o/Connecting.html and also read through http://www.fsai.fh-trier.de/system/doku/MySQL/manual_Privilege_system.html#C onnecting In the Linux source download there is also a script to reset the user and password, which was root and no password. Hope it helps ;-) -Original Message- From: David Loszewski [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 26, 2001 11:24 PM To: [EMAIL PROTECTED] Subject: installing mysql(password??) when you first install mysql server does it assign a default password becuase it tells me to enter these in to make a password for my server, but I don't know what the heck to do with them, but when I try them it says access denied /usr/bin/mysqladmin -u root -p password 'new-password' /usr/bin/mysqladmin -u root -h Precious -p password 'new-password' Dave - 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