Can’t login to mysql using web base apps

I experienced some weird things on MySQL. This was not only once but every time, i installed a new instance of MySQL Server.

The system i’m porting to the database can’t able to connect to the MySQL Server. So I tried some series of test to trouble shoot the problem.

First, i created a simple scripts that log-in to mySQL
Second, i Create a query to execute and display the table contents.

Boom!!!!
At my first step, i find out that i cant login to the database. So i used my friend google to find out whats is the prblem. And i came up to this site ‘http://dev.mysql.com/doc/refman/4.1/en/old-client.html’.

This is the simple solution:

1. Go to: MySQL Commandline Client
2. Login using your root password
3. mysql> set password for ‘root’@'localhost’ = OLD_PASSWORD(‘newpassword’);
4. If successful,
Query OK, 0 rows affected (0.00 sec)
mysql>
5. If not, try again