安装 apache2 mysql-server-5.6 php5
php5-cli php5-mysql php5-mcrypt php5-curl
检查php版本:
php -v
检查登录mysql:
mysql -uroot -p
检查Apache:
sudu lsof -i4 -Ln
ps aux | grep apache2
sudo netstat -anop | grep apache
配置https
cd /etc/apache2
sudo a2ensite default-ssl
sudo service apache2 restart
警告信息可忽略
想消除警告,可以
gedit /etc/apache2/apache2.conf
在最后一行加上:
servername localhost
再次 sudo service apache2 restart
则没有警告信息了
可查看配置文件:
cat sites-enabled/default-ssl.conf
ssl默认没有启用
启用ssl
sudo a2enmod ssl
use user;
CREATE TABLE userinfor
(
username
varchar(80) NOT NULL,
password
char(60) NOT NULL,
password3
char(64) DEFAULT NULL,
pubKey
text DEFAULT NULL,
privKey
text DEFAULT NULL,
sex
varchar(10) DEFAULT NULL,
email
varchar(45) DEFAULT NULL,
tel
varchar(20) DEFAULT NULL,
date
datetime DEFAULT NULL,
token
char(32) DEFAULT NULL,
token_exptime
int not null,
regtime
int not null,
PRIMARY KEY (username
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE file
(
id
int(11) NOT NULL AUTO_INCREMENT,
username
char(10) NOT NULL,
filename
varchar(45) NOT NULL,
file_locate
varchar(80) NOT NULL,
extension
varchar(45) DEFAULT NULL,
sign
text,
date
datetime DEFAULT NULL,
hash
varchar(300) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
查看数据库中的表
show tables
查看表结构
desc table_name;
安装步骤
1.安装jdk(因为phpstorm是java做的,所以需要安装一个java环境,即jdk)
[plain] view plain copy
hjm@hjm-VirtualBox:/$ sudo apt-get install openjdk-7-jdk
2.下载phpstorm
官网URL:https://www.jetbrains.com/phpstorm/download/#section=linux-version
3.解压phpstorm,创建快捷命令
hjm@hjm-VirtualBox:/$ sudo ln -s /opt/PhpStorm-145.1616.3/bin/phpstorm.sh /usr/local/bin/phpstorm
4.现在可以直接在shell下开启phpstorm了.
hjm@hjm-VirtualBox:/$ phpstorm
ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDSKVc32pjay9NyEILxUOeWQpxvsYb/JQNm0g9lhl2dHx2GoARNFSQpoorPqTXi1NJPvNUwTYnuMpfYXGNAYe7ec+C4rSNLYN67jstugGGGcNvOJ6cOvuQ1DKA9M/FcPafn2Ae8NSM+AnCze9Cxste9V3vjNmfC8/96ygZDxDFRC4GBAT4Dzyr2bRgkZkWXE6C/RdlHl3s1375JaVuLlnQoflF2RPtXLxP9Zvd8Zp4lseQ2EwIQDFIpGai4zjXDP0fdtIQEx/9R/GTDHX8186B4sRILu2OplV+WUSc2ApxbakU1fwPiDFdBmCD40uZIUzRb+hwprJFPZ/nQtSJa13wd 984178308@qq.com