title: NestJS - [TypeOrmModule] Unable to connect to the database. Retrying ER_PARSE_ERROR
body: <p>Cannot able to connect database with correct connection info, followed documentation to connect database from <a href="https://docs.nestjs.com/techniques/database" rel="noreferrer">https://docs.nestjs.com/techniques/database</a></p>
  <p><strong>Database connected on SQLYog</strong></p>
  <p><a href="https://i.stack.imgur.com/2ecFX.png" rel="noreferrer"><img src="https://i.stack.imgur.com/2ecFX.png" alt="enter image description here" /></a></p>
  <p>Following same database information in <strong>app.module.ts</strong></p>
  <pre><code>@Module({
    imports: [
      TypeOrmModule.forRoot({
        type: 'mysql',
        host: 'localhost',
        port: 3306,
        username: 'root',
        password: null,
        database: 'the_local_db',
        entities: [
          Table_one,
        ],
        // entities: ['../typeorm/entities/*.ts'],
  
        synchronize: true,
      }),
      StaffModule,
    ],
    controllers: [AppController],
    providers: [AppService],
  })
  export class AppModule {}
  </code></pre>
  <p>Error Details</p>
  <p>`[Nest] 5528   - 06/30/2020, 1:39:51 AM   [ExceptionHandler] ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''&quot;'' at line 1 +18m
  QueryFailedError: ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''&quot;'' at line 1</p>
  <p>at new QueryFailedError (C:\Users\UserName\ProjectName\nrwl\src\error\QueryFailedError.ts:9:9)
  at Query. (C:\Users\UserName\ProjectName\nrwl\src\driver\mysql\MysqlQueryRunner.ts:167:37)
  at Query. (C:\Users\UserName\ProjectName\nrwl\node_modules\mysql\lib\Connection.js:526:10)
  at Query._callback (C:\Users\UserName\ProjectName\nrwl\node_modules\mysql\lib\Connection.js:488:16)
  at Query.Sequence.end (C:\Users\UserName\ProjectName\nrwl\node_modules\mysql\lib\protocol\sequences\Sequence.js:83:24)
  at Query.ErrorPacket (C:\Users\UserName\ProjectName\nrwl\node_modules\mysql\lib\protocol\sequences\Query.js:92:8)
  at Protocol._parsePacket (C:\Users\UserName\ProjectName\nrwl\node_modules\mysql\lib\protocol\Protocol.js:291:23)
  at Parser._parsePacket (C:\Users\UserName\ProjectName\nrwl\node_modules\mysql\lib\protocol\Parser.js:433:10)
  at Parser.write (C:\Users\UserName\ProjectName\nrwl\node_modules\mysql\lib\protocol\Parser.js:43:10)
  at Protocol.write (C:\Users\UserName\ProjectName\nrwl\node_modules\mysql\lib\protocol\Protocol.js:38:16)`</p>