传说成3Linux详细配置教程

DATABASE = khan3
option = 0
执行odbcinst -s -q命令使其ODBC的设置生效
odbcinst -s -q
-------------------------------------------------------------------------------------
make
make install
3、添加用户，安装数据库
cd /usr/local/mysql/
groupadd mysql mysql用户
useradd -g mysql mysql mysql组
chown -R mysql:mysql ./ 给予权限
系统在/usr/bin下面查此命令,所以找不到了 ，做个链接即可
然后就可以使用这个登录了
mysql -uroot -p
========================================================================
mysql>use mysql; 使用mysql数据库。
mysql>update er set password=password('123456') where user='root'; 设置root新密码
上传到/home目录安装，安装命令rpm -ihv --force --nodeps *.rpm；
rpm -ihv --force --nodeps mysql-connector-odbc-3.51.27-0.x86_64.rpm
rpm -ihv --force --nodeps unixODBC-2.2.11-1.RHEL4.1.x86_64.rpm
chkconfig --add mysqld
chkconfig --level 2345 mysqld on
#之后可以用service mysqld start启动，开机会自动启动
ln -s /usr/local/mysql/bin/mysql /usr/bin （因为mysql命令的路径在/usr/local/mysql/bin下面,所以你直接使用mysql命令时,
tar -zxvf mysql-5.1.73.tar.gz
mv mysql-5.1.73 mysql ------------------>(重新命名文件夹命令)
cd /home/mysql
2、编译
./configure --prefix=/usr/local/mysql --enable-assembler --with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-extra-charsets=gb2312,gbk,utf8,latin1 --without-debug --with-charset=utf8 --with-collation=utf8_general_ci --with-pthread --enable-static --enable-thread-safe-client
mysql>delete from er where user=''; 删除空账户
mysql>flush privileges; 刷新权限表
mysql>quit 退出mysql
#安装数据库，添加默认mysql配置
./bin/mysql_install_db --user=mysql
cp share/mysql/f /etc/f
#下面我们来设置开机启动mysql
cp share/mysql/mysql.server /etc/init.d/mysqld
=======================================================
7.上传，安装rpm包
mysql-connector-odbc-3.51.27-0.x86_64.rpm
unixODBC-2.2.11-1.RHEL4.1.x86_64.rpm
cd /home/khan/GL/Server
./DBShare &
cd /home/khan/GL/Server
./GLServer &
-----------------------------------------------------------
cd /home/khan/Map1/Server
4.修改mysql密码
[root@localhost ~]# mysql -uroot -p 登陆mysql
Enter password: 输入密码回车
./LoginCenter &
./DBShare &
cd /home/khan/Map1/Server
./MapServer -loadallmap &
-----------------------------------------------------------
cd /home/khan/GL/Server
[root@localhost ~]#service mysqld restart 重起mysql
现在你可以使用新的密码登录mysql了
==============================================================
mysql>GRANT ALL PRIVILEGES ON *.* TO root@"%.%.%.%" IDENTIFIED BY "123456";
mysql>FLUSH PRIVILEGES; #立即生效
mysql>exit
==============================================================
5.MySQL 开启远程连接：
[root@localhost ~]# mysql -uroot -p
Enter password:
mysql>use mysql; update user set Password=PASSWORD('123456') where User='root';
编译安装MySQL
编译环境 gcc gcc-c++ autoconf automake ncurses-devel make chkconfig 装系统的时候记得安装这些
数据库源码 mysql-5.1.73.tar.gz
采上传，解压
cd /home
CREATE DATABASE khan3; 创建游戏数据库
exit
导入游戏数据库结构，然后输入你mysql数据库的密码确认导入数据库
mysql -u root -p khan3 < /home/khan3.sql
Enter password: 输入密码回车确认
=============================================================
6.创建数据库khan3
[root@localhost ~]# mysql -uroot -p 登陆mysql
Enter password: 输入密码回车
8.服务端上传到home 上传游戏lib库
cd /home
tar xzvf khan3.tar.gz 解压
cp libScriptEngine_khan2_64.so /usr/lib64
cp libLua_khan2_64.so /usr/lib64
===================================================
===================================================
启动游戏
cd /home/khan/GL/Server
./DBCenter &
-----------------------------------------------------------
并且吧odbc.ini文件填充内容为
[khan3]
Driver = /usr/lib64/libmyodbc3_r.so
SERVER = 127.0.0.1
USER = root
PASSWORD = 123456 ----->这里改成你的密码
PORT = 3306