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.
_______________________________________________
Fiware-tech-help mailing list
Fiware-tech-help@lists.fi-ware.org
https://lists.fi-ware.org/listinfo/fiware-tech-help