MySQL Notes

Various bits of information about using MySQL with Siteframe.

MySQL Permissions

Typically, you need these permissions on your MySQL database:

grant alter,index,select,insert,pdate,delete,create,drop on database.* to 'user'@'host' identified by 'password'

or (somewhat easier)

grant all on database.* to 'user'@'host' identified by 'password'

though this is possibly less secure.