centos-lamp

安装apache

https://www.linode.com/docs/websites/lamp/lamp-on-centos-7

之前通过下载tar.bz包安装并启动了apache,所以在启动yum安装的httpd时报错。

sudo yum install httpd

 

安装php

PHP Install and Configure
sudo yum install php php-pear

Edit /etc/php.ini for better error messages and logs, and upgraded performance. These modifications provide a good starting point for a Linode 1GB:

/etc/php.ini
error_reporting = E_COMPILE_ERROR|E_RECOVERABLE_ERROR|E_ERROR|E_CORE_ERROR
error_log = /var/log/php/error.log
max_input_time = 30

Create the log directory for PHP and give the Apache user ownership:
sudo mkdir /var/log/php
sudo chown apache /var/log/php

Reload Apache:
sudo systemctl reload httpd

新建php文件输出php信息测试php是否安装成功

<html><body>
<h1>It works!</h1>
<?php phpinfo(); ?>
</body></html>

 

安装数据库

https://www.linode.com/docs/databases/mariadb/how-to-install-mariadb-on-centos-7

centos 7默认的数据库服务器是mariadb。

Enable MariaDB to start on boot and then start the service:
sudo systemctl enable mariadb
sudo systemctl start mariadb

Harden MariaDB Server
sudo mysql_secure_installation
You will be given the choice to change the MariaDB root password, remove anonymous user accounts, disable root logins outside of localhost, and remove test databases. It is recommended that you answer yes to these options.

To log in to MariaDB as the root user:
mysql -u root -p

Create a New MariaDB User and Database
In the example below, testdb is the name of the database, testuser is the user, and password is the user’s password:
create database testdb;
create user 'testuser'@localhost identified by 'password';
grant all on testdb.* to 'testuser' identified by 'password';

Create a Sample Table
mysql -u testuser -p

Create a sample table called customers. This creates a table with a customer ID field of the type INT for integer (auto-incremented for new records, used as the primary key), as well as two fields for storing the customer’s name:
use testdb;
create table customers (customer_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, first_name TEXT, last_name TEXT);

View the new table:
show tables;

Reset the MariaDB Root Password
Stop the current MariaDB server instance, then restart it with an option to not ask for a password:
sudo systemctl stop mariadb
sudo mysqld_safe --skip-grant-tables &

Reconnect to the MariaDB server with the MariaDB root account:
mysql -u root

Use the following commands to reset root’s password. Replace password with a strong password:
use mysql;
update user SET PASSWORD=PASSWORD("password") WHERE USER='root';
flush privileges;
exit

Then restart MariaDB:
sudo systemctl start mariadb

Tune MariaDB
The script needs the bc language installed:
sudo yum install bc

Download MySQL Tuner to your home directory and make it executable:
wget http://www.day32.com/MySQL/tuning-primer.sh
chmod u+x tuning-primer.sh

To run it:
sudo ./tuning-primer.sh
You will be asked if you would like to run the script against a different MySQL socket than /var/lib/mysql/mysql.sock. Select N. You will then be asked if you have your login. Enter y, then the credentials when asked.

 

posted @ 2016-03-10 16:39  qike  阅读(150)  评论(0编辑  收藏  举报