也想出現在這里？點擊聯系我~

征途手工架設服務端+配套雙客戶端+架設流程

1、操作系統為Centos6.3_64位，需要安裝的包：
lua-5.1.5
cmake-2.8.7
mysql-5.5.23
mysql++-3.1.0
boost_1_49_0

tar -xzvf lua-5.1.5.tar.gz
cd lua-5.1.5

然后執行make，會提示讓你輸入make 系統，因為我的系統是linux的，因此輸入make linux
2、編譯安裝boost
#tar -zxvf boost_1_49_0.tar.gz
#cd boost_1_49_0
#./bootstrap.sh
#./b2 install

3、MYSQL5.5安裝詳細步驟：
#tar zxvf cmake-2.8.7.tar.gz -C /usr/local/src/
#tar zxvf mysql-5.5.23.tar.gz -C /usr/local/src/

# cd /usr/local/src/cmake-2.8.7/
# ./configure
# gmake && make install

# cd ../mysql-5.5.23/
# mkdir -p /data/mysql
存放mysql的數據文件的

# useradd -u 27 -d /data/mysql/ -s /sbin/nologin mysql

# id mysql
uid=27(mysql) gid=27(mysql) groups=27(mysql)
# chown -R mysql:mysql /data/mysql/

# ls -ld /data/mysql/
drwxr-xr-x 2 mysql mysql 4096 07-11 03:56 /data/mysql/

# yum install -y ncurses-devel
# rm -f CMakeCache.txt （如果后來用yum安裝的ncurses-devel要執行這步操作，在進行下一步）
# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/data/mysql/ -DWITH_EXTRA_CHARSETS=all -DWITH_READLINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1??-DMYSQL_TCP_PORT=3306 -DDEFAULT_COLLATION=utf8_general_ci
上面這條超長命令必須在mysql-5.5.11目錄中執行！！！
-DCMAKE_INSTALL_PREFIX??mysql的安裝路徑
-DDEFAULT_CHARSET??字符集
-DMYSQL_DATADIR? ?? ?? ?? ?數據的保存路徑
-DMYSQL_TCP_PORT? ?端口

# make&& make install

# cd /usr/local/mysql/
# ls
bin? ?? ?data??include? ?? ?? ?lib??mysql-test??scripts??sql-bench
COPYING??docs??INSTALL-BINARY??man??README? ?? ?share? ? support-files

# cd support-files/

# cp my-medium.cnf /etc/my.cnf
生成mysql的配置文件

# pwd
/usr/local/mysql
# cd scripts/
# ls
mysql_install_db

# vim /etc/my.conf
在[mysqld]后面加兩行

skip-name-resolve

innodb_flush_log_at_trx_commit = 2

初始化數據庫：
# ./mysql_install_db –user=mysql –basedir=/usr/local/mysql/ –datadir=/data/mysql/
Installing MySQL system tables…
OK
Filling help tables…
OK

# vim /etc/my.cnf
[mysqld]
datadir? ?? ?? ?= /data/mysql 添加，指定數據的保存位置
# pwd
/usr/local/mysql/support-files
# cp mysql.server /etc/init.d/mysqld
復制mysql的啟動腳本

# /etc/init.d/mysqld start

# pwd
/usr/local/mysql/bin

# ./mysql
mysql>

# vim /etc/profile
export PATH=/usr/local/mysql/bin:$PATH 添加

# . /etc/profile

啟動mysql：
/etc/init.d/mysqld start
chkconfig –add mysqld
chkconfig mysqld on

# mysql
mysql>

9、mysql++安裝
tar -zxvf mysql++-3.1.0.tar.gz

cd mysql++-3.1.0
./configure
make
make install

# pwd

/root/mysql++-3.1.0

#vim ssx/genv2.cpp??根據報錯在這個文件中找到相應位置添加最下面那條命令

#include <iostream>

#include <fstream>

#include <typeinfo>

#include <string.h>

程序啟動報錯解決：
ln -s /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib/

mysql> select user,host,password from mysql.user;查看用戶信息

+——+————+——————————————-+

| user | host? ?? ? | password? ?? ?? ?? ? |

+——+————+——————————————-+

| root | localhost??|? ?? ?? ?? ?? ?? ?|

| root | 10-6-3-176 |??|

| root | 127.0.0.1??|? ?? ?? ?? ?? ?? ?? ? |

| root | %? ?? ???|??|

+——+————+——————————————-+

4 rows in set (0.00 sec)

mysql> set password for root@localhost=password(‘XXXXXXX’);設置root密碼

mysql> set password for root@’10-6-6-23’=password(‘XXXXXXXX’);

mysql> grant all on *.* to root@”%” identified by ‘XXXXXXXX’;授權

mysql> select user,host,password from mysql.user;

+——+————+——————————————-+

| user | host? ?? ? | password? ?? ?? ?? ?? ?? ???|

+——+————+——————————————-+

| root | localhost | *C07583ABFCBBCC5D64C9469E28D4861951C5024A |

| root | 10-6-3-176 | *C07583ABFCBBCC5D64C9469E28D4861951C5024A |

| root | 127.0.0.1 |? ?? ?? ?? ?? ?? ?? ?? ?? ?? ?|

| root | %? ?? ?| *4F048907E92401E909B60D4C90426C4D3AEB499D |

+——+————+——————————————-+

4 rows in set (0.00 sec)

mysql> delete from mysql.user where user=”;刪除匿名用戶

mysql> grant select on uctot.* to 小用戶@’%’ identified by “XXXXXXXX”;授權

mysql> show grants for root@”%”;查看用戶有那些權限

mysql>??grant select??on *.* to chinatot@”%” identified by ‘XXXXXXXXX’;

mysql> flush privileges;

mysql> exit