once you follow the above procedure , as @mikehomee said u will be stuck on 'apache'@'localhost' error.For that we need to install mysql-server (yum -y install mysql-server) .if already installed then remove (yum -y remove mysql-server) and reinstall .configure mysql installatioin (mysql_secure_installaton).then you will be able to successfully login .Be Careful while creating a user in database because it is case sensitive,password must be given carefully eg. password123#.