Install phpMyAdmin 4.8 in Windows 10, and upgrade based on Composer to avoid the trouble of subsequent manual installation and upgrade
1. Reference URL:https://docs.phpmyadmin.net/zh_CN/latest/setup.html#installing-using-composer
2. Install and run the command based on composer, as shown in Figure 1
Figure 1
composer create-project phpmyadmin/phpmyadmin phpmyadmin-localhost
Installing phpmyadmin/phpmyadmin (4.8.2)
- Installing phpmyadmin/phpmyadmin (4.8.2): Downloading (connecting...)^CTerminate batch job (Y/N)? Y
PS E:\wwwroot> composer create-project phpmyadmin/phpmyadmin phpmyadmin-localhost
Installing phpmyadmin/phpmyadmin (4.8.2)
- Installing phpmyadmin/phpmyadmin (4.8.2): Downloading (100%)
Created project in phpmyadmin-localhost
Loading composer repositories with package information
Installing dependencies (including require-dev) from lock file
Warning: The lock file is not up to date with the latest changes in composer.json. You may be getting outdated dependenc
ies. Run update to update them.
Package operations: 49 installs, 0 updates, 0 removals
phpmyadmin/phpmyadmin suggests installing ext-opcache (Better performance)
phpmyadmin/phpmyadmin suggests installing ext-gd2 (For image transformations)
phpmyadmin/shapefile suggests installing ext-dbase (For dbf files parsing)
phpseclib/phpseclib suggests installing ext-gmp (Install the GMP (GNU Multiple Precision) extension in order to speed up
arbitrary precision integer arithmetic operations.)
phpseclib/phpseclib suggests installing ext-libsodium (SSH2/SFTP can make use of some algorithms provided by the libsodi
um-php extension.)
paragonie/random_compat suggests installing ext-libsodium (Provides a modern crypto API that can be used to generate ran
dom bytes.)
twig/extensions suggests installing symfony/translation (Allow the time_diff output to be translated)
symfony/console suggests installing psr/log-implementation (For using the console logger)
symfony/console suggests installing symfony/event-dispatcher
phpunit/php-code-coverage suggests installing ext-xdebug (>=2.2.1)
phpunit/phpunit-mock-objects suggests installing ext-soap (*)
sebastian/global-state suggests installing ext-uopz (*)
phpunit/phpunit suggests installing phpunit/php-invoker (~1.1)
Generating autoload files
3. Enter the phpmyadmin-localhost directory, update phpmyadmin to the latest version, and run the command, as shown in Figure 2
Figure 2
composer update
Loading composer repositories with package information
Updating dependencies (including require-dev)
Package operations: 7 installs, 19 updates, 1 removal
Writing lock file
Generating autoload files
4. Use the installer to generate the configuration file: config.inc.php, open the browser and use the /setup suffix to access, the URL:http://localhost/phpmyadmin-localhost/setup/, create a new server, as shown in Figure 3
Figure 3
5. After clicking the application button, click the download button to download the configuration file: config.inc.php, as shown in Figure 4, Figure 5
Figure 4
Figure 5
6. Copy config.inc.php to \phpmyadmin-localhost\config.inc.php to open the URL:http://localhost/phpmyadmin-localhost, there is a warning message: phpmyadmin Advanced features have not been fully set, some functions are not activated. Find the reason. as shown in Figure 6
Figure 6
7. Follow the prompts: create a database namedphpmyadminand setup the phpMyAdmin configuration storage there.
Figure 7
8. Open the URL:https://www.phpmyadmin.net/themes/, download theme: Metro 2.8, copy to /themes/, toggle the theme: Metro, as shown in Figure 8, Figure 9
8
Figure 9
9. Note: There is no way to install and upgrade the theme based on Composer. It can only be implemented through the download scheme, and the installation and upgrade based on Composer cannot be upgraded to the latest version: 4.8.3, because Composer The version update of the library is delayed and needs to be waited.
10. When adding a new server, you need to delete \phpmyadmin-localhost\config.inc.php to open the URL:http://localhost/phpmyadmin-localhost/setup/, create a new server, as shown in Figure 10
Figure 10
11. Download the configuration file: config.inc.php, copy config.inc.php to \phpmyadmin-localhost\config.inc.php, open the URL:http://localhost/phpmyadmin-localhost, when logging in, select 2 servers already exist, you can choose which server to log in, as shown in Figure 11
Figure 11
