在windows上安装mariadb+php+nginx+phpMyAdmin

[todaygood]

Step1-安装mariadb

写启动脚本

Step2-安装nginx

1. 修改配置

   server {
       listen       80;
       server_name  localhost;
   
       #charset koi8-r;
   
       #access_log  logs/host.access.log  main;
   
       access_log  logs/host.access.log;
   
       location =/ {
           root   html;
           #index  baidu.html;
          index  index.html index.htm;
       }
   
       location ^~ /baidu {
           root           html;
           index          baidu.html;
       }
   
       location ~* /phpmyadmin {
           root           html;
           #index          index.php;
           fastcgi_pass   127.0.0.1:9123;
           fastcgi_index  index.php;
           #fastcgi_param  SCRIPT_FILENAME   /scripts$fastcgi_script_name;
           fastcgi_param  SCRIPT_FILENAME    $document_root$fastcgi_script_name;
           include        fastcgi_params;
       }

2. 写启动脚本

Step3-安装php

检查nginx.conf中的 127.0.0.1:9123 端口并没有监听。

location ~* /phpmyadmin {
            root           html;
            #index          index.php;
            fastcgi_pass   127.0.0.1:9123;
            fastcgi_index  index.php;
            #fastcgi_param  SCRIPT_FILENAME   /scripts$fastcgi_script_name;
            fastcgi_param  SCRIPT_FILENAME    $document_root$fastcgi_script_name;
            include        fastcgi_params;
        }

安装PHP-FastCGI

https://www.nginx.com/resources/wiki/start/topics/examples/phpfastcgionwindows/

[todaygood]

Issue

Solution

https://stackoverflow.com/questions/10646655/the-mysqli-extension-is-missing-please-check-your-php-configuration

修改如下

extension_dir = "C:\Software\php-7.3.1-Win32-VC15-x64\ext"
extension=mbstring
extension=exif      
; Must be after mbstring as it depends on it
extension=mysqli

[todaygood]

设置mariadb初始化密码

MariaDB [(none)]> use mysql;
Database changed
MariaDB [mysql]> update user set password=password('123456') where user='root';

PS C:\Software\mariadb-10.3.11-winx64\bin> .\mysql.exe -u root -p
Enter password: ******
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 16
Server version: 10.3.11-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>

[todaygood]

按照这个配置 http://www.php.cn/php-weizijiaocheng-357397.html

出现这个问题，查了一下，应该是phpMyadmin和php 的版本配套引起。

[todaygood]

issue

Warning in .\libraries\classes\Config\FormDisplay.php#658
 "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"?

Backtrace

.\vendor\composer\ClassLoader.php#444: include()
.\vendor\composer\ClassLoader.php#322: Composer\Autoload\includeFile(string 'C:\\Software\\nginx-1.15.8\\html\\phpmyadmin\\vendor\\composer/../../libraries/classes\\Config\\FormDisplay.php')
Composer\Autoload\ClassLoader->loadClass(string 'PhpMyAdmin\\Config\\FormDisplay')
.\libraries\classes\Config\Forms\BaseForm.php#16: spl_autoload_call(string 'PhpMyAdmin\\Config\\FormDisplay')
.\vendor\composer\ClassLoader.php#444: include(.\libraries\classes\Config\Forms\BaseForm.php)
.\vendor\composer\ClassLoader.php#322: Composer\Autoload\includeFile(string 'C:\\Software\\nginx-1.15.8\\html\\phpmyadmin\\vendor\\composer/../../libraries/classes\\Config\\Forms\\BaseForm.php')
Composer\Autoload\ClassLoader->loadClass(string 'PhpMyAdmin\\Config\\Forms\\BaseForm')
.\libraries\classes\Config\Forms\User\FeaturesForm.php#12: spl_autoload_call(string 'PhpMyAdmin\\Config\\Forms\\BaseForm')
.\vendor\composer\ClassLoader.php#444: include(.\libraries\classes\Config\Forms\User\FeaturesForm.php)
.\vendor\composer\ClassLoader.php#322: Composer\Autoload\includeFile(string 'C:\\Software\\nginx-1.15.8\\html\\phpmyadmin\\vendor\\composer/../../libraries/classes\\Config\\Forms\\User\\FeaturesForm.php')
Composer\Autoload\ClassLoader->loadClass(string 'PhpMyAdmin\\Config\\Forms\\User\\FeaturesForm')
.\libraries\classes\Config\Forms\BaseFormList.php#123: spl_autoload_call(string 'PhpMyAdmin\\Config\\Forms\\User\\FeaturesForm')
.\libraries\classes\UserPreferences.php#48: PhpMyAdmin\Config\Forms\BaseFormList::getFields()
.\libraries\classes\Config\PageSettings.php#80: PhpMyAdmin\UserPreferences->pageInit()
.\libraries\classes\Config\PageSettings.php#210: PhpMyAdmin\Config\PageSettings->__construct(string 'DbStructure')
.\libraries\classes\Controllers\Database\DatabaseStructureController.php#156: PhpMyAdmin\Config\PageSettings::showGroup(string 'DbStructure')
.\db_structure.php#38: PhpMyAdmin\Controllers\Database\DatabaseStructureController->indexAction()

用最新的phpMyAdmin 版本4.8.3 之后，就没有了。