怎么架设魔兽世界服务器(魔兽世界开服架设服务器搭建教程)
怎么架设魔兽世界服务器(魔兽世界开服架设服务器搭建教程)(上面3个都是架设服务器用的数据库端和数据库管理端:mySQL4.0.2是数据库主程序,mysql-control center0.9.4是数据库管理界面程序,MyODBC是MySQL与Windows数据服务的连接驱动)MyODBC-standard-3.513、服务器一台(魔兽世界对服务器的配置要求并不是很高,CPU 16核 、16线程 带宽最好是选择50M的,游戏行业难免会被同行或是GJ小组盯上,若是选择的服务器防御低,把服务器干趴下了,会直接影响到服里玩家游戏体验,所以服务器的防御也是很重要的。游戏的整体运行以及玩家的游戏体验感绝大部分都是取决于服务器,有条件的可以对游戏服有要求的小伙伴们可以考虑i9游戏高频系列服务器为游戏而生!)4、MySQL4.0.2(不要用最新的5.0,有问题)mysql-control-center0.9.4
魔兽世界开服架设服务器搭建教程
准备工具:
1、装有windows98/2000/xp/2003系统、内存至少256M的电脑一台
2、魔兽服务器端一个
3、服务器一台(魔兽世界对服务器的配置要求并不是很高,CPU 16核 、16线程 带宽最好是选择50M的,游戏行业难免会被同行或是GJ小组盯上,若是选择的服务器防御低,把服务器干趴下了,会直接影响到服里玩家游戏体验,所以服务器的防御也是很重要的。游戏的整体运行以及玩家的游戏体验感绝大部分都是取决于服务器,有条件的可以对游戏服有要求的小伙伴们可以考虑i9游戏高频系列服务器为游戏而生!)
4、MySQL4.0.2(不要用最新的5.0,有问题)
mysql-control-center0.9.4
MyODBC-standard-3.51
(上面3个都是架设服务器用的数据库端和数据库管理端:mySQL4.0.2是数据库主程序,mysql-control center0.9.4是数据库管理界面程序,MyODBC是MySQL与Windows数据服务的连接驱动)
当然还有WOW eta3客户端和3734(就是0.8.0)补丁
需要的数据库有:
25M的python.sql
7M的python.sql
几个1k左右的commands.sql,creatures_mov.sql,gmlogin.sql, c_text.sql,sh.sql,trainers.sql
1、先安装mysql,mysqlcc,ODBC然后重启
重启后看看右下角的系统托盘里有没有个红绿灯的图标,没有的话运行c:\\mysql\\bin\\winmysqladmin.exe
开始架服务器:
运行 mysqlcc ,新建服务器:
nameytho
host:localhost
user:root
pa word:空
2、确定后双击“ ytho ”,右键点击 DataBase ,新建数据库取名 wow
右击User Administration,新建用户,名字随便,Hose:localhost,密码自己记好
选上All rivileges,右边在Global rivileges和wow上打对勾,应用
再把系统自动添加的@localhost用户的All ....和Glo...,wow上也打上对勾应用
3、不关程序,到控制面板,管理工具,服务:mysql
停止服务,在参数空白行里输入
safe_MySQLd -O key_buffer=16M -O table_cache=128 -O ort_buffer=4M -O record_buffer=1M -O max_allowed_packet=30M
\\. commands.sql
依此类推...
4、 回到mysqlcc,右键点击/Databases/wow,开启新窗口
点击新开窗口上面的SQL按钮,再选择菜单里的文件\\打开...
打开25M的python.sql(加载需要好长时间)然后点击按钮栏里的“!”按钮
看执行成果,没有X的就是成功了,有错误的话删掉wow数据库,从“3.”处重新开始
5、 打开控制面板\\管理工具\\ODBC数据源(不同的操作系统名字可能不同)
选择:系统D ,添加,MySQL ODBC3.51 Driver
Date ource ame:(2.里建立的用户名)
Host/Server ame(or IP):localhost
DataBase ame:wow
User:(2.里建立的用户名)
Pa word:(2.里建立的密码)
6、启用python服务器,但停止wow库
把7M的python.sql和N个1K的.sql文件拷贝到c:\\mysql\\bin\\
运行c:\\mysql\\bin\\mysql.exe
在命令行里输入. ython.sql gt
7、加载完毕后启动wow库,运行wowpython0.89,输入:
host 127.0.0.1(或者你的外网IP或者局域网IP)
lanhost *.*.*.*(你的局域网IP)
d localhost (你刚才“2.”建立的用户名) (你输入的密码) wow
start
出现服务器开始运行的提示后就可以运行游戏了
注意事项:只是想单机玩的host地址随便,lanhost用开始菜单/运行/cmd/ipconfig看到内网地址
想局域网玩的host,lanhost都用内网IP,想架外网服务器的就要知道自己的外网实际IP了
8、自己玩或者局域网内玩游戏,进游戏登陆界面后按“~”打开控制台,输入“realmlist (你在“7.”所输入的内网IP)”使用wow表account项里面的GM账号登陆游戏
OK!架设完毕
高防大带宽IP
43.249.194.1
43.249.194.2
43.249.194.3
43.249.194.4
43.249.194.5
43.249.194.6
43.249.194.7
43.249.194.8
43.249.194.9
43.249.194.10
43.249.194.11
43.249.194.12
43.249.194.13
43.249.194.14
43.249.194.15
43.249.194.16
43.249.194.17
43.249.194.18
43.249.194.19
43.249.194.20
43.249.194.21
43.249.194.22
43.249.194.23
43.249.194.24
43.249.194.25
43.249.194.26
43.249.194.27
43.249.194.28
43.249.194.29
43.249.194.30
43.249.194.31
43.249.194.32
43.249.194.33
43.249.194.34
43.249.194.35
43.249.194.36
43.249.194.37
43.249.194.38
43.249.194.39
43.249.194.40
43.249.194.41
43.249.194.42
43.249.194.43
43.249.194.44
43.249.194.45
43.249.194.46
43.249.194.47
43.249.194.48
43.249.194.49
43.249.194.50
43.249.194.51
43.249.194.52
43.249.194.53
43.249.194.54
43.249.194.55
43.249.194.56
43.249.194.57
43.249.194.58
43.249.194.59
43.249.194.60
43.249.194.61
43.249.194.62
43.249.194.63
43.249.194.64
43.249.194.65
43.249.194.66
43.249.194.67
43.249.194.68
43.249.194.69
43.249.194.70
43.249.194.71
43.249.194.72
43.249.194.73
43.249.194.74
43.249.194.75
43.249.194.76
43.249.194.77
43.249.194.78
43.249.194.79
43.249.194.80
43.249.194.81
43.249.194.82
43.249.194.83
43.249.194.84
43.249.194.85
43.249.194.86
43.249.194.87
43.249.194.88
43.249.194.89
43.249.194.90
43.249.194.91
43.249.194.92
43.249.194.93
43.249.194.94
43.249.194.95
43.249.194.96
43.249.194.97
43.249.194.98
43.249.194.99
43.249.194.100
43.249.194.101
43.249.194.102
43.249.194.103
43.249.194.104
43.249.194.105
43.249.194.106
43.249.194.107
43.249.194.108
43.249.194.109
43.249.194.110
43.249.194.111
43.249.194.112
43.249.194.113
43.249.194.114
43.249.194.115
43.249.194.116
43.249.194.117
43.249.194.118
43.249.194.119
43.249.194.120
43.249.194.121
43.249.194.122
43.249.194.123
43.249.194.124
43.249.194.125
43.249.194.126
43.249.194.127
43.249.194.128
43.249.194.129
43.249.194.130
43.249.194.131
43.249.194.132
43.249.194.133
43.249.194.134
43.249.194.135
43.249.194.136
43.249.194.137
43.249.194.138
43.249.194.139
43.249.194.140
43.249.194.141
43.249.194.142
43.249.194.143
43.249.194.144
43.249.194.145
43.249.194.146
43.249.194.147
43.249.194.148
43.249.194.149
43.249.194.150
43.249.194.151
43.249.194.152
43.249.194.153
43.249.194.154
43.249.194.155
43.249.194.156
43.249.194.157
43.249.194.158
43.249.194.159
43.249.194.160
43.249.194.161
43.249.194.162
43.249.194.163
43.249.194.164
43.249.194.165
43.249.194.166
43.249.194.167
43.249.194.168
43.249.194.169
43.249.194.170
43.249.194.171
43.249.194.172
43.249.194.173
43.249.194.174
43.249.194.175
43.249.194.176
43.249.194.177
43.249.194.178
43.249.194.179
43.249.194.180
43.249.194.181
43.249.194.182
43.249.194.183
43.249.194.184
43.249.194.185
43.249.194.186
43.249.194.187
43.249.194.188
43.249.194.189
43.249.194.190
43.249.194.191
43.249.194.192
43.249.194.193
43.249.194.194
43.249.194.195
43.249.194.196
43.249.194.197
43.249.194.198
43.249.194.199
43.249.194.200
43.249.194.201
43.249.194.202
43.249.194.203
43.249.194.204
43.249.194.205
43.249.194.206
43.249.194.207
43.249.194.208
43.249.194.209
43.249.194.210
43.249.194.211
43.249.194.212
43.249.194.213
43.249.194.214
43.249.194.215
43.249.194.216
43.249.194.217
43.249.194.218
43.249.194.219
43.249.194.220
43.249.194.221
43.249.194.222
43.249.194.223
43.249.194.224
43.249.194.225
43.249.194.226
43.249.194.227
43.249.194.228
43.249.194.229
43.249.194.230
43.249.194.231
43.249.194.232
43.249.194.233
43.249.194.234
43.249.194.235
43.249.194.236
43.249.194.237
43.249.194.238
43.249.194.239
43.249.194.240
43.249.194.241
43.249.194.242
43.249.194.243
43.249.194.244
43.249.194.245
43.249.194.246
43.249.194.247
43.249.194.248
43.249.194.249
43.249.194.250
43.249.194.251
43.249.194.252
43.249.194.253
43.249.194.254
43.249.194.255