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

RE: MySQL password issue

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

Re: MySQL password issue

: 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

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

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

Fwd: ODBC MySQL Password as plain text

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

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 ?

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

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

RE: Newbie question: how to change the mysql password

: 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

Re: MySQL Password

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

Re: MySQL Password

://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

Re: MySQL Password

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

Re: MySQL Password

://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

Re: MySQL Password

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

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?

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

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

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 ?

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

Re: MySQL Password

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

Re: MySQL Password

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

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

Re: Decrypt MYSQL Password

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

AW: Decrypt MYSQL Password

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

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

Re: Decrypt MYSQL Password

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

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

AW: Decrypt MYSQL Password

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

Re: Decrypt MYSQL Password

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

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

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

Re: mysql password ( )

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

Re: mysql password ( )

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

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

Re: mysql 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:

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

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

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

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

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

Re: Lost mySQL password on Cobalt Qube 3

[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

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

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

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

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'

RE: installing mysql(password??)

;-) -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