Setting Up Stage

Creating MySQL database

You must have a database created with mysqladmin, we are using the name STAGE_PROTO for prototyping purposes.

Run the mysql-create SQL as the mysql root user. ( mysql < mysql-create .sql )

If you create a user using the GRANT statement you won't be able to connect to the database from localhost. Add a record into the mysql.user table that matches your user record, except with Host = 'localhost' instead of Host = '%', thus:

mysql> select host, user, password from user where user = 'STAGE';

hostuserpassword
% STAGE09d121a84377e73d
localhostSTAGE09d121a84377e73d

It's probably safe to remove the % entry if you're running on a single machine.