i recently registered for a rackspace cloud hosting account. Everything is running fine already, but i still have to set up the database system.

I've already done this

  1. yum install php-mysql mysql mysql-server
  2. /sbin/chkconfig --levels 235 mysqld on
  3. /etc/init.d/mysqld start

Im having trouble with the next steps:

  • how can i create databases?
  • is there a phpmyadmin package that i can install via console?

Also, am I using the correct levels for the chkconfig?



Make sure to run mysql_secure_installation. You can type mysql -u root Then type your usual mysql commands making sure to end with a semicolon.

create database employees;

As for phpmyadmin I am guessing you can just download it copy it to your webroot and run tar -xvf on it and then access it from your browser after restarting your web daemon since it is purely PHP driven. A package would be a little overkill for such a process.

  • 1
    Kudos on recommending mysql_secure_installation. I do not see that often enough in documentation. – maristgeek Nov 17 '10 at 20:40
  • 1
    thanks! the mysql_secure_installation tip was very helpful. – Andres SK Nov 17 '10 at 23:15

Here is a link on installing phpmyadmin for CentOS.

Here is another link on creating new databases from Mysql reference manual.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.