how do i connect sql database ?

[ameinabdi]

How can read about sql db connection?

when i select mysql database i got this error to start project

[ghost]

Hi @ameinabdi, there is the orm.config.ts where is stored db information. For dev it will be always sqlite created on app startup.

[ameinabdi]

thanks @amanganiello90 i have added my info about database in that file but i still it doesn't work so did you test sql before now ?

[ghost]

What db have you choosen in the related question?

[ameinabdi]

mysql

[ghost]

What command are you using to startup application? Write in order the commands.

[ameinabdi]

jhipster --blueprint nodejs

[ghost]

That command is for generation.. I said about startup.. however for mysql prod db, the connection created is:

ormconfig = {
        name: 'default',
        type: 'mysql',
       url: 'mysql://localhost:27017/<your-app-name>,
        synchronize: true,
        logging: false,
        entities: [__dirname + '/domain/*.entity{.ts,.js}'],
    };

Change url with your mysql instance.

[ameinabdi]

i run this command inside the server folder npm start

[ghost]

i run this command inside the server folder npm start

Ok, so you are using sqlite dev db, not mysql.. paste in your server/src/orm.config.ts the orm.config.ts content

[ameinabdi]

but i don't need to use sqlite. i need to use mysql database

[ghost]

Then, replace in the if of Prod section the mysql source configuration and run:

set NODE_ENV=prod&&npm start

Please attention that in your db instance must be created the 3 user management tables, otherwise the initial db seed insert fails.

To disable it comment this line

[ameinabdi]

okey thanks a lot mr @amanganiello90