About the database

In English
1

Hi,guy!
How to setup mysql as the database?
In installation, I Chose mysql as the database,but it failed when it runned;I chose derby, everything is ok.
But I like mysql more,and it seems that mysql has more ui tools for management.

I did the following:
1.I create a database named scadabr on localhost.
2.I run createTables-mysql.sql to create all the tables.
3.I changed env.properties:
db.url=jdbc:mysql://localhost/scadabr
db.username=root
db.password=root
db.pool.maxActive=10
db.pool.maxIdle=10

#db.type=derby
#db.url=~/…/…/bin/scadabrDB
#db.username=
#db.password=

convert.db.type=
convert.db.url=
convert.db.username=root
convert.db.password=root

But it still didn’t go.
So,help me.

2

Hello,

You´d have to set the MySQL DB by yourself. ScadaBR instalation does not install MySQL server. You should configure it directly, and configure in the env.properties its data (database name, user and password).

You do not need to run create-tables.mysql. ScadaBR does it for you. You only have to set user and password with permissions in the scadabr db.

Thats it. Hope it works.

BRs