the member db grant privileges as stated in ReadMe give errors

Asked by Preston C on 2009-01-13

Below is the command prompt (Windows) of my execution of the database initialization procedures. It causes an error:
=================================================================
C:\Documents and Settings\GetReality\My Documents\MySQL Databases>c:\mysql\bin
'c:\mysql\bin' is not recognized as an internal or external command,
operable program or batch file.

C:\Documents and Settings\GetReality\My Documents\MySQL Databases>c:\mysql\bin\m
ysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19
Server version: 5.1.30-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create_prelude.sql
    -> create_database.sql
    -> initial_data.sql
    -> site_messages.sql
    -> GRANT ALL ON memberdb.* TO 'memberdb'@'localhost' IDENTIFIED BY 'pants';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'creat
e_prelude.sql
create_database.sql
initial_data.sql
site_messages.sql
GRANT ' at line 1
mysql>
====================================================
What do I need to do to fix the GRANT privileges step?
Thanks,
Preston

Question information

Language:
English Edit question
Status:
Answered
For:
MemberDB Edit question
Assignee:
No assignee Edit question
Last query:
2009-01-13
Last reply:
2009-01-27
Stewart Smith (stewart) said : #1

try the GRANT in a new session. the previous scripts set sql_mode, which could be causing issues.

Can you help with this problem?

Provide an answer of your own, or ask Preston C for more information if necessary.

To post a message you must log in.