手工稀有手游新征途
本帖最后由 bfdz49 于 2021-2-12 17:36 编辑这个版本我修复了不少 我没有服务器 架不成功 有人架成功 发出来我来修复
操作系统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、编译安装boost
#tar -zxvf boost_1_49_0.tar.gz
#cd boost_1_49_0
#./bootstrap.sh
#./b2 installMYSQL5.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_PREFIXmysql的安装路径
-DDEFAULT_CHARSET字符集
-DMYSQL_DATADIR 数据的保存路径
-DMYSQL_TCP_PORT 端口
# make&& make install
# cd /usr/local/mysql/
# ls
bin datainclude libmysql-testscriptssql-bench
COPYINGdocsINSTALL-BINARYmanREADME 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
在后面加两行
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
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>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 selecton *.* to chinatot@"%" identified by 'XXXXXXXXX';
mysql> flush privileges;
mysql> exit链接:https://pan.baidu.com/s/1LPm-FN-FqXW-uPOE78yTWw
提取码:1uw8
复制这段内容后打开百度网盘手机App,操作更方便哦--来自百度网盘超级会员V2的分享 66666666666666666666666 感谢大佬分享 帮顶 谢谢大佬分享,虽然耍不了 必须要顶 卧槽,这个就很强 除了支持!还是支持!!!!! 感谢分享!! 卧槽,这个就很强,除了支持!还是支持!!!!! 卧槽,这个就很强,除了支持!还是支持!!!!! 谢谢分享~~~~~~~~~~~~~~~ 感谢大佬分享 感谢大佬分享 不管你信不信,反正我是信了。 吓我一跳~!!!用宝塔不知道行不行~!!!: 绝对疯子 发表于 2021-2-14 21:37
吓我一跳~!!!用宝塔不知道行不行~!!!
好久不见 td act 感谢发布资源。 除了支持!还是支持!!!!! 手工稀有手游新征途
页:
[1]
2