Difference between revisions of "Talk:Installation Guide for Installing on Amazon EC2"

Jump to: navigation, search

Note: You are currently viewing documentation for Moodle 3.2. Up-to-date documentation for the latest stable version of Moodle is probably available here: Installation Guide for Installing on Amazon EC2.

m
 
(8 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
mysql> DELETE FROM mysql.user WHERE user = ;       
 
mysql> DELETE FROM mysql.user WHERE user = ;       
  
This returns a syntax error for me. However, if I do this:
+
This returns a syntax error for me. However:
  
mysql> DELETE FROM mysql.user WHERE user = "''";
+
mysql> DELETE FROM mysql.user WHERE user = ' ' ;
  
Then it appears to work. I think this is the correct syntax.
+
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.

Latest revision as of 09:02, 30 March 2012

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.