本文主要向大家介绍了MySQL数据库之Ubuntu18.04 + MySQL + phpMyAdmin + Nginx ，通过具体的内容向大家展现，希望对大家学习MySQL数据库有所帮助。

Ubuntu18.04 + MySQL + phpMyAdmin + Nginx

安装 软件

apt install nginx
add-apt-repository ppa:ondrej/php
apt-get update
apt-get install php7.2 php-fpm php-mysql php-mbstring
apt-get install mysql-server
apt-get install phpmyadmin

安装完php7.2 , 配置环境在  /etc/php/7.2/fpm 内有两个重要配置文件

php.ini

设置 short_open_tag = On

extension_dir = "/usr/lib/php/20170718"

开启对mysql的支持:extension=mysqli.so，extension=pdo_mysql.so

设置''cgi.fix_pathinfo=0''

php-fpm.conf

引入配置文件 include=/etc/php/7.2/fpm/pool.d/*.conf 在 /etc/php/7.2/fpm/pool.d/ 目录下 有个 www.conf 文件

在 www.conf 找到 listen = /run/php/php7.2-fpm.sock, 后面配置 nginx 需要用到

重启 php-fpm7.2

/etc/init.d/php7.2-fpm restart##  orsystemctl enable php7.2-fpm
systemctl restart php7.2-fpm

MySQL5.7 默认 root 没有密码，不允许远程访问，需要命令创建新用户

参考资料 https://askubuntu.com/questions/763336/cannot-enter-phpmyadmin-as-root-mysql-5-7?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa

Connect to mysql

sudo mysql --user=root mysql

Create a user for phpMyAdmin

CREATE USER 'demo'@'localhost' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'demo'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Optional: allow remote connections

CREATE USER 'phpmyadmin'@'%' IDENTIFIED BY 'some_pass';
GRANT ALL PRIVILEGES ON *.* TO 'phpmyadmin'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

安装后的 的phpmyadmin 目录是在 /usr/share/phpmyadmin

我们需要在 /var/www/ 目录下 创建一个软链接

ln -s /usr/share/phpmyadmin /var/www/

编写 phpmyadmin.conf 配置文件， 在 /etc/nginx/sites-available 目录下

server{
      listen 80;
      root    /var/www/phpmyadmin;
      index   index.php;
      server_name phpmyadmin.example.top;
      rewrite ^(.*)$  https://$host$1 permanent;
  }

  server{
      access_log /var/www/logs/phpmyadmin_access.log;
      error_log /var/www/logs/phpmyadmin_error.log;
      listen 443 ssl http2;
      root    /var/www/phpmyadmin;
      index   index.php;
      add_header Strict-Transport-Security "max-age=63072000; includeSubdomains; preload";
      ssl         on;
      ssl_certificate     /root/.acme.sh/*.example.top/fullchain.cer;
      ssl_certificate_key /root/.acme.sh/*.example.top/*.example.top.key;      #ssl_certificate        /root/.acme.sh/example.top/fullchain.cer;
      #ssl_certificate_key    /root/.acme.sh/example.top/example.top.key;
      ssl_prefer_server_ciphers   on;
      ssl_session_timeout 10m;
      ssl_protocols   TLSv1.2 TLSv1.3;
      ssl_ciphers TLS13-AES-256-GCM-SHA384:TLS13-AES-128-GCM-SHA256:EECDH+ECDSA+AES256:EECDH+aRSA+AES256:EECDH+ECDSA+AES128:EECDH+aRSA+AES128!MD5;
      server_name phpmyadmin.example.top;      #location / {
      #   index index.html;
      #   root /var/www/html;
      #}

      #location /phpmyadmin{
      location / {
          index index.php;
          root /var/www/phpmyadmin/;          #try_files $uri $uri/ /phpmyadmin/index.php?$args;
      }

      location ~ .php$ {
          root /var/www/phpmyadmin/;
          fastcgi_pass unix:/run/php/php7.2-fpm.sock;
          fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
          include fastcgi_params;
      }

      location ~ .(htm|html|gif|jpg|png|js|css)$ {
          root /var/www/phpmyadmin/;
      }

  }

测试Nginx配置的正确语法：

  sudo nginx -t

nginx 重新加载

   systemctl restart nginx

本文由职坐标整理并发布，希望对同学们学习MySQL有所帮助，更多内容请关注职坐标数据库MySQL数据库频道！