Mysql+phpMyAdmin+nginx源码包安装并实现Mysql数据库图形化

解压安装包

tar zxf mysql-boost-5.7.31.tar.gz
cd mysql-5.7.31

安装cmake命令

yum install cmake -y

安装参数

cmake \
	-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \ #指定安装目录
	-DMYSQL_DATADIR=/usr/local/mysql/data \ #数据库存放目录
	-DMYSQL_UNIX_ADDR=/usr/local/mysql/data/mysql.sock \ #Unix socket文件路径
	-DWITH_INNOBASE_STORAGE_ENGINE=1 \ #安装innodb存储引擎
	-DDEFAULT_CHARSET=utf8 \ #使用utf8字符 、
	-DDEFAULT_COLLATION=utf8_general_ci \ #校验字符
	-DEXTRA_CHARSETS=all \ #安装所有扩展字符集
	-DWITH_BOOST=boost/boost_1_59_0
make && make install

创建快捷命令

vim /root/.bash_profile
PATH=$PATH:$HOME/bin:/usr/local/mysql/bin
source /root/.bash_profile

修改mysql配置文件

vim /etc/my.cnf

创建mysql用户

useradd -s /sbin/nologin  -M -d /usr/local/mysql/data mysql

复制mysql启动文件

cp /user/local/mysql/support-files/mysql.server /etc/init.d/mysqld

初始化mysql配置

mysqld --initialize --user=mysql
#初始化后最后一行localhost:后边为初始密码

启动mysql

/etc/init.d/mysqld start

mysql数据库安全初始化

mysql_secure_installation
#初始化时第一行要输入初始密码

mysql登陆

安装php包
解压

tar zxf php-7.4.12.tar.bz2

建立nginx用户

useradd -s /sbin/nologin nginx

安装

./configure \
	--prefix=/usr/local/php \
	--with-config-file-path=/usr/local/php/etc \
	--with-mysqli \
	--with-pdo-mysql \
	--enable-mysqlnd \
	--with-openssl \
	--with-zlib \
	--with-curl \
	--enable-gd \
	--with-jpeg \
	--with-freetype \
	--with-gettext \
	--with-mhash \
	--enable-mbstring \
	--with-gmp \
	--disable-inline-optimization \
	--enable-soap \
	--enable-ftp \
	--enable-sockets \
	--enable-fpm \
	--with-fpm-user=nginx \
	--with-fpm-group=nginx

复制文件

cp /usr/local/php/etc/php-fpm.conf.default /usr/local/php/etc/php-fpm.conf
cp /usr/local/php/etc/php-fpm.d/www.php.default usr/local/php/etc/php-fpm.d/www.conf

建立快捷命令

vim ~/.bash_profile
PATH=$PATH:$HOME/bin:/usr/local/mysql/bin:/usr/local/php/bin
source ~/.bash_profile #刷新文件

从源码包中复制文件

cp php.ini-production /usr/local/php/etc/php.ini
cp /root/php-7.4.12/sapi/fpm/init.d.php-fpm /etc/init.d/php-fpm
chmod +x /etc/init.d/php-fpm #给启动脚本加上执行权限

启动php

/etc/init.d/php-fpm start

安装nginx

#解压后在源码包
./configure --prefix=/usr/local/nginx --with-threads --with-file-aio --with-http_ssl_module --with-http_stub_status_module
make && make install

建立快捷命令

vim /root/.bash_profile
PATH=$PATH:$HOME/bin:/usr/local/mysql/bin:/usr/local/php/bin:/usr/local/nginx/sbin
source /root/.bash_profile

修改nginx默认配置

# vim /usr/local/nginx/conf/nginx.conf
user  nginx;
worker_processes  auto;
events {
    worker_connections  65535;
}
location ~ \.php$ {
            root           html;
            fastcgi_pass   127.0.0.1:9000;
            fastcgi_index  index.php;
            #fastcgi_param  SCRIPT_FILENAME  /scripts$fastcgi_script_name;
            include        fastcgi.conf;
        }
# vim vim /etc/security/limits.conf
nginx - nofile 65536

编写PHP发布页

vim index.php

安装phpmyadim包

unzip phpMyAdmin-5.0.2-all-languages.zip -d /usr/local/nginx/html/

建立软链接

ln -s /usr/local/nginx/html/phpMyAdmin-5.0.2-all-languages/ phpadmin

修改php文件

#vim /usr/local/php/etc/php.in
pdo_mysql.default_socket=/usr/local/mysql/data/mysql.sock
mysqli.default_socket = /usr/local/mysql/data/mysql.sock

设置用户名和密码

给data目录所有人可以访问的权限

chmod 755 /usr/local/mysql/data

测试
访问172.25.10.5/index.php

访问172.25.10.5/phpadmin/index.php

进入图形化数据库