There's a type-o for one of your times, which is listed as
12.30 and should be
12:30.
With that change, the SQL should work. Make sure there is no space when specifying the MySQL password (i.e. you should specify your password like so:
-pmypassword and not
-p mypassword). Also note, that the password you need to enter is the MySQL password, not your Linux password, FreePBX password or any other password. This, by default, should be
passw0rd and should NOT be changed as it can cause significant issues. To make sure that this is indeed your MySQL password, type this from the linux command prompt:
If you get a
mysql> prompt, everything should work fine. If you get the error you mentioned above (
Access denied for user 'root'@'localhost' (using password: YES)), you've changed your MySQL password and will likely have more issues with your installation.
If you're still having trouble, run the same command as above from the linux command prompt, but leave off the
| mail -s "Meetings Attendance" [email protected] portion and let us know what errors are generated.