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')
--> );