Talk:Installation Guide for Installing on Amazon EC2
Note: You are currently viewing documentation for Moodle 2.4. Up-to-date documentation for the latest stable version of Moodle may be available here: Installation Guide for Installing on Amazon EC2.
Under "Set up MYSQL" "Make additional security-related changes to mysql", there is a command to remove anonymous access:
mysql> DELETE FROM mysql.user WHERE user = ;
This returns a syntax error for me. However:
mysql> DELETE FROM mysql.user WHERE user = ' ' ;
I believe those quotes should be there, and think the problem is caused when attempting to type the apostrophy directly into Moodle WYSIWYG editor, which translates into an empty space. If you use the double apostrophy directly in the MySQL commandline editor instead of leaving it blank, then it appears to work. I think this is the correct syntax.