iae galera , estou com um problema no meu servidor para abri-lo , quando eu abro o executável para deixa-lo online , ele da esse error -  Failed connecting to database - MYSQL ERROR : Can't connect 

to MySQL server on 'locahost' <10061> <2003>

 ERROR : Couldn't estabilish connection  to SQL database . 

Se alguem puder ajudar por favor ! 

minhas config.lua - 

 

enableCast = false
accountManager = "no"
namelockManager = "yes"
newPlayerChooseVoc = "yes"
newPlayerSpawnPosX = 324
newPlayerSpawnPosY = 1006
newPlayerSpawnPosZ = 6
newPlayerTownId = 1
newPlayerLevel = 100
newPlayerMagicLevel = 10
generateAccountNumber = "no"
redSkullLength = 50 * 62 * 70 * 90
blackSkullLength = 64 * 72 * 80 * 95
dailyFragsToRedSkull = 5
weeklyFragsToRedSkull = 20
monthlyFragsToRedSkull = 40
dailyFragsToBlackSkull = 10
weeklyFragsToBlackSkull = 25
monthlyFragsToBlackSkull = 45
dailyFragsToBanishment = 100
weeklyFragsToBanishment = 300
monthlyFragsToBanishment = 500
blackSkulledDeathHealth = 400
blackSkulledDeathMana = 100
useBlackSkull = true
useFragHandler = true
advancedFragList = false
notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 7 * 24 * 60 * 60
killsBanLength = 8 * 24 * 60 * 60
finalBanLength = 30 * 24 * 60 * 60
ipBanishmentLength = 9999 * 24 * 60 * 60
broadcastBanishments = false
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false 
worldType = "open"
protectionLevel = 1000
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 20 * 800
huntingDuration = 30 * 1000
criticalHitChance = 5
criticalHitMultiplier = 1.1
displayCriticalHitNotify = true
removeWeaponAmmunition = false
removeWeaponCharges = false
removeRuneCharges = "no"
whiteSkullTime = 8 * 10 * 100
noDamageToSameLookfeet = false
showHealingDamage = true
showHealingDamageForMonsters = true
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 30 * 1000
deathLostPercent = 10
stairhopDelay = 2 * 1000
pushCreatureDelay = 0 * 1000
deathContainerId = 1987
gainExperienceColor = 205
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true
worldId = 0
ip = "chavitobaiak.servegame.com"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 50
motd = "Bem vindo ao Chavito"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = false
allowClones = false
serverName = "Chavito"
loginMessage = "Bem vindo ao Chavito , divirta-se!"
statusTimeout = 30 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "minha senha eu coloco aqui"
sqlDatabase = "tibia"
sqlFile = "tibia.sql"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"
deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5
ingameGuildManagement = true
levelToFormGuild = 1000
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20
highscoreDisplayPlayers = 100
updateHighscoresAfterMinutes = 2
buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 5000
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 1000
houseRentPeriod = "never"
houseCleanOld = 0
guildHalls = false
timeBetweenActions = 200
timeBetweenExActions = 1000
checkCorpseOwner = true
hotkeyAimbotEnabled = true
maximumDoorLevel = 999
mapName = "Baiak.otbm"
mapAuthor = "Movie"
randomizeTiles = true
useHouseDataStorage = false
storeTrash = true
cleanProtectedZones = true
mailboxDisabledTowns = "-1"
defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"
optimizeDatabaseAtStartup = true
removePremiumOnInit = true
confirmOutdatedVersion = false
maxMessageBuffer = 4
bufferMutedOnSpellFailure = false
dataDirectory = "data/"
allowChangeOutfit = true
allowChangeColors = true
allowChangeAddons = true
disableOutfitsForPrivilegedPlayers = false
bankSystem = true
saveGlobalStorage = true
displaySkillLevelOnAdvance = true
spellNameInsteadOfWords = false
emoteSpells = true
promptExceptionTracerErrorBox = true
storePlayerDirection = false
monsterLootMessage = 3
monsterLootMessageType = 25
separateViplistPerCharacter = false
ghostModeInvisibleEffect = true
ghostModeSpellEffects = true
idleWarningTime = 20 * 60 * 1000
idleKickTime = 30 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 99
maxItemsPerHouseTile = 50
freePremium = true
premiumForPromotion = true
blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8
experienceStages = "yes"
rateExperience = 9999
rateExperienceFromPlayers = 20
rateSkill = 200
rateMagic = 150
rateLoot = 25
rateSpawn = 80
rateMonsterHealth = 1.1
rateMonsterMana = 1.0
rateMonsterAttack = 1.0
rateMonsterDefense = 1.2
minLevelThresholdForKilledPlayer = 0.9
maxLevelThresholdForKilledPlayer = 1.1
rateStaminaLoss = 3
rateStaminaGain = 1
rateStaminaThresholdGain = 12
staminaRatingLimitTop = 41 * 60
staminaRatingLimitBottom = 14 * 60
rateStaminaAboveNormal = 1.5
rateStaminaUnderNormal = 0.5
staminaThresholdOnlyPremium = true
experienceShareRadiusX = 30
experienceShareRadiusY = 30
experienceShareRadiusZ = 1
experienceShareLevelDifference = 2 / 3
extraPartyExperienceLimit = 20
extraPartyExperiencePercent = 5
experienceShareActivity = 2 * 60 * 1000
globalSaveEnabled = false
globalSaveHour = 6
shutdownAtGlobalSave = true
cleanMapAtGlobalSave = true
deSpawnRange = 2
deSpawnRadius = 50
maxPlayerSummons = 0
teleportAllSummons = false
teleportPlayerSummons = false
ownerName = "Movie"
ownerEmail = ""
url = ""
location = "BR"
displayGamemastersWithOnlineCommand = false
adminLogsEnabled = true
displayPlayersLogging = true
prefixChannelLogs = "[Soft Baiak] "
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false

