Connect to the database using MySQL Query Browser with the
root account and the mysql schema. Run the script ‘
fbdjstats database setup.sql’
1. Exit MySQL Query Browser and connect to the database using MySQL Administrator again using the root account. Now we need to add privileges to the user accounts
fbdadmin and
fbduser for the schema
fbdjstats by performing the following:
2. Click on the ‘User Administration’ then click on the account ‘
fbdadmin’
3. Click on the Schema Privileges tab and select the
fbdjstats schema
4. Select all the available privileges and move them to the assigned privileges column to grant all privileges to the fbdadmin account.
5. Click on ‘
Apply Changes’ to save.