Re: Finally Working...wow

2006-05-26 Thread Rich 
Never mind.  This actually posted to the wrong list.  I don't know  
how that happened.  Must have been cause I was tired.  Sorry about that.



On May 24, 2006, at 9:19 PM, sheeri kritzer wrote:


Rich

for what?  is

SELECT host,user,password FROM mysql.user;

showing you cleartext passwords?  It shouldn't.




Rich Fortnum
[EMAIL PROTECTED]
Toronto





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Finally Working...wow

2006-05-24 Thread sheeri kritzer 

Rich

for what?  is

SELECT host,user,password FROM mysql.user;

showing you cleartext passwords?  It shouldn't.

-Sheeri

On 5/23/06, Rich <[EMAIL PROTECTED]> wrote:

Hi folks.  Me again.

I finally got this all up and running under crypt of 'cleartext'.
So, even though I am going to be on the same box as the server, how
do I set up an MD5 or password entry?

MYSQLCrypt  password()
MYSQLCrypt  password

MYSQLCrypt  MD5()
MYSQLCrypt  MD5

I'm not sure if the brackets are needed or not.

So if I use password or MD5 encryption in the tables, the value in
the field is encrypted.  How does this change how I structure things?

instead of 'passwordalpha' in the password field, I have to enter
'ff08d88bab6edcf9d730a96418c05358'?  I am entering users via my own
interface, and I can't seem to get MD5 working with either MD5 or MD5().

Cheers

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

Finally Working...wow

2006-05-23 Thread Rich 

Hi folks.  Me again.

I finally got this all up and running under crypt of 'cleartext'.   
So, even though I am going to be on the same box as the server, how  
do I set up an MD5 or password entry?


MYSQLCrypt  password()
MYSQLCrypt  password

MYSQLCrypt  MD5()
MYSQLCrypt  MD5

I'm not sure if the brackets are needed or not.

So if I use password or MD5 encryption in the tables, the value in  
the field is encrypted.  How does this change how I structure things?


instead of 'passwordalpha' in the password field, I have to enter  
'ff08d88bab6edcf9d730a96418c05358'?  I am entering users via my own  
interface, and I can't seem to get MD5 working with either MD5 or MD5().


Cheers

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]