encrypt -> password

2008-01-20 Thread Luca Ferrari
Hi all, I've got an account table with password encrypted thru the encrypt() function, and I should transfer them to a table with password() function. I don't want to decrypt the password, and I'd like to know if there's a way to build the password hash from the encrypt one. Any suggestion? Th

Re: Who know this strange problem

2008-01-20 Thread Moon's Father
This is correct.Thank you very much. But I also why I wrote is wrong on linux and right on windows. You can tell me answer if you have time.thanks. On Jan 19, 2008 12:47 AM, Baron Schwartz <[EMAIL PROTECTED]> wrote: > Hi, > > On Jan 18, 2008 3:50 AM, Moon's Father <[EMAIL PROTECTED]> wrote: > > M

Re: Is there any determined date for mysql 6 release?

2008-01-20 Thread Sebastian Mendel
legolas schrieb: Hi Thank you for reading my post Is there any scheduled date mysql 6 release? don't know I heard that it is based on falcon and can perform better... "based on" in the wrong term, MyISAM will still be the default storage engine, it just adds Falcon as a new storage engine

Re: Handling Special Characters

2008-01-20 Thread Sebastian Mendel
Jerry Schwartz schrieb: I am having trouble inserting special characters into a table. I am using the MySQL client. I put the following commands into a text file (I'm on WinXP, using Notepad), copy them, and paste them into the MySQL command line client. SET NAMES utf8; CREATE TEMPORARY TABLE `

Re: Where can I get mysql.so?

2008-01-20 Thread Daniel Kasak
On Sat, 2008-01-19 at 19:02 +, Apple wrote: > Fatal error: Call to undefined function mysql_connect() in > /home/re/script.php on line 3 > > > I've googled and found out that I need to add extension=mysql.so > in CLI's php.ini file (separate php.ini file that works for CLI only). > >

Re: select from otherdb.table question?

2008-01-20 Thread Alex K
Hi Brent, ahh of course :) thank you so much for answering though. Alex On 20/01/2008, Brent Baisley <[EMAIL PROTECTED]> wrote: > When you establish a connection, it's a connection to a server, not a > specific DB. You can set a default db so that you don't always have > to specify the db name y

Re: select from otherdb.table question?

2008-01-20 Thread Brent Baisley
When you establish a connection, it's a connection to a server, not a specific DB. You can set a default db so that you don't always have to specify the db name you are working with. So to answer your question, no, a new connection is not established. Brent On Jan 19, 2008, at 10:19 AM, A