Cant connect to MySQL database

[Jamzitox]

	-- Database
	sqlType = "mysql"

	sqlHost = "mysq2151.hosting.net"

	sqlPort = 3306

	sqlUser = "hosting_user"

	sqlPass = "password"

	sqlDatabase = "hosting_database"

	sqlFile = "forgottenserver.s3db"

	sqlKeepAlive = 0

	mysqlReadTimeout = 10

	mysqlWriteTimeout = 10

	passwordType = "plain"

error

Can't connect to MySQL database.

I can not have my database on a website and hosting?

 

[Nevalopo]

Humm.. Is that exactly as u have it in the config? Or u have changed to root and real password and database name?
And.. Is 3306 open? are u using router?

 

[Jamzitox]

using router :S root and localhost yes
hosting not :S error hosting

 

[Nevalopo]

Have you entered your router and opened port 3306 properly?

 

[Kekox]

I'm not sure that this will work like that

sqlHost = "mysq2151.hosting.net"

Why dont you try with localhost?

And why dont you use root?

 

[Elde Monx]

What a noob my god... that's why you do not edit your config.lua
sqlType = "Your SQL Type"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = ""
sqlDatabase = "theforgottenserver"
sqlFile = "forgottenserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
passwordType = "plain"

 

[Nevalopo]

@up i think he edited that.. or else he is uber mega noob.. I think it's something else

 

[Jamzitox]

I have my database in a web host that accepts phpmyadmin and mysql but out error in the web: S!

-- Database
sqlType = "mysql"

sqlHost = "mysq2151.hosting.net"

sqlPort = 3306

sqlUser = "hosting_user"

sqlPass = "password"

sqlDatabase = "hosting_database"

sqlFile = "forgottenserver.s3db"

sqlKeepAlive = 0

mysqlReadTimeout = 10

mysqlWriteTimeout = 10

passwordType = "plain"

my server is mysql not sqlite -.-"

Please Help Me :S

server and web
Can't connect to MySQL database.

images:

 

[Nevalopo]

	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "Put_Your_Password_Here"
	sqlDatabase = "Put_Your_Database_Name_Here"
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	passwordType = "plain"

Make sure all the ports are open properly.. What router are you using?

 

[Jamzitox]

I buy a web host that supports mysql and phpmyadmin and I went up to hosting my database and I want to connect to the database nose because I get this error

I once used localhost but I have limits and I have my database safe and no problem!

 

[Elde Monx]

sqlType = "mysql"

sqlHost = "mysq2151.hosting.net"

sqlType = "mysql"

sqlHost = "mysql2151.hosting.net"

 

[Jamzitox]

Elde Monx, I do not understand, I could explain it better? :S

 

[Elde Monx]

I Think you have this part bad mysq2151.hosting.net;You have to copy thismysql2151.hosting.net"

 

[Jamzitox]

I got it right :s I get when I enter the page of phpmyadmin :S!

 

[Elde Monx]

You have to check if you have all thing right, if i dont know where are becoming the error i cant help you sorry..