Talk:Installation Guide for Installing on Amazon EC2

Revision as of 09:02, 30 March 2012 by Jason De Donno (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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.