• 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 Error 'root'@'localhost' mysql

Victor iago

New Member
Joined
Jul 19, 2016
Messages
1
Reaction score
0
Hello , I have this problem on my 8.60 server, and do not know how to solve someone help me ? I will post my config.lua , thank you!

ERROR >> https://imgur.com/a/blwvo


Code:
ownerName = ""
   ownerEmail = ""
   url = ""
   location = ""

  
   motd = "Olá Querido Player! Sejam Todos Bem Vindos ao OriginServer"
   serverName = "OriginServer"
   loginMessage = "Olá Amigos Players e Colaboradores, Sejam todos Bem vindos Ao OriginServer"
   displayGamemastersWithOnlineCommand = false

   sqlType = "mysql"
   sqlHost = "localhost"
   sqlPort = 3306
   sqlUser = "root"
   sqlPass = "ZHsSaFaa7ecxUety"
   sqlDatabase = "meuot123"
   sqlFile = "meuot123.s3db"
   sqlKeepAlive = 0
   mysqlReadTimeout = 10
   mysqlWriteTimeout = 10
   mysqlReconnectionAttempts = 20
   encryptionType = "sha1"

   worldId = 0
   ip = "127.0.0.1"
   worldType = "open"
   bindOnlyGlobalAddress = false
   loginPort = 7171
   gamePort = "7172"
   statusPort = 7171
   loginOnlyWithLoginServer = false


   accountManager = true
   namelockManager = true
   newPlayerChooseVoc = true
   newPlayerSpawnPosX = 32681
   newPlayerSpawnPosY = 32524
   newPlayerSpawnPosZ = 6
   newPlayerTownId = 1
   newPlayerLevel = 8
   newPlayerMagicLevel = 0
   generateAccountNumber = false
   generateAccountSalt = false

   fragsLimit = 24 * 60 * 60
   fragsSecondLimit = 7 * 24 * 60 * 60
   fragsThirdLimit = 30 * 24 * 60 * 60


   fragsToRedSkull = 60
   fragsSecondToRedSkull = 990
   fragsThirdToRedSkull = 995
   redSkullLength = 50 * 60 * 1000

   fragsToBlackSkull = 90
   fragsSecondToBlackSkull = 1200
   fragsThirdToBlackSkull = 1290
   blackSkulledDeathHealth = 40
   blackSkulledDeathMana = 0
   blackSkullLength = 1 * 24 * 60 * 60
   useBlackSkull [IMG]https://imgur.com/a/blwvo[/IMG] = true

   notationsToBan = 3
   warningsToFinalBan = 4
   warningsToDeletion = 5
   banLength = 7 * 24 * 60 * 60
   killsBanLength = 7 * 24 * 60 * 60
   finalBanLength = 30 * 24 * 60 * 60
   ipBanLength = 1 * 24 * 60 * 60
   fragsToBanishment = 7
   fragsSecondToBanishment = 21
   fragsThirdToBanishment = 41

   protectionLevel = 80
   pvpTileIgnoreLevelAndVocationProtection = true
   allowFightback = true
   pzLocked = 20 * 10 * 100
   huntingDuration = 60 * 300
   criticalHitMultiplier = 1
   displayCriticalHitNotify = false
   removeWeaponAmmunition = false
   removeWeaponCharges = false
   removeRuneCharges = false
   whiteSkullTime = 40 * 10 * 100
   advancedFragList = false
   useFragHandler = true
   noDamageToSameLookfeet = false
   showHealthChange = true
   showManaChange = true
   showHealthChangeForMonsters = true
   showManaChangeForMonsters = true
   fieldOwnershipDuration = 5 * 1000
   stopAttackingAtExit = false
   loginProtectionPeriod = 1 * 1000
   deathLostPercent = 5
   stairhopDelay = 1 * 1000
   pushCreatureDelay = 0.2 * 1000
   deathContainerId = 1987
   gainExperienceColor = 155
   addManaSpentInPvPZone = true
   recoverManaAfterDeathInPvPZone = true
   squareColor = 0
   broadcastBanishments = false
  
