Re: Password storage

2007-08-19 Thread David T. Ashley
On 8/18/07, C K <[EMAIL PROTECTED]> wrote: > Friends, > I have one question - How to store passwords in MySQL database table in a > secure way so that no one can see the password(understand the password > string)? It is considered bad security practice to store passwords using reversible encrypt

Re: Query cache problem with stored procedures

2007-08-19 Thread Baron Schwartz
Hi, Your questions are answered in the manual: http://dev.mysql.com/doc/refman/5.0/en/query-cache-how.html It is a known limitation. Edoardo Serra wrote: Hi all, I'm benchmarking performance improvement with MySQL Query Cache turned on but I'm facing some problem with queries inside store

Query cache problem with stored procedures

2007-08-19 Thread Edoardo Serra
Hi all, I'm benchmarking performance improvement with MySQL Query Cache turned on but I'm facing some problem with queries inside stored procedures when they contains variable parameters I just created this stored procedure to identify the problem CREATE PROCEDURE `proc_test_qcache`(IN mailb