Configuring MySQL

Most of your interaction with MySQL will be during the configuration and development of your Drupal Web site. This section verifies that your MySQL installation is correct and the database server is running.

Let's test that the server is working by connecting to the database named mysql using:

C:\Documents and Settings\Administrator> mysql -u root -p mysql

You will be prompted to enter your password. You'll then see the prompt, similar to Listing 2 on your screen.

                    
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 28 to server version: 4.0.26-log                

Type 'help;' or  '\h' for help. Type '\c' to clear the buffer.               

mysql>

If you see the preceding message, your MySQL server is running and correctly configured.

We are now going to create the Drupal database, drupal_db, and the user, drupal_user, that will own the database. Enter the MySQL commands shown in Listing 3 at the prompt (where password is the password for the drupal_user user).

                    
  mysql> create database drupal_db;
  mysql> grant select, insert, update, delete, create, drop, index, alter, 
         create temporary tables, lock tables 
         on drupal_db.* to 'drupal_user'@'localhost' identified by 'password';
  mysql> flush privileges;
  mysql> quit

You can also use the grant privileges in Listing 4.

                    
  mysql> grant all privileges on drupal_db.* 'drupal_user'@'localhost'     
         identified by 'password';

This is correct, but not as secure as the more verbose version in Listing 3. You do not want to use it on your production server. We will use the same command in development as in production to practice good security.

Now that MySQL is working, we can install and configure Drupal. Keep your command window open, because we will need it while we install Drupal.

9 of 16 | Previous | Next

Comments

Back to top

Table of contents

• Before you start
• Installing Eclipse SDK
• Installing Apache HTTP Web server 2.0
• Installing PHP 5
• Installing MySQL 5
• Installing phpMyAdmin
• Installing optional software components
• Configuring Eclipse
• Configuring MySQL
• Importing and configuring Drupal
• Configuring PHP
• Configuring Apache
• Configuring phpMyAdmin
• Summary
• Resources
• About the authors

---

9 of 16 | Previous | Next

Next steps from IBM

With the no-charge DB2 Express-C, Zend Core PHP, and Java you can develop advanced Web 2.0 applications quickly that matter.

---

• Try: Download a free trial version of DB2 Express-C, which includes Zend Core PHP and pureXML technology that is ideally suited for managing both XML and relational data and powering a new breed of SOA and Web 2.0 solutions.
• Article: This IBM Redbook shows how to port PHP apps from MySQL to DB2, and includes code samples for creating Zend Core PHP applications.
• Tutorial: In this Mastering Facebook app development tutorial series, you will use Java and PHP in parallel to build a Facebook interface for an online stock trading J2EE application using the Spring framework.
• Buy: DB2 9 for Linux, UNIX and Windows

Dig deeper into Open source on developerWorks

Try IBM PureSystems. No charge.

Experience today!

---

Get started with the cloud-based trial and pattern development kit.