Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Now that MySQL is installed and we have a root password established for it, it's time to create the database that Drupal will use and create a MySQL user for it.
$ mysqladmin -u root -p create drupal
Enter password:
$ mysql -u root -p
Enter password: zoinks
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 15 to server version: 4.1.11-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> GRANT ALL PRIVILEGES ON drupal.* TO drupaldbuser@localhost IDENTIFIED BY 'fuffy';
Query OK, 0 rows affected (0.04 sec)
mysql> SET PASSWORD FOR 'drupaldbuser'@'localhost' = OLD_PASSWORD('fuffy');
Query OK, 0 rows affected (0.00 sec)
This last line was necessary because Tiger comes with PHP 4, and the MySQL libraries for PHP 4 use a different authentication protocol.
mysql> flush privileges;
Query OK, 0 rows affected (0.19 sec)
mysql> \q
Bye
Now I paused to rejoice. MySQL was installed. Now it was time to install Drupal.