Can't connect to database - Site + Server

[Dankoo]

It's the first time I'm using a dedicated server

My problem:

Can't access my database through site:

File config.lua loaded from C:/inetpub/vhosts/tibiabr.org/httpdocs/config/config.lua and looks like fine server config file. Now you can check database(mysql) connection: STEP 2 - check database connection

I've already deleted .htaccess file from config folder, my config.lua is in config folder and the path is correct, as well as the MySQL connection information:

Site's config.lua:

sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "MY USERNAME"
sqlPass = "MY PASSWORD"
sqlDatabase = "MY DATABASE"

My server can access it, but it won't start up!
My site and my database are in the same server
My server is hosted in my house, 'cause I'm still making it
I have tried to set the same IP on both configs.lua, and site still can't connect, even with the exact same user/password informations

I've posted these errors because I don't have SUPER privileges on the database, is it a problem? Looks confusing but it's really clear when you read it \/

 

[Dankoo]

Ignore this post

Ok, I've managed to solve part of the problems

The error messages disappeared, I've gave full permission and now it's gone... After install I'll restore normal permissions

Now, server still takes ages to start (if it start at all), and site still can't connect to database, even with the same data in both server and site... In IP, should I put localhost or the database's IP? wich is the same as the site, database and site are hosted in the same dedicated

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.Can't connect to MySQL database.

Maybe another permission problem? The username, IP and password are correct!

 

[Dankoo]

Topic updated.