configuring LAMP in RHEL 5.4

[aaaaaarko]

I have installed mysql-5.0.45-7.el5(yum installed mysql*) and php-5.1.6-23.el5(yum install php*) along with apache for an application software(case filling software ware cases are being filled) .first time when the main page opened i logged into the software with username and password.But now it is showing Access denied for user 'apache'@'localhost' (using password: NO).I have used this command (mysqladmin -u root password redhat).but now when i am going to use this command it is showing [root@localhost ~]# mysqladmin -u root password redhat
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
though mysql -u root -p this command is working. please help.

[chrisstevens]

From memory it may be worth trying the following:

mysqladmin -u root -p redhat

or

mysqladmin -u root password
(It may then prompt you for the password)