Singer MySQL

$ mysql -u root -p

Enter password: 84.......

Using tutorial at:
http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

For facebook example 4 app (display counter):
mysql> create database menagerie; /* this was name of database in above tutorial */
Query OK, 1 row affected (0.00 sec)
mysql> use menagerie;
Database changed

mysql> show tables;
Empty set (0.00 sec)

mysql> create table counter (count INT);
Query OK, 0 rows affected (0.06 sec)

mysql> quit

Bye

Then, in dbappinclude.php:

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'menagerie'; /* the name of the database created in the above tutorial */

Ran into trouble though because the php_mysql package is not installed on singer. Asked SNR to install it or tell me how.

mysql> create database footprints;
mysql> use footprints;
mysql> create table 'footprints' (
--> 'from' int(11) NOT NULL default '0',
--> 'to' int(11) NOT NULL default '0',
--> 'time' int(11) NOT NULL default '0',
--> KEY 'from' ('from'),
--> KEY 'to' ('to')
--> );