魔兽世界开服架设服务器搭建教程

魔兽世界开服架设服务器搭建教程

准备工具：

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