[PHP] Re: SQL Password() function

[Gustavo Narea]

Hi.

Yaswanth Narvaneni wrote:

Hi!

Is there a function (or a code snippet) in PHP for mysql password() function?

I 'dont' want to use something like select * from table where
table.passwd=password($passwd);

Is there any other alternate way to do it?


Try this:



You don't need a MySQL connection.

Happy weekend.

--
Gustavo Narea.
PHP Documentation - Spanish Translation Team.
Valencia, Venezuela.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: sql password

[Mike Eheler]

yeah

if you just installed, root doesn't have a password.. so you need to not 
specify -p (this tells the server to try and authenticate with an empty 
password, as opposed to attempting to authenticate with no password.. 
there is a difference):

mysqladmin -u root password mypassword

Mike

Jeremiah Jester wrote:

> 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 at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: YES)'
> 
> Can anyone help?
> Thanks,
> JJ
> 
> 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]