[Fiware-tech-help] [Chp - Security][Identity Management] Default database names

David Muriel dmuriel at bitergia.com
Fri Oct 24 20:49:51 CEST 2014


When using the default database names provided in the
database.example.yml configuration file, the create database mysql
command must enclose the database name within backtick characters (`)
or mysql will raise an error like this:

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

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

Enclosing the name in backtick characters avoids this problem:

  mysql> create database `fi-ware-idm_development` ;
  Query OK, 1 row affected (0.00 sec)

Please, add backticks to the create database example available on the document.



More information about the Fiware-tech-help mailing list

You can get more information about our cookies and privacy policies clicking on the following links: Privacy policy   Cookies policy