Details
-
Type: extRequest
-
Status: Closed
-
Priority: Major
-
Resolution: Done
-
Fix Version/s: Sprint 4.1.1
-
Component/s: FIWARE-TECH-HELP
-
Labels:None
-
HD-Chapter:Security
-
HD-Enabler:KeyRock
Description
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
Activity
- All
- Comments
- History
- Activity
- Transitions
Done! Thanks