Solved Config lua Mysql causes server to shut down in a split sec...

[Alltay]

SOLVED!

I have a server and the programs needed.

ORIGINAL CONFIG LUA:
-- MySQL
mysqlHost = "localhost"
mysqlUser = "root"
mysqlPass = ""
mysqlDatabase = "theforgottenserver"
mysqlPort = 3306

-- SQL
sqlType = "sqlite"
passwordType = "plain"

CONFIG LUA WITH MY INFORMATION THAT I NEED FOR THE SERVER:
-- MySQL
mysqlHost = "localhost"
mysqlUser = "xxx
mysqlPass = "zzz"
mysqlDatabase = "xxx"
mysqlPort = 3306

-- SQL
sqlType = "mysql"
passwordType = "sha1"

THE PROBLEM:
When i change the configlua to the configuration that i need the server wont turn on. It loads for a split second and then the window closes.

Can anyone help me?
The password for mysql is correct and everything.
The problem occurs when i change --SQL -> sqlType to "mysql". Thats when it doesnt work.

 

[dominique120]

Do you have a mysql database set up?

Change "localhost" to "127.0.0.1"

 

[Alltay]

Do you have a mysql database set up?

Change "localhost" to "127.0.0.1"

I have the Uniserver and through there i clicked phpMyAdmin and made an username and a database.
And i have Mysql and Apache running and open etc.

Will try with 127.0.0.1.

Edit: HEY it worked with 127.0.0.1 Thank you !!!

 

[Limos]

You can use this tutoial to see if you did the MySQL setup correct.
http://otland.net/threads/video-tut...ing-ot-server-website-and-shop-system.166818/

 

[Alltay]

You can use this tutoial to see if you did the MySQL setup correct.
http://otland.net/threads/video-tut...ing-ot-server-website-and-shop-system.166818/

Ah thanks! It turned out to be something wrong with localhost. Had to write 127.0.0.1 idk why it didnt work with "localhost" but i will have a look at your link looks good thx