Re: MySQL password issue

2012-10-25 Thread Tim Thorburn
riginal 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

RE: MySQL password issue

2012-10-24 Thread Nitin Mehta
7;, 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 inte

MySQL password issue

2012-10-24 Thread Tim Thorburn
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

Re: Fwd: ODBC MySQL Password as plain text

2009-11-20 Thread Tompkins Neil
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

Re: Fwd: ODBC MySQL Password as plain text

2009-11-20 Thread Tompkins Neil
I wondered if anyone else had any thoughts on this issue ? Cheers Neil On Thu, Nov 19, 2009 at 12:40 PM, Jay Ess 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,

Re: Fwd: ODBC MySQL Password as plain text

2009-11-19 Thread Tompkins Neil
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

Re: Fwd: ODBC MySQL Password as plain text

2009-11-19 Thread Jay Ess
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 ? Sec

Fwd: ODBC MySQL Password as plain text

2009-11-19 Thread Tompkins Neil
Neil -- Forwarded message -- From: Tompkins Neil Date: Wed, Nov 18, 2009 at 5:59 PM Subject: ODBC MySQL Password as plain text To: "[MySQL]" 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

ODBC MySQL Password as plain text

2009-11-18 Thread Tompkins Neil
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: Newbie question: how to change the mysql password

2003-12-20 Thread Chris
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 ti

Newbie question: how to change the mysql password

2003-12-20 Thread James Marcinek
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 Lis

Re: MySQL Password

2003-07-02 Thread Nils Valentin
Hi Victoria, 2003年 7月 2日 水曜日 22:05、Victoria 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. > > ...

Re: MySQL Password

2003-07-02 Thread Victoria 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

Re: MySQL Password

2003-07-02 Thread Nils Valentin
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 o

Re: MySQL Password

2003-07-02 Thread Victoria 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. >

Re: MySQL Password

2003-07-02 Thread Nils Valentin
hen mail i'll work > > > > >out a bit and reply. > > > > > > > > > >---- > > > > > -- harsh > > > > >http://www.cse.iitb.ac.in/~harsh > > >

Re: MySQL Password

2003-07-02 Thread harsh
> > > >-- harsh > > > >http://www.cse.iitb.ac.in/~harsh > > > > > > > >-- > > > > > > > >On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: > > >

Re: MySQL Password

2003-07-02 Thread Nils Valentin
-- > > > > > >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 retriev

Re: MySQL Password

2003-07-02 Thread harsh
--- > >harsh > >http://www.cse.iitb.ac.in/~harsh > >-- > > > >On Wed, 2 Jul 2003, Deependra b. Tandukar wrote: > > > > > Thank

Re: MySQL Password

2003-07-01 Thread harsh
ed, 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: > > >Yo

Re: MySQL Password

2003-07-01 Thread Nils Valentin
- >--- 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

Re: MySQL Password

2003-07-01 Thread 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 Password

2003-07-01 Thread Deependra b. Tandukar
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 confusion.

2002-12-25 Thread Egor Egorov
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

MySQL password confusion.

2002-12-21 Thread William Bradley
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 i

Re: Decrypt MYSQL Password

2002-11-13 Thread Gelu Gogancea
[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

AW: Decrypt MYSQL Password

2002-11-13 Thread hans huber
w 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

Re: Decrypt MYSQL Password

2002-11-13 Thread Paul DuBois
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

Re: Decrypt MYSQL Password

2002-11-13 Thread Ben C .
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/e

Re: Decrypt MYSQL Password

2002-11-13 Thread Michael T. Babcock
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 g

AW: Decrypt MYSQL Password

2002-11-13 Thread Moestl, Wolfgang
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 passwo

Re: Decrypt MYSQL Password

2002-11-13 Thread Merlin, The Mage
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 fo

Decrypt MYSQL Password

2002-11-12 Thread Ben C.
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

Re: mysql password ( )

2002-08-28 Thread Daniel Kiss
ord 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, > > > &g

Re: mysql password ( )

2002-08-28 Thread Randy Johnson
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, > > Th

Re: mysql password ( )

2002-08-28 Thread Daniel Kiss
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(\&

Re: mysql password ( )

2002-08-28 Thread Leonardo Javier Belén
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 > passw

mysql password ( )

2002-08-28 Thread Mark Stringham
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 ? Th

Re: mysql password file

2002-08-11 Thread Iikka Meriläinen
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

mysql password file

2002-08-11 Thread Dave Reinhardt
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

2002-03-26 Thread Norman Zhang
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 ("C

RE: MySQL PASSWORD function

2002-01-29 Thread Carsten H. Pedersen
> 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 > th

Re: MySQL PASSWORD function

2002-01-29 Thread Chris Wilson
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

Re: MySQL PASSWORD function

2002-01-29 Thread Sinisa Milivojevic
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 rea

Re: MySQL PASSWORD function

2002-01-29 Thread Dan Nelson
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/pass

MySQL PASSWORD function

2002-01-29 Thread John Kemp
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 problem

2002-01-11 Thread Gerald Clark
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/m

Mysql password problem

2002-01-10 Thread Kory Wheatley
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/my

Re: mysql password

2001-12-19 Thread Henning Sprang
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

RE: mysql password

2001-12-18 Thread Carsten H. Pedersen
> 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/mysq

Re: mysql password

2001-12-18 Thread Henning Sprang
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. Not

Re: mysql password

2001-12-18 Thread David M. Peak
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 inst

mysql password

2001-12-18 Thread Jeremiah Jester
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

Fixed MYSQL password problem!

2001-12-04 Thread Richard S. Huntrods
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

2001-09-19 Thread Carl Troein
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

Re: mysql password

2001-09-19 Thread Jeremy Zawodny
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 littl

mysql password

2001-09-19 Thread victor
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

Re: Lost mySQL password on Cobalt Qube 3

2001-08-15 Thread Stefan Hinz
athem" <[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 pass

Lost mySQL password on Cobalt Qube 3

2001-08-15 Thread Chris Lathem
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 co

Re: cannot set root mysql password

2001-08-03 Thread Hugo Koji Kobayashi
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): - e

Re: cannot set root mysql password

2001-08-03 Thread Grigory Bakunov
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-

Re: installing mysql(password??)

2001-05-27 Thread oltra jean-michel
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 > > /u

RE: installing mysql(password??)

2001-05-26 Thread Mike
;-) -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

installing mysql(password??)

2001-05-26 Thread David Loszewski
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/bi