debian下的各配置文件:
nginx:使用查看配置路径命令:nginx -t 用户配置文件:/etc/nginx/sites-enabled/default
php-fpm网站配置文件路径:/etc/php5/fpm/pool.d/
mysql配置文件路径:/etc/mysql/my.cnf
PHP php.ini:/etc/php5/fpm/php.ini
通用方法:
find / -name nginx.conf
find / -name php.ini
find / -name my.cnf
find / -name httpd.conf
mysql数据库远程连接不上:
1:更改mysql里的user表:update user set host = '%' where user = 'root';
2:mysql的配置文件/etc/mysql/my.conf里的bind-address改成任意ip,即0.0.0.0
Linux下mysql数据库设置编码:
php文件内添加mysqli_set_charset($conn,"utf8");
vim /etc/mysql/my.cnf
[mysqld]标签下加上一行
character-set-server=utf8
[client]标签下加上一行
default-character-set = utf8
执行数据库命令,除binary之外的所有字段统一成utf8:
mysql> SHOW VARIABLES LIKE 'character%'; // 一般会显示部分设置非utf8
mysql> SET character_set_client = utf8;
mysql> SET character_set_connection = utf8;
mysql> SET character_set_database = utf8;
mysql> SET character_set_results = utf8;
mysql> SET character_set_server = utf8;
设置时区并对时:
# dpkg-reconfigure tzdata 并非tzselect
# ntpdate cn.pool.ntp.org 另有asia.pool.ntp.org、us.pool.ntp.org
(对时前先ps aux|grep ntpd然后kill对应pid以防止端口被占用)
写入开机脚本:/etc/rc.local添加一句exec ntpdate cn.pool.ntp.org
msmtp和mutt发送邮件设置:
apt-get安装完msmtp和mutt
msmtp -P //查看msmpt加载所需的配置文件路径,一般会显示:
ignoring system configuration file /etc/msmtprc: No such file or directory
ignoring user configuration file /root/.msmtprc: No such file or directory
选user configuration file 即可,即在 /root目录用vim新建文档.msmtprc,添加内容如下:
# Set default values for all following accounts.
defaults
logfile /usr/local/msmtp/msmtp.log
# The SMTP server of the provider.
account test
# SMTP邮件服务器地址
host smtp.qq.com
# 发送的邮件Email
from 2048842942@qq.com
auth login
# 邮件服务器登录账号
user 2048842942@qq.com
# 邮件服务器登陆密码
password ********
# Set a default account
account default : test
再执行命令: msmtp bbbbbb@163.com //接收邮箱输入任意字符,然后按Ctrl+D退出,可查看邮件是否收到。一般又会提示:msmtp: authentication failed (method LOGIN),需在邮箱里设置里开启第三方邮件客户端授权。
编辑Muttrc: # vim /etc/Muttrc 添加内容如下:
set from="aaaaaa@qq.com" //发件箱
set sendmail="/usr/bin/msmtp"
set use_from=yes
set realname="XXXXXX" //发件人
set editor="vim"
普通测试:
#echo "此处填邮件内容" | mutt -s "邮件标题" bbbbbb@qq.com //收件箱
添加附件:
#echo "此处填邮件内容" | mutt -s "邮件标题" bbbbbb@qq.com -a test.txt //-a需要添加在末尾,否则会找不到文件!!
Linux安装pip:
方法一:直接下载并执行脚本:https://raw.githubusercontent.com/pypa/pip/master/contrib/get-pip.py 或 https://bootstrap.pypa.io/get-pip.py
方法二:sudo apt-get install python3-pip
python3及以上的pip已在/usr/local/bin/目录中,即pip3.x