• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows Annoying MySQL error

Evan

A splendid one to behold
Senator
Premium User
Joined
May 6, 2009
Messages
7,019
Solutions
1
Reaction score
1,029
Location
United States
Haven't worked on a server in a very long time, so I may have forgotten the steps to set up a database to log onto the server.
Anyways, here's the problem I have, I'm trying to at least get a server up that allows me to log on, I've set up the config.lua correctly (should be) and uploaded mysql.sql in the schemas folder.
However, when I run the server, I get an error you will see in the following picture.

oiwx15.png


Notice, the database name in config.lua and the database name on phpMyAdmin are correctly written and they are the same.

Does anyone know what's wrong? REP++ will be given.
 
I've tried without upper-cases, NAAPV.
I've created a new database, one word, all lower-case, no numbers.

Same problem.

UPDATE: I've added the "schemas/" part in sqlFile.

Lua:
	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "**********"
	sqlDatabase = "evansserver"
	sqlFile = "schemas/mysql.sql"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	mysqlReconnectionAttempts = 3
	encryptionType = "sha1"

STILL SAME PROBLEM.
 
Last edited:
Back
Top