This little cheat sheet describes some basic command you will need to use if your working with a debian system.
An example of how to add SELECT privileges to a user using GRANT
GRANT SELECT ON projectdb.* TO user@'localhost' IDENTIFIED BY 'passwd';
GRANT ALL PRIVILEGES ON *.* TO user@'%' IDENTIFIED BY 'passwd';
If SELECT is not enough for our user we can add more privileges using a query similar to the one below:
An example of how to add a selection of privileges to a user using GRANT
GRANT SELECT, INSERT, DELETE ON projectdb.* TO user@'localhost' IDENTIFIED BY 'passwd';
If you want to GRANT ALL the privileges to a user then use this query:
Issue the following command(s) from the linux terminal.
> sudo gedit /etc/default/rcS
change the variable UTC=yes to UTC=no
save you file and then issue
> sudo ntpdate -s time.nrc.ca
or any other time server you might like to use.