*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
Make a database & user
Here is lots of information about creating the database for a Drupal site. Lately I use this shell script: create_drupal_db.sh
| Code Block |
|---|
#!/bin/bash
EXPECTED_ARGS=3
E_BADARGS=65
MYSQL=`which mysql`
Q1="CREATE DATABASE IF NOT EXISTS $1;"
Q2="GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, LOCK TABLES, CREATE TEMPORARY TABLES ON $1.* TO '$2'@'localhost' IDENTIFIED BY '$3';"
Q3="FLUSH PRIVILEGES;"
SQL="${Q1}${Q2}${Q3}"
if [ $# -ne $EXPECTED_ARGS ]
then
echo "Usage: $0 dbname dbuser dbpass"
exit $E_BADARGS
fi
$MYSQL -e "$SQL"
|
Find a web accessible home for the site
You can put the Drupal site in the web server's document root or your public HTML directory, or you can put a symbolic link there that points to the site.
| Code Block |
|---|
bash> cd ~
bash> mkdir my_cute_cat
bash> echo "Hello World" > my_cute_cat/hello.txt
bash> cd /libweb/sites/my_cute_cat.library.cornell.edu/htdocs
bash> ln -s ~/my_cute_cat kitty
|