- 2017/06/08
- |
- 技术随笔
- |
- 0 Replies
查看计划事件是否开启
SHOW VARIABLES LIKE 'event_scheduler'
开启计划事件
vim /etc/my.cnf
// [myslqd] 节点添加
event_scheduler = 1
- 2017/05/28
- |
- 技术随笔
- |
- 0 Replies
打开网站的 .conf 文件 server 段
#error_page 404 /404.html;
#error_page 502 /502.html;
# 添加下面一段
location ~ [^/]\.php(/?.*)$ {
fastcgi_split_path_info ^(.+?\.php)(/.+)$;
fastcgi_pass unix:/dev/shm/php-cgi.sock;
fastcgi_index index.php;
include fastcgi.conf;
}
location ~ [^/]\.p...
- 2017/05/25
- |
- 技术随笔
- |
- 0 Replies
正确做法：Typecho在Tengine下pathinfo的问题(/index.php/xxx/)
下方做法会导致此安全隐患：Nginx + PHP CGI的一个可能的安全漏洞
修改PHP配置
vim /usr/local/php/etc/php.ini
cgi.fix_pathinfo=1
重启服务
service php-fpm restart
service nginx restart
https://askubuntu.com/questions/164627/nginx-php-fpm-access-denied-error
- 2017/05/07
- |
- 技术随笔
- |
- 0 Replies
授权用户远程访问数据库
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
授权用户远程访问数据库（带管理权限）
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password'WITH GRANT OPTION;
FLUSH PRIVILEGES;
取消授权
REVOKE ALL ON *.* FROM 'root'@'%';
FLUSH PRIVILEGES;
- 2017/04/06
- |
- 技术随笔
- |
- 0 Replies
禁用mysql权限表
vi /etc/my.cnf
添加如下一行
skip-grant-tables
重启mysql
service mysql restart
进入mysql修改密码
mysql -u root -p
mysql> USE mysql;
mysql> UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPass') WHERE User = 'root' AND Host = 'localhost';
mysql> FLUSH PRIVILEGES;
mysql> quit
...
- 2017/04/05
- |
- 技术随笔
- |
- 0 Replies
更新系统软件
yum update
安装编译工具
yum install gcc automake autoconf libtool gcc-c++
安装服务端程序（二选一）
(a) nginx
安装nginx源
yum localinstall http://nginx.org/packages/centos/7/noarch/RPMS/nginx-release-centos-7-0.el7.ngx.noarch.rpm
安装nginx
yum install nginx
启动nginx
service nginx start
成功显示: Redirecting to /bin...
- «
- 1
- 2
- 3
- 4
- 5
- »