安装并运行最简单的LAMP

安装最简单的LAMP

系统：CentOS 6 & 7 都可

yum install httpd php php-mysql php-gd mysql-server php-xml mysql    

接着运行以下命令进行数据库初始化

service mysqld start

mysql_secure_installation

设置完成后登录数据库

 mysql -u root -p    

创建用户，并赋予创建权限

CREATE USER 'USER'@'localhost' IDENTIFIED BY 'THISpasswordSHOULDbeCHANGED';  //创建用户指定密码    

GRANT ALL PRIVILEGES ON *.* TO 'wiki'@'localhost' IDENTIFIED BY 'THISpasswordSHOULDbeCHANGED' WITH GRANT OPTION;  //赋予权限    

FLUSH PRIVILEGES;  //刷新配置文件    

exit; 

创建数据库

CREATE DATABASE database name;    

显示当先数据库

SHOW DATABASES;    

赋予权限,刷新配置

GRANT ALL PRIVILEGES ON databasename.* TO 'user'@'localhost' IDENTIFIED BY 'Thisispassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
exit    

设置web与mysql开机启动

chkconfig httpd on
chkconfig mysqld on