useAntiPush = true
antiPushDelay = 445
antiPushItems = "2148,2152,2160,3976"

  
  
   rsaPrime2 = "7630979195970404721891201847792002125535401292779123937207447574596692788513647179235335529307251350570728407373705564708871762033017096809910315212884101"
   rsaPublic = "65537"
   rsaModulus = "109120132967399429278860960508995541528237502902798129123468757937266291492576446330739696001110603907230888610072655818825358503429057592827629436413108566029093628212635953836686562675849720620786279431090218017681061521755056710823876476444260558147179707119674283982419152118103759076030616683978566631413"
   rsaPrivate = "46730330223584118622160180015036832148732986808519344675210555262940258739805766860224610646919605860206328024326703361630109888417839241959507572247284807035235569619173792292786907845791904955103601652822519121908367187885509270025388641700821735345222087940578381210879116823013776808975766851829020659073"

  
       optionalWarAttackableAlly = true
       fistBaseAttack = 7
       criticalHitChance = 7
       noDamageToGuildMates = false
          
       noDamageToPartyMembers = false
          

       rookLevelTo = 5
       rookLevelToLeaveRook = 8
       rookTownId = 1
       useRookSystem = false

      
       paralyzeDelay = 1500

      
       premiumDaysToAddByGui = 1

       useCapacity = true
       defaultDepotSize = 2000
       defaultDepotSizePremium = 2000
       enableProtectionQuestForGM = true
       cleanItemsInMap = false
       playerFollowExhaust = 2000

      

       tibiaClassicSlots = false
       monsterSpawnWalkback = true
       allowBlockSpawn = true

      
       NoShareExpSummonMonster = false

      
       enableLootBagDisplay = false
       advertisingBlock = ".net;servegame;no-ip,.net;.com.br;.com;.org;.pl;.net;.biz;.info"
       gmAnonymousInChanel = 0

       manualVersionConfig = false
       versionMin = 860
       versionMax = 860
       versionMsg = "Only clients with protocol 8.6x allowed!"

  
   loginTries = 10
   retryTimeout = 5 * 1000
   loginTimeout = 60 * 1000
   maxPlayers = 1000
   displayOnOrOffAtCharlist = false
   onePlayerOnlinePerAccount = true
   allowClones = 0
   statusTimeout = 1000
   replaceKickOnLogin = true
   forceSlowConnectionsToDisconnect = false
   premiumPlayerSkipWaitList = true
   packetsPerSecond = 1000
   allowedMaxSizePackets = 100

   deathListEnabled = true
   deathListRequiredTime = 1 * 60 * 1000
   deathAssistCount = 2
   maxDeathRecords = 1
   multipleNames = false

   externalGuildWarsManagement = false
   ingameGuildManagement = false
   levelToFormGuild = 600
   premiumDaysToFormGuild = 0
   guildNameMinLength = 4
   guildNameMaxLength = 20


   buyableAndSellableHouses = true
   houseNeedPremium = false
   bedsRequirePremium = false
   levelToBuyHouse = 200
   housesPerAccount = 1
   houseRentAsPrice = false
   housePriceAsRent = false
   housePriceEachSquare = 50000
   houseRentPeriod = "weekly"
   houseCleanOld = 7 * 24 * 60 * 60
   guildHalls = true
   houseSkipInitialRent = true
   houseProtection = true

  
   timeBetweenActions = 200
   timeBetweenExActions = 1000
   timeBetweenCustomActions = 500
   checkCorpseOwner = true
   hotkeyAimbotEnabled = true
   maximumDoorLevel = 1999
   tradeLimit = 100
   canOnlyRopePlayers = false

   mapAuthor = "Igor Souza"
   randomizeTiles = true
   houseDataStorage = "binary-tilebased"
   storeTrash = true
   cleanProtectedZones = true
   mapName = "IceWars.otbm"

  
   mailMaxAttempts = 5
   mailBlockPeriod = 30 * 60 * 1000
   mailAttemptsFadeTime = 5 * 60 * 1000
   mailboxDisabledTowns = ""
      

   daemonize = false
   defaultPriority = "higher"
   niceLevel = 3
   serviceThreads = 1
   coresUsed = "-1"
   startupDatabaseOptimization = true
   removePremiumOnInit = true
   confirmOutdatedVersion = false
   skipItemsVersionCheck = true

  
   maxMessageBuffer = 4

  
   dataDirectory = "data/"
   logsDirectory = "data/logs/"
   disableOutfitsForPrivilegedPlayers = false
   bankSystem = true
   spellNameInsteadOfWords = false
   emoteSpells = true
   unifiedSpells = true
   promptExceptionTracerErrorBox = true
   storePlayerDirection = false
   savePlayerData = true
   monsterLootMessage = 3
   monsterLootMessageType = 25
   separateViplistPerCharacter = false
   vipListDefaultLimit = 20
   vipListDefaultPremiumLimit = 100


   allowChangeOutfit = true
   allowChangeColors = true
   allowChangeAddons = true
   addonsOnlyPremium = false


   ghostModeInvisibleEffect = true
   ghostModeSpellEffects = true


   idleWarningTime = 14 * 60 * 1000
   idleKickTime = 15 * 60 * 1000
   expireReportsAfterReads = 1
   playerQueryDeepness = -1
   protectionTileLimit = 10
   houseTileLimit = 10
   tileLimit = 10

  
   freePremium = true
   premiumForPromotion = true
   updatePremiumStateAtStartup = true

  
   blessings = true
   blessingOnlyPremium = false
   blessingReductionBase = 30
   blessingReductionDecrement = 5
   eachBlessReduction = 8
   useFairfightReduction = true
   pvpBlessingThreshold = 40
   fairFightTimeRange = 60

  
   experienceStages = true
   rateExperience = 100
   rateExperienceFromPlayers = 0
   rateSkill = 25
   rateMagic = 9
   rateLoot = 7
   rateSpawn = 2
   rateSpawnMin = 1
   rateSpawnMax = 1
   formulaLevel = 3.0
   formulaMagic = 1.0
      
       rateMonsterHealth = 1.0
       rateMonsterMana = 1.0
       rateMonsterAttack = 1.0
       rateMonsterDefense = 1.3

  
   minLevelThresholdForKilledPlayer = 0.9
   maxLevelThresholdForKilledPlayer = 1.1

  
   rateStaminaLoss = 1
   rateStaminaGain = 6
   rateStaminaThresholdGain = 12
   staminaRatingLimitTop = 40 * 60
   staminaRatingLimitBottom = 14 * 60
   staminaLootLimit = 14 * 60
   rateStaminaAboveNormal = 1.2
   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 = 5
   globalSaveMinute = 0
   shutdownAtGlobalSave = false
   cleanMapAtGlobalSave = false
   closeInstanceOnShutdown = true

  
   minRateSpawn = 1
   maxRateSpawn = 3
   deSpawnRange = 2
   deSpawnRadius = 50

   maxPlayerSummons = 1
   teleportAllSummons = false
   teleportPlayerSummons = true

   disableLuaErrors = false
   adminLogs = false
   displayPlayersLogging = false
   prefixChannelLogs = ""
   runFile = "server/run.log"
   outputLog = "server/out.log"
   truncateLogOnStartup = true
   logPlayersStatements = false

   managerPort = 7171
   managerLogs = true
   managerPassword = ""
   managerLocalhostOnly = true
   managerConnectionsLimit = 1

  
   adminPort = 7171
   adminPassword = ""
   adminLocalhostOnly = true
   adminConnectionsLimit = 1
   adminRequireLogin = true
   adminEncryption = ""
   adminEncryptionData = ""

   saveGlobalStorage = false
   bufferMutedOnSpellFailure = false
 
Last edited by a moderator:
Back
Top