安装mariadb-5.5.6(mariadb-5.5.6兼容mysql-5.5.6,同一个创始人开发的)
yum install mariadb-server -y
开机启动mariadb
systemctl enable mariadb
启动/关闭mariadb
systemctl start mariadb
ssytemctl stop mariadb
进入mariadb
mysql -u root -p
初始没有密码,直接回车进入
use mysql
使用mysql
数据库
Select User,Host,Password FROM user ;
查看用户表数据
DELETE FROM user WHERE User = "" ;
删除空的用户
设置密码为 1234
set password for 'root'@'localhost' = password('1234') ;
set password for 'root'@'localhost.localdomain' = password('1234') ;
set password for 'root'@'127.0.0.1' = password('1234') ;
set password for 'root'@'::1' = password('1234') ;
设置远程访问mariadb
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '1234';
重新加载权限
flush privileges;
添加·nginx
源,安装,启动并设置开机启动
rpm -Uvh http://nginx.org/packages/centos/7/noarch/RPMS/nginx-release-centos-7-0.el7.ngx.noarch.rpm
yum install nginx -y
systemctl enable nginx
systemctl start nginx
添加php
源,安装并启动并设置开机启动
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm
yum search php70 找出需要安装的软件然后安装
yum install php70w php70w-bcmath php70w-cli php70w-common php70w-dba php70w-devel php70w-fpm php70w-gd php70w-imap php70w-intl php70w-mbstring php70w-mcrypt php70w-mysqlnd php70w-odbc php70w-opcache php70w-pdo php70w-pdo_dblib php70w-pecl-apcu php70w-pecl-apcu-devel php70w-pecl-redis php70w-soap php70w-xml php70w-xmlrpc -y
systemctl enable php-fpm 设置开机启动
systemctl start php-fpm 启动php-fpm
设置www
项目目录
进入
cd /
mkdir www
cd /etc/nginx/conf.d
vi default.conf
在server
下的location /
块注释掉root /usr/share/nginx/html;
去掉最下面location ~ \.php $
相关的配置前面的注释
修改fastcgi_param
把/scripts
改为$document_root
重启nginx
systemctl reload nginx