Missing mysql database

Discussion in 'Server Operation' started by newbie14, Jan 21, 2011.

  1. newbie14

    newbie14 New Member

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

    falko Super Moderator ISPConfig Developer

    Please run
    Code:
    mysql_secure_installation
    to set a root password and then log into MySQL again.
     
  3. newbie14

    newbie14 New Member

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

    falko Super Moderator ISPConfig Developer

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

    newbie14 New Member

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

Share This Page