I am building a VPS node that is running Ubuntu 10.10LTS, Apache2, Mysql 5.1 and php5.
I could not log in to my website admin through the browser, even though I am using the correct login details. So I logged in from the command line to check the results.
When I run this query I get expected results:
mysql> select * from users;
+----+----------+-----------------------+----------+
| id | username | email | password |
+----+----------+-----------------------+----------+
| 1 | myUserName |
[email protected] | myPassword |
+----+----------+-----------------------+----------+
And the same goes for this query:
mysql> select * from users where id = 1;
+----+----------+-----------------------+----------+
| id | username | email | password |
+----+----------+-----------------------+----------+
| 1 | myUserName |
[email protected] | myPassword |
+----+----------+-----------------------+----------+
1 row in set (0.00 sec)
But when I run this query I get this 'unexpected response':
mysql> select * from users where username = 'myUserName' and password = 'myPassword';
Empty set (0.00 sec)
I am not sure why this is happening.
Any help would be greatly appreciated.
BTW.. I will be encrypting the user details but for now I just want to get it set up.
Please help,
Thanks