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.
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.