Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

Thanks

share|improve this question

2 Answers 2

up vote 4 down vote accepted

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.

share|improve this answer
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. –  andufo 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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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