If I choose the derby database ,how long how long when use derby database for store data that the mango connect equipment? if I choose mysql or postpresql, how to setting in mango in windows version.
How long when use derby database for store data that the mango connect equipment?
I don't really understand your question but I think I know what you are getting at and there is no set rule about how large to let a derby database get. It should be noted that the default database being used in Mango 2.4.2 is H2 which is much better than derby. I would say if your database is going to larger than a few GB then I would recommend going to MySQL. In general for most production implementations of Mango I would recomend using MySQL over derby.
Hope that helps.
if I choose mysql or postpresql, how to setting mango in windows version. have any step by step?
PostgresSQL is not an option for Mango. To configure mango for MySQL you do that in the /classes/env.properties file.
You need to create a blank database and user with full permissions to the database.
Yes .Thank JoelHaggars.
You are right. When I use bleow command .the covert db is ok.
grant all privileges on db.* To 'username'@'localhost' identified by 'password';