Error on my Conection Mysql

[lsenturion]

Hey guys i have a really bad problem, I can´t connect to Database on my phpmyadmin. I have this shutdown



And this is my config.lua

-- The Forgotten Server Config

-- Account manager
accountManager = "no"
namelockManager = "yes"
newPlayerChooseVoc = "yes"
newPlayerSpawnPosX = 32369
newPlayerSpawnPosY = 32241
newPlayerSpawnPosZ = 7
newPlayerTownId = 3
newPlayerLevel = 35
newPlayerMagicLevel = 5
generateAccountNumber = "no"
generateAccountSalt = "yes"

-- Unjustified kills
redSkullLength = 3 * 24 * 60 * 60
blackSkullLength = 7 * 24 * 60 * 60
dailyFragsToRedSkull = 20
weeklyFragsToRedSkull = 30
monthlyFragsToRedSkull = 35
dailyFragsToBlackSkull = dailyFragsToRedSkull
weeklyFragsToBlackSkull = weeklyFragsToRedSkull
monthlyFragsToBlackSkull = monthlyFragsToRedSkull
dailyFragsToBanishment = dailyFragsToRedSkull
weeklyFragsToBanishment = weeklyFragsToRedSkull
monthlyFragsToBanishment = monthlyFragsToRedSkull
blackSkulledDeathHealth = 40
blackSkulledDeathMana = 0
useBlackSkull = "yes"
advancedFragList = "no"

-- Banishments
notationsToBan = 3
warningsToFinalBan = 4
warningsToDeletion = 5
banLength = 7 * 24 * 60 * 60
finalBanLength = 30 * 24 * 60 * 60
ipBanishmentLength = 1 * 24 * 60 * 60
broadcastBanishments = "yes"
maxViolationCommentSize = 200
violationNameReportActionType = 2
autoBanishUnknownBytes = "no"

-- Battle
worldType = "open"
protectionLevel = 50
pvpTileIgnoreLevelAndVocationProtection = "yes"
pzLocked = 1 * 1000
huntingDuration = 60 * 1000
criticalHitChance = 5
criticalHitMultiplier = 2
displayCriticalHitNotify = "no"
removeWeaponAmmunition = "no"
removeWeaponCharges = "no"
removeRuneCharges = "no"
whiteSkullTime = 1 * 60 * 1000
noDamageToSameLookfeet = "no"
showHealingDamage = "yes"
showHealingDamageForMonsters = "yes"
fieldOwnershipDuration = 5 * 1000
stopAttackingAtExit = "no"
oldConditionAccuracy = "no"
loginProtectionPeriod = 10 * 1000
deathLostPercent = 10
stairhopDelay = 2 * 1000
pushCreatureDelay = 2 * 1000
deathContainerId = 1987
gainExperienceColor = 215
addManaSpentInPvPZone = "yes"
squareColor = 0
allowFightback = "yes"

-- Connection config
worldId = 0
ip = "krudaserver.sytes.net"
bindOnlyConfiguredIpAddress = "no"
loginPort = 7171
gamePort = 7172
adminPort = 7171
statusPort = 7171
loginTries = 10
retryTimeout = 5 * 1000
loginTimeout = 60 * 1000
maxPlayers = 1000
motd = "Bienvenido a Kruda [Version 9.8]!"
displayOnOrOffAtCharlist = "no"
onePlayerOnlinePerAccount = "yes"
allowClones = "yes"
serverName = "Kruda [9.8]"
loginMessage = "Bienvenido a Kruda [Version 9.8]!"
statusTimeout = 5 * 60 * 1000
replaceKickOnLogin = "yes"
forceSlowConnectionsToDisconnect = "no"
loginOnlyWithLoginServer = "no"
premiumPlayerSkipWaitList = "no"

-- Database
sqlType = "mysql"
sqlHost = "localhost"
sqlPort = 3306
sqlUser = "root"
sqlPass = "xb3XX2dtz"
sqlDatabase = "kruda98"
sqlFile = "schemas/otxserver.s3db"
sqlKeepAlive = 0
mysqlReadTimeout = 10
mysqlWriteTimeout = 10
passwordType = "plain"

-- Deathlist
deathListEnabled = "yes"
deathListRequiredTime = 1 * 60 * 1000
deathAssistCount = 19
maxDeathRecords = 5

-- Guilds
ingameGuildManagement = "no"
levelToFormGuild = 50
premiumDaysToFormGuild = 0
guildNameMinLength = 4
guildNameMaxLength = 20

-- Highscores
highscoreDisplayPlayers = 15
updateHighscoresAfterMinutes = 60

-- Houses
buyableAndSellableHouses = "yes"
houseNeedPremium = "yes"
bedsRequirePremium = "yes"
levelToBuyHouse = 50
housesPerAccount = 0
houseRentAsPrice = "no"
housePriceAsRent = "no"
housePriceEachSquare = 1000
houseRentPeriod = "never"
guildHalls = "no"