Editado Agosto 8, 2017 7 anos por Juarez Tibia (veja o histórico de edições)

  Em 08/08/2017 em 17:20, Juarez Tibia disse:

iae galera , estou com um problema no meu servidor para abri-lo , quando eu abro o executável para deixa-lo online , ele da esse error -  Failed connecting to database - MYSQL ERROR : Can't connect 

to MySQL server on 'locahost' <10061> <2003>

 ERROR : Couldn't estabilish connection  to SQL database . 

Se alguem puder ajudar por favor ! 

minhas config.lua - 

 

enableCast = false
accountManager = "no"
namelockManager = "yes"
newPlayerChooseVoc = "yes"
newPlayerSpawnPosX = 324
newPlayerSpawnPosY = 1006
newPlayerSpawnPosZ = 6
newPlayerTownId = 1
newPlayerLevel = 100
newPlayerMagicLevel = 10
generateAccountNumber = "no"
redSkullLength = 50 * 62 * 70 * 90
blackSkullLength = 64 * 72 * 80 * 95
dailyFragsToRedSkull = 5
weeklyFragsToRedSkull = 20
monthlyFragsToRedSkull = 40
dailyFragsToBlackSkull = 10
weeklyFragsToBlackSkull = 25
monthlyFragsToBlackSkull = 45
dailyFragsToBanishment = 100
weeklyFragsToBanishment = 300
monthlyFragsToBanishment = 500
blackSkulledDeathHealth = 400
blackSkulledDeathMana = 100
useBlackSkull = true
useFragHandler = true
advancedFragList = false
notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 7 * 24 * 60 * 60
killsBanLength = 8 * 24 * 60 * 60
finalBanLength = 30 * 24 * 60 * 60
ipBanishmentLength = 9999 * 24 * 60 * 60
broadcastBanishments = false
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = false 
worldType = "open"
protectionLevel = 1000
pvpTileIgnoreLevelAndVocationProtection = true
pzLocked = 20 * 800
huntingDuration = 30 * 1000
criticalHitChance = 5
criticalHitMultiplier = 1.1
displayCriticalHitNotify = true
removeWeaponAmmunition = false
removeWeaponCharges = false
removeRuneCharges = "no"
whiteSkullTime = 8 * 10 * 100
noDamageToSameLookfeet = false
showHealingDamage = true
showHealingDamageForMonsters = true
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = false
oldConditionAccuracy = false
loginProtectionPeriod = 30 * 1000
deathLostPercent = 10
stairhopDelay = 2 * 1000
pushCreatureDelay = 0 * 1000
deathContainerId = 1987
gainExperienceColor = 205
addManaSpentInPvPZone = true
squareColor = 0
allowFightback = true
worldId = 0
ip = "chavitobaiak.servegame.com"
bindOnlyConfiguredIpAddress = false
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 50
motd = "Bem vindo ao Chavito"
displayOnOrOffAtCharlist = false
onePlayerOnlinePerAccount = false
allowClones = false
serverName = "Chavito"
loginMessage = "Bem vindo ao Chavito , divirta-se!"
statusTimeout = 30 * 60 * 1000
replaceKickOnLogin = true
forceSlowConnectionsToDisconnect = false
loginOnlyWithLoginServer = false
premiumPlayerSkipWaitList = false
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "minha senha eu coloco aqui"
sqlDatabase = "tibia"
sqlFile = "tibia.sql"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
encryptionType = "sha1"
deathListEnabled = true
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5
ingameGuildManagement = true
levelToFormGuild = 1000
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20
highscoreDisplayPlayers = 100
updateHighscoresAfterMinutes = 2
buyableAndSellableHouses = true
houseNeedPremium = true
bedsRequirePremium = true
levelToBuyHouse = 5000
housesPerAccount = 0
houseRentAsPrice = false
housePriceAsRent = false
housePriceEachSquare = 1000
houseRentPeriod = "never"
houseCleanOld = 0
guildHalls = false
timeBetweenActions = 200
timeBetweenExActions = 1000
checkCorpseOwner = true
hotkeyAimbotEnabled = true
maximumDoorLevel = 999
mapName = "Baiak.otbm"
mapAuthor = "Movie"
randomizeTiles = true
useHouseDataStorage = false
storeTrash = true
cleanProtectedZones = true
mailboxDisabledTowns = "-1"
defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"
optimizeDatabaseAtStartup = true
removePremiumOnInit = true
confirmOutdatedVersion = false
maxMessageBuffer = 4
bufferMutedOnSpellFailure = false
dataDirectory = "data/"
allowChangeOutfit = true
allowChangeColors = true
allowChangeAddons = true
disableOutfitsForPrivilegedPlayers = false
bankSystem = true
saveGlobalStorage = true
displaySkillLevelOnAdvance = true
spellNameInsteadOfWords = false
emoteSpells = true
promptExceptionTracerErrorBox = true
storePlayerDirection = false
monsterLootMessage = 3
monsterLootMessageType = 25
separateViplistPerCharacter = false
ghostModeInvisibleEffect = true
ghostModeSpellEffects = true
idleWarningTime = 20 * 60 * 1000
idleKickTime = 30 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 99
maxItemsPerHouseTile = 50
freePremium = true
premiumForPromotion = true
blessingOnlyPremium = true
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8
experienceStages = "yes"
rateExperience = 9999
rateExperienceFromPlayers = 20
rateSkill = 200
rateMagic = 150
rateLoot = 25
rateSpawn = 80
rateMonsterHealth = 1.1
rateMonsterMana = 1.0
rateMonsterAttack = 1.0
rateMonsterDefense = 1.2
minLevelThresholdForKilledPlayer = 0.9
maxLevelThresholdForKilledPlayer = 1.1
rateStaminaLoss = 3
rateStaminaGain = 1
rateStaminaThresholdGain = 12
staminaRatingLimitTop = 41 * 60
staminaRatingLimitBottom = 14 * 60
rateStaminaAboveNormal = 1.5
rateStaminaUnderNormal = 0.5
staminaThresholdOnlyPremium = true
experienceShareRadiusX = 30
experienceShareRadiusY = 30
experienceShareRadiusZ = 1
experienceShareLevelDifference = 2 / 3
extraPartyExperienceLimit = 20
extraPartyExperiencePercent = 5
experienceShareActivity = 2 * 60 * 1000
globalSaveEnabled = false
globalSaveHour = 6
shutdownAtGlobalSave = true
cleanMapAtGlobalSave = true
deSpawnRange = 2
deSpawnRadius = 50
maxPlayerSummons = 0
teleportAllSummons = false
teleportPlayerSummons = false
ownerName = "Movie"
ownerEmail = ""
url = ""
location = "BR"
displayGamemastersWithOnlineCommand = false
adminLogsEnabled = true
displayPlayersLogging = true
prefixChannelLogs = "[Soft Baiak] "
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = false

Você instalou o banco de dados ? o phpmyadmin etc..? se ainda continuar muda 

sqlHost = "localhost"

para 

sqlHost = "127.0.0.1" 

 

*se caso n use site nem phpmyadmin.

mude 

sqlType = "mysql" 

para 

sqlType = "sqlite"

espero ter ajudo