Missing mysql database

[newbie14]

Dear All,
I have new centos 5.5 machine then I yum install mysql mysql-server. Then I run mysql -u root. So I tried show databases just shows me one database that is information schema. So I can not change my root password. How go to about it? Thank you.

[indiver]

Can you post the exact error message while changing the root password!. Also try to install mysql by using yum install mysql* which will install complete mysql packages.


Alternatively after installing complete mysql packages and entering in to mysql terminal type the following command

grant all privileges on *.* to 'root'@'%' identified by 'whatever password you like' with grant option;

[newbie14]

Dear Indiver,
I have solved the problem by running this command usr/bin/mysql_secure_installation.