Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Update DB

Newbie Spellweaver
Joined
Jan 17, 2007
Messages
51
Reaction score
0
Hi all can someone explain me how to updatemy DB now I have the 3010 Full
I fI use the DB update it says it can't connect to the root@localhost (using pasword: YES)
 
Last edited:
Banned
Banned
Joined
Oct 20, 2006
Messages
3,243
Reaction score
1,652
Maybe nobody is "helping" you because you're so impatient! You PMed me twice in about 15 minutes. Maybe if you try setting up your MySQL properly, it will work. There's a reason it's saying:
can't connect to the root@localhost (using pasword: YES)
... Double check and make sure you set the right username and password, or, just copy the contents of your conf files and post them here, and I'll tell you what you did wrong.
P.S. In future, try to be a bit more patient. If you PM someone and they don't answer, it means they are either busy, they're not there, or they just don't wanna help (it just so happens I was very busy).
 
Newbie Spellweaver
Joined
Jan 17, 2007
Messages
51
Reaction score
0
Lol i Pmed you 2 times in a hour :p

Code:
# MaNGOS Configuration file
ConfVersion=2006082301

# RealmID must match the realmlist
RealmID = 1

# 0 NORMAL 1 PVP 4 NORMAL 6 RP 8 RPPVP
GameType = 1

# Data directory setting.
# Important: DataDir needs to be quoted, as it is a string which may
# contain space characters.
DataDir = "./Data"

# Database connection settings for the world server.
# Default: hostname;port;username;password;database
LoginDatabaseInfo = "127.0.0.1;3306;root;pass;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;pass;mangos"

# Settings for maximum database-ping interval (minutes between pings)
MaxPingTime = 30

# Server console level of logging
# 0 = Minimum; 1 = Basic&Error; 2 = Detail; 3 = Full/Debug
# Default: 0
# recommend: 1
LogLevel = 3

# Logfile name
#    empty name disable creating log file: LogFile = 
# Default: ""
LogFile = "Server.log"

# Server file level of logging
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 0
LogFileLevel = 0

# Packet logging for the worldserver
# Default: 0 (false)
#          1 (true)
LogWorld = 1

# Log filters
# 0 (default) - include in log if log level permit, 1 - not include with any log level
LogFilter_TransportMoves = 0
LogFilter_CreatureMoves = 0


# Color for messages (format "normal_color details_color debug_color error_color)
# Colors: 0 - BLACK, 1 - RED, 2 - GREEN,  3 - BROWN, 4 - BLUE, 5 - MAGENTA, 6 -  CYAN, 7 - GREY, 
#         8 - YELLOW, 9 - LRED, 10 - LGREEN, 11 - LBLUE, 12 - LMAGENTA, 13 - LCYAN, 14 - WHITE
# Default: "" - none colors
#          "13 7 11 9" - for example :)
LogColors = ""

# Log file of DB errors detected at server run.
# Default: ""
DBErrorLogFile = "DBErrors.log"

# Log file of gm commands
# Default: "" (Disable)
GmLogFile = ""

# Used processors mask for multi-processors system (Used only at Windows)
# Default: 0 (selected by OS)
#          number (bitmask value of selected processors)
UseProcessors = 0

# Process proirity setting (Used only at Windows)
#          0 (Normal)
# Default: 1 (HIGH)
ProcessPriority = 1

# Compression level for update packages sended to client (1..9)
# Default: 1 (speed) 
#          9 (best compression) 
Compression = 1


# Maximum number of players in the world. Excluding GM's
# Default: 100
PlayerLimit = 100

# Max level that can reached by player for expirience (in range from 1 to 255).
# Change not recommended
# Default: 60
MaxPlayerLevel = 60

# Ignore level requirement to enter instance
# 	   1 (true)
# Default: 0 (false)
IgnoreATLevelRequirement = 0

# Max count that player can learn the primary trade skill.
# Default: 2
# Max : 9 
MaxPrimaryTradeSkill = 2 

# Min signatures count to creating guild (0..9).
# Default: 9
MinPetitionSigns = 9 

# Max distance to creature for group memeber to get XP at creature death.
# Default: 74
MaxGroupXPDistance = 74

# Max level different with creature for group member to get XP at creature death.
# Default: 10
MaxGroupXPLevelDiff = 10

# Allow or not accounts to create characters in the 2 teams in any game type.
# Defaullt: 0 (Not allowed)
#           1 (Allowed)
AllowTwoSide.Accounts = 0

# Allow or not common :chat(say,yell);channel(chat)group(join)guild(join);trade for players from different teams.
# Defaullt: 0 (Not allowed)
#           1 (Allowed)
AllowTwoSide.Interaction = 0

# Allow or not show player from both team in who list.
# Defaullt: 0 (Not allowed)
#           1 (Allowed)
AllowTwoSide.WhoList = 0

# Is GM accept whispers from player by default.
# Default: 0 (false)
#          1 (true) 
GM.WhisperingTo = 0


# Is GM showed in GM list (if visible) in non-GM state (.gmoff)
# Default: 0 (false)
#          1 (true) 
GM.InGMList = 0

# Is GM showed in who list (if visible).
# Default: 0 (false)
#          1 (true) 
GM.InWhoList = 0

# GM mode at login
#          0 (disable)
#          1 (enable) 
# Default: 2 (last save state)
GM.LoginState = 2

# Include GM trade and trade slot enchanting operations in GM log if it enable
#          0 (not include)
# Default: 1 (include)
GM.LogTrade = 1

