Windows Database error - can't connect to MySQL database.

[lewy1000]

Hey.
I want to use gensior acc maker but when I installing web then i have error with mysql

Check database connection
If you don't see any errors press link to STEP 3 - Add tables and columns to DB. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.Database error - can't connect to MySQL database. Possible reasons:
1. MySQL server is not running on host.
2. MySQL user, password, database or host isn't configured in: c:/server/config.lua .
3. MySQL user, password, database or host is wrong.

any1 know why?

 

[Ninja]

Have you configured the settings in config.lua?

sqlType = "[COLOR=#ff0000]mysql[/COLOR]"
sqlHost = "127.0.0.1"
sqlPort = 3306
sqlUser = "[COLOR=#ff0000]XXXXXX[/COLOR]"
sqlPass = "[COLOR=#ff0000]XXXXXX[/COLOR]"
sqlDatabase = "[COLOR=#ff0000]XXXXXXX[/COLOR]"
encryptionType = "sha1"

 

[lewy1000]

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3307
sqlUser = "root"
sqlPass = "xxx"
sqlDatabase = "xxx"
sqlFile = "mysql.sql"
sqlKeepAlive = 0

i change localhost to 127.0.0.1 and still not work

I'm using appserv.

 

[sn3ejk]

I'm not sure but GesiorAAC has got problem with reading config.lua with comments. I guess you should remove all comments from your config.lua and it should work. Of course, if you configured your MySQL connection well.


_
Regards,
sn3ejk

 

[lewy1000]

server works. i delete all comments.