skatkov's Avatar


30 Jul, 2010 04:51 PM

I was following instructions on installing Cascade Server and I got this strange error when trying to create cascade database in mysql 5.0.45

mysql> create database cascade;
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 'cascade' at line 1

when i change the name a little (for example cascade1), the database gets created just fine:
mysql> create database cascade1;
Query OK, 1 row affected (0.00 sec)

My only guess is that word "cascade" has some command syntax meaning in mysql. I'm new to mysql.
anyone has any ideas or ran in to same issue?
thank you!

  1. 1 Posted by Joel on 30 Jul, 2010 04:59 PM

    Joel's Avatar


    The term cascade is a reserved word in MySQL, please see the link below for an example of this functionality:

    Since it is a reserved work, you have to wrap the word "cascade" in ` marks.

    I.e. mysql> create database `cascade` ;


  2. 2 Posted by skatkov on 30 Jul, 2010 05:14 PM

    skatkov's Avatar

    Excellent! thank you Joel.
    that was my guess about reserved word, only i tried different quote marks " and ' but none of those worked.
    So that solved it.
    By the way it's good idea to update install instructions for newbies like myself :)

  3. Support Staff 3 Posted by Tim on 30 Jul, 2010 08:33 PM

    Tim's Avatar


    I've updated our documentation to make sure that the database named cascade appears in tick marks.


  4. Tim closed this discussion on 30 Jul, 2010 08:33 PM.

Discussions are closed to public comments.
If you need help with Cascade CMS please start a new discussion.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac


26 Aug, 2016 01:19 PM
25 Aug, 2016 03:02 PM
25 Aug, 2016 12:50 PM
24 Aug, 2016 08:43 PM
24 Aug, 2016 07:20 PM
21 Aug, 2016 01:20 PM