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

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

From MoodleDocs
mNo edit summary
No edit summary
 
(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.