# Group visibility modes
# Default: 0 (standard setting: only members from same group can 100% auto detect invisible player)
#          1 (raid members 100% auto detect invisible player from same raid)
#          2 (players from same team can 100% auto detect invisible player)
GroupVisibility = 0

# Message of the Day. Displayed at worldlogin for every user.
Motd = "Welcome to the Massive Network Game Object Server."

# Health and power regeneration.
Rate.Health = 1;
Rate.Power1 = 1;
Rate.Power2 = 1;
Rate.Power3 = 1;

# Drop rates
# Default: 1
Rate.Drop.Items = 1000000
Rate.Drop.Money = 1000000

# XP rates
# Default: 1
Rate.XP.Kill    = 1000000
Rate.XP.Quest   = 1000000
Rate.XP.Explore = 1000000

# Creature Damage Rate.
# Examples: 2 - creatures will damage 2x, 1.7 - 1.7x.
Rate.Creature.Normal.Damage = 1
Rate.Creature.Elite.Elite.Damage = 1
Rate.Creature.Elite.RAREELITE.Damage = 1
Rate.Creature.Elite.WORLDBOSS.Damage = 1
Rate.Creature.Elite.RARE.Damage = 1

# Creature Health Ammount Modifier.
# Examples: 2 - creatures have 2x health, 1.7 - 1.7x.
Rate.Creature.Normal.HP = 1
Rate.Creature.Elite.Elite.HP = 1
Rate.Creature.Elite.RAREELITE.HP = 1
Rate.Creature.Elite.WORLDBOSS.HP = 1
Rate.Creature.Elite.RARE.HP = 1


# Resting points grow rates (1 - normal, 2 - double rate, 0.5 - half rate, etc) from standart values
Rate.Rest.InGame = 1
Rate.Rest.Offline.InTavernOrCity = 1
Rate.Rest.Offline.InWilderness = 1

# Skill chance values (0..100) 
# default: 100-75-25-0
SkillChance.Orange = 100
SkillChance.Yellow = 75
SkillChance.Green  = 25
SkillChance.Grey   = 0

#Aggro radius percent or off.
#          0   - off (0%)
# Default: 1   - 100% 
#          1.5 - 150%
Rate.Creature.Aggro = 1

# Default remote console port
Ra.Port = 3443

# Log remote console connections
Ra.Log = 1

# Minimum level that's required to login,3 by default
Ra.MinLevel = 3

# Kick client on wrong pass
Ra.Secure = 1

# Maximum overspeed ping count before player kick (minimum is 2, 0 used for disable check)
# Default: 10
MaxOverspeedPings = 10


# Unload grids (if you have lot memory you can disbale it to speed up player move to new grids second time)
#          0 (not unload grids)
# Default: 1 (unload grids)
GridUnload = 1;


# All times are in milliseconds.

# Default socket select time
SocketSelectTime = 10000

# Default grid clean up delay
GridCleanUpDelay = 300000

# Default map update interval
MapUpdateInterval = 100

# Default weather update interval
ChangeWeatherInterval = 600000

# Default PlayerSaveInterval
PlayerSaveInterval = 900000

# Default WorldServerPort
WorldServerPort = 8085


# Beep at mangosd start finished (mostly work only at Unix/Linux systems)
# Default: 1 
BeepAtStart = 1

Realmd
Code:
# MaNGOS realmd configuration file
ConfVersion=2006060401

# Database connection settings for the realm server.
# Default: hostname;port;username;password;database
LoginDatabaseInfo = "127.0.0.1;3306;root;pass;realmd"

# Settings for maximum database-ping interval (minutes between pings)
MaxPingTime = 30

# Default RealmServerPort
RealmServerPort = 3724

# Server console level of logging
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 0
LogLevel = 0

# Logfile name 
#    empty name disable creating log file: LogFile = 
# Default: "Server.log" - not recommended.
LogFile = "Realmd.log"

# Server file level of logging
# 0 = Minimum; 1 = Error; 2 = Detail; 3 = Full/Debug
# Default: 0
LogFileLevel = 0

# Color for messages (format "normal_color details_color debug_color error_color)
# Colors: 0 - BLACK, 1 - RED, 2 - GREEN,  3 - BROWN, 4 - BLUE, 5 - MAGENTA, 6 -  CYAN, 7 - GREY, 
#         8 - YELLOW, 9 - LRED, 10 - LGREEN, 11 - LBLUE, 12 - LMAGENTA, 13 - LCYAN, 14 - WHITE
# Default: "" - none colors
#          "13 7 11 9" - for example :)
LogColors = ""

# Used processors mask for multi-processors system (Used only at Windows)
# Default: 0 (selected by OS)
#          number (bitmask value of selected processors)
UseProcessors = 0

# Process proirity setting (Used only at Windows)
#          0 (Normal)
# Default: 1 (HIGH)
ProcessPriority = 1
 
Banned
Banned
Joined
Oct 20, 2006
Messages
3,243
Reaction score
1,652
What username and pass did you set when you installed MySQL? Well, whatever username you set, replace these red words with it:
LoginDatabaseInfo = "127.0.0.1;3306;root;pass;realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;pass;mangos"
and replace the blue words with the password you specified when installing MySQL
 
Newbie Spellweaver
Joined
Jan 17, 2007
Messages
51
Reaction score
0
thats what I did I can run my server play on it and everything the only reason is I want to know how to update my DB :p
 
Skilled Illusionist
Joined
Oct 1, 2005
Messages
387
Reaction score
0
heheh always the same problems that you guys can find in the tutorials ,,

"Tip"
next time save a tutorials adres in your fafo's folder
 
Back
Top