Missing mysql database

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.

 

Please run

Code:

mysql_secure_installation

to set a root password and then log into MySQL again.

 

Dear Falko,
Is it that I must run usr/bin/mysql_secure_installation? I have run that is have setup properly now. I would like to ask actually by defauly does centos 5.5 comes with the mysql db or we have to install it? How to upgrade it to new version? Thank you.

 

It's the easiest way to set the MySQL password.

That depends on if you selected MySQL during the initial system setup. But it doesn't make a difference if you install it later on with yum.

You can do this with yum:

Code:

yum install mysql mysql-server

If there's a new version, it will be installed, otherwise no change will happen.

 

Dear Falko,
Thank you for your guidance will follow it accordingly.