-- Item usage
timeBetweenActions = 200
timeBetweenExActions = 1000
checkCorpseOwner = "yes"
hotkeyAimbotEnabled = "yes"
maximumDoorLevel = 500

-- Map
mapName = "realglobal.otbm"
mapAuthor = "leonardo"
randomizeTiles = "yes"
useHouseDataStorage = "no"
storeTrash = "yes"
cleanProtectedZones = "yes"
mailboxDisabledTowns = "-1"

-- Startup
defaultPriority = "high"
niceLevel = 5
coresUsed = "-1"
optimizeDatabaseAtStartup = "yes"
removePremiumOnInit = "yes"
confirmOutdatedVersion = "no"

-- Muted buffer
maxMessageBuffer = 4
bufferMutedOnSpellFailure = "no"

-- Miscellaneous
dataDirectory = "data/"
allowChangeOutfit = "yes"
allowChangeColors = "yes"
allowChangeAddons = "yes"
disableOutfitsForPrivilegedPlayers = "no"
bankSystem = "yes"
saveGlobalStorage = "yes"
displaySkillLevelOnAdvance = "yes"
spellNameInsteadOfWords = "yes"
emoteSpells = "yes"
promptExceptionTracerErrorBox = "yes"
storePlayerDirection = "no"
monsterLootMessage = 3
monsterLootMessageType = 25

-- Ghost mode
ghostModeInvisibleEffect = "yes"
ghostModeSpellEffects = "yes"

-- Limits
idleWarningTime = 58 * 60 * 1000
idleKickTime = 59 * 60 * 1000
expireReportsAfterReads = 1
playerQueryDeepness = 2
maxItemsPerPZTile = 0
maxItemsPerHouseTile = 0

-- Premium-related
freePremium = "yes"
premiumForPromotion = "yes"

-- Blessings
blessingsOnlyPremium = "yes"
blessingReductionBase = 30
blessingReductionDecreament = 5
eachBlessReduction = 8

-- Rates
experienceStages = "yes"
rateExperience = 50
rateExperienceFromPlayers = 0
rateSkill = 15
rateMagic = 5
rateLoot = 2.0
rateSpawn = 1

-- Experience from players
minLevelThresholdForKilledPlayer = 0.9
maxLevelThresholdForKilledPlayer = 1.1

-- Stamina
rateStaminaLoss = 1
rateStaminaGain = 1000 / 3
rateStaminaThresholdGain = 4
staminaRatingLimitTop = 41 * 60
staminaRatingLimitBottom = 14 * 60
rateStaminaAboveNormal = 1.5
rateStaminaUnderNormal = 0.5
staminaThresholdOnlyPremium = "yes"

-- Party
experienceShareRadiusX = 30
experienceShareRadiusY = 30
experienceShareRadiusZ = 1
experienceShareLevelDifference = 2 / 3
extraPartyExperienceLimit = 20
extraPartyExperiencePercent = 5
experienceShareActivity = 2 * 60 * 1000

-- Global save
globalSaveEnabled = "no"
globalSaveHour = 8
shutdownAtGlobalSave = "yes"
cleanMapAtGlobalSave = "no"

-- Spawns
deSpawnRange = 2
deSpawnRadius = 50

-- Summons
maxPlayerSummons = 3
teleportAllSummons = "no"
teleportPlayerSummons = "no"

-- Status
ownerName = "Leonardo"
ownerEmail = "[email protected]"
url = "http://kruda.servegame.com"
location = "Mexico"
displayGamemastersWithOnlineCommand = "no"

-- Logs
adminLogsEnabled = "no"
displayPlayersLogging = "yes"
prefixChannelLogs = ""
runFile = ""
outLogName = ""
errorLogName = ""
truncateLogsOnStartup = "no"

Please help me is urgent! Thanks!

 

[nowik]

you have the same password to the database for sites ots?

 

[lsenturion]

Yes, it's Same , But I dont know what is the problem D:

 

[lsenturion]

Please, Help Me!

Is urgent

@Bring Up My Post!

 

[dominique120]

Use 127.0.0.1 instead of localhost.

sqlHost = "127.0.0.1"

And use a later version of OTX, 2.7 is the last(at least it was the last time I visited their forums)

 

[Snavy]

Try 127.0.0.1 instead of Localhost -- like @dominique120 said...
and delete all COmments
_____________________________________
-- The Forgotten Server Config

-- Account manager_____________________

 

[dominique120]

There is no need to delete comments.

 

[lsenturion]

@up - Nothing it´s not works.


@Bring Up My Post!

Help me please

 

[Liuciferis]

Try to set it to your IP instead and see if it works.

 

[lsenturion]

I don´t understand!

 

[Liuciferis]

sqlHost = "your static ip"

 

[Imfreezing]

you have the exact same database name as in your config? case sensetivite

 

[Imfreezing]

sqlFile = "schemas/otxserver.s3db"

if youre using mysql, you shoud use the file mysql.sql