CODEWITHSUNDEEP
mysql
dapperwaterbuffalo
dapperwaterbuffalo

Reputation: 2748

PASSWORD() function no longer working after server move

I have moved my website and MySQL database to a new, free server at webhost.com, running MySQL 5.0.91-community.

Already, I have noticed that the MySQL server "does not like" the following query:

SELECT * FROM users_tb WHERE user_name='student' and user_pass=PASSWORD("password_here").

I have tried it in PhpMyAdmin, where no results are returned. If I leave out the password clause and just search by username, it works.

This code worked on the previous server. What has changed?

Upvotes: 0

Views: 161

Answers (1)

Chris Eberle
Chris Eberle

Reputation: 48785

PASSWORD behaves differently depending on (1) the version of MySQL, and (2) whether or not the admin has activated old-passwords in my.ini.

Upvotes: 2

Related Questions