今天有人把乌云的知识库共享出来了,十分感谢贡献者。
于是本人想把这套程序搭建服务器上
我的服务器是ubuntu,乌云的知识库数据库大小是600多M
因此要先安装个mysql
语法如下
sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install libmysqlclient-dev
==========创建用户==========
CREATE DATABASE wooyun DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE DATABASE edutest DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'wooyun'@'localhost' IDENTIFIED BY '123123'; #创建用户
CREATE USER 'edutest'@'localhost' IDENTIFIED BY '123123'; #创建用户
GRANT SELECT ON wooyun.* TO 'wooyun'@'%'; # 赋予权限
GRANT SELECT ON edutest.* TO 'edutest'@'%'; # 赋予权限
GRANT ALL ON *.* TO 'wooyun'@'%';
========================
CREATE DATABASE xsstv DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'xsstv'@'localhost' IDENTIFIED BY 'baobei'; #创建用户
GRANT All ON xsstv* TO 'xsstv'@'%'; # 赋予权限
==========后续==========
坑比的遇到各种问题
mysql_connect()此函数在php5.5中未找到函数的错误问题没有解决
最后干脆换血,全部换成mysqli_connect()函数替换的函数如下
mysqli_connect("localhost","root","root","wooyun") ;
mysqli_query($conn,"SET NAMES 'UTF8'");
mysqli_fetch_array()
mysqli_num_rows
mysqli_close($conn)
http://www.bihuo.cn 必火安全学院
|