CentOS + Apache2.4 + PHP7 + MySQL8 + phpMyAdmin 一键安装 整个安装流程有较酷炫的效果,适合装逼
使用root连接服务器
cd ~
yum install -y git
git clone https://github.com/pzn2513/LAMP.git
chmod 700 -R LAMP/bin
LAMP/bin/lamp-install
mysql -uroot -p
复制粘贴以上命令,等待安装……
安装完成! 获取MySQL临时密码,登陆后需修改密码
- grep 'temporary password' /var/log/mysqld.log
- alter user 'root'@'localhost' identified with mysql_native_password by 'Your.Password';
新建一个admin用户,密码类型native,用来给phpmyadmin连接数据库(当然,也可以改root密码类型)
insert mysql.user VALUES ('localhost', 'admin', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', '', '', '', '', '0', '0', '0', '0', 'mysql_native_password', '*84AAC12F54AB666ECFC2A83C676908C8BBC381B1', 'N', '2018-04-21 11:25:16', null, 'N', 'Y', 'Y', null, null, null, null);
FLUSH PRIVILEGES;
alter user 'admin'@'localhost' identified by 'Your.Password';
其他操作
- set global validate_password.policy=LOW;
- show variables like 'character%';
- select host,user,plugin,authentication_string from mysql.user;
MySQL8的配置变化比较大,如果无法成功配置可以寻求帮助,见Bugs & Issues
Apache Location | Path |
---|---|
Install Prefix | /usr/local/apache24 |
Web root location | /usr/local/apache24/htdocs |
Main Configuration File | /usr/local/apache24/conf/httpd.conf |
Virtual Host conf | /usr/local/apache24/conf/extra/httpd-vhosts.conf |
SSL Host conf | /usr/local/apache24/conf/extra/httpd-vhosts.conf |
phpMyAdmin Location | Path |
---|---|
Installation location | /usr/local/apache24/htdocs/phpMySQLAdmin-secret |
PHP Location | Path |
---|---|
Install Prefix | /usr/local/php |
Configuration File | /usr/local/php/lib/php.ini |
MySQL Location | Path |
---|---|
Install Prefix | /usr/local/mysql |
Data Location | /usr/local/mysql/data |
my.cnf Configuration File | /etc/my.cnf |
Process | Command |
---|---|
Apache | /usr/local/apache24/bin/apachectl (start|stop|status|restart) |
MySQL | systemctl (start|stop|status|restart) mysqld.service |
Command | Description |
---|---|
lamp-init | 初始化各个配置文件 |
addvhost (site) | 添加vhost,在/home下创建site目录 |
addssl (site) | 添加ssl,在/home下创建site目录,需要在/usr/local/apache24/cert/(site)配置证书文件 |
addboth (site) | 添加vhost和ssl,在/home下创建site目录,需要在/usr/local/apache24/cert/(site)配置证书文件 |
Please feel free to report any bugs or issues to us, email to: [email protected] or issues on Github.
Copyright (C) 2016 - 2018 PZN
Licensed under the GPLv3 License.