phpMyAdmin Installation Record

phpMyAdmin Installation Record

Date: September 20, 2017

First, phpMyAdmin Introduction:

PhpMyAdmin is a GUI management tool for MySQL or MARIADB database, based on PHP and web as the working form.

Second, phpMyAdmin installation:

2-1:lamp Environment Preparation

ip:192.168.1.71;

Hostname:centos73-2.surmount.net;

Linux:centos Linux release 7.3.1611 (Core);

apache:httpd-2.4.6;

Mysql:ver 15.1 Distrib 5.5.52-mariadb;

The Php:iso disc yum source is initially installed as php-5.4.16,

Upgrade to php56w-5.6.31 as needed after installing the phpMyAdmin-4.7.4 error prompt.

2-1-1: Installation and configuration mariadb

# yum Install mariadb-server-y# systemctl start mariadb.service# mysqlmariadb [(none)]> SET PASSWORD for ' root ' @ ' 127. 0.0.1 ' =password (' Jingpei '); MariaDB [(None)]> SET PASSWORD for ' root ' @ ' localhost ' =password (' Jingpei '); MariaDB [(None)]> FLUSH privileges;

Set the root user password for the DB

2-1-2: Installing and configuring Apache

# yum Install httpd-y# systemctl start httpd.service# vim/etc/httpd/conf/httpd.confservername centos73-2.surmount.net : 80# httpd-tsyntax ok# systemctl Reload Httpd.service

http://192.168.1.71

Testing HTML pages

Ok

2-1-3: Install PHP

# yum Install php php-mysql-y# vim/var/www/html/index.php<?php $link = mysql_connect (' localhost ', ' MySQL ', ')        ;        if (! $link) {die (' Could not connect: '. Mysql_error ());        } Echo ' Connected successfully ';        Mysql_close ($link); Phpinfo ()?>

http://192.168.1.71/index.php

Test the PHP page and test the DB connection

Ok

2-2: Install phpMyAdmin

2-2-1: Installation

# unzip phpmyadmin-4.7.4-all-languages.zip# cp-a phpmyadmin-4.7.4-all-languages/var/www/html# LN-SV Phpmyadmin-4.7.4-all-languages pma# cd/var/www/html/pma# cp config.sample.inc.php config.inc.php# tr-d ' a-za-z0-9 ' </dev/urandom | head-30 | Md5sum8b2c0e4f280fb8cab9ff8b2716cf7a40-# vim config.inc.php ... $cfg [' blowfish_secret '] = ' 8b2c0e4f280fb8cab9ff8b2716cf7a40 '; /* Must FILL in the this for COOKIE auth! */......http://192.168.1.71/pmastatus code:500

2-2-1: Troubleshooting

# Vim/etc/php.ini......display_errorsdefault Value:on......error_reportingdefault Value:e_all & ~E_NOTICE & ~ E_strict & ~e_deprecated ...

Open PHP Error

# systemctl reload httpd.servicehttp://192.168.1.71/pma/parse error: syntax  error, unexpected  ' @ '  in /var/www/html/phpmyadmin-4.7.4-all-languages/libraries/ Common.inc.php on line 467# cat /var/www/html/pma/libraries/common.inc.php467 if   (@extension_loaded (' mbstring ')  && !empty (@ini_get (' mbstring.func_overload '))  { 468     pma_fatalerror (469         __ ( 470              ' You have enabled  mbstring.func_overload in your PHP  ' 471              .  ' configuration. this option is incompatible  with phpMyAdmin  ' 472              .  ' And might cause some data to be corrupted! ' 473         ) 474     );475 }#  wget -o /etc/yum.repos.d/centos-base-ali.repo http://mirrors.aliyun.com/repo/centos-7.repo#  sed -i   ' s/$releasever/7/g '  /etc/yum.repos.d/CentOS-Base-Ali.repo# yum  install php-mbstring -y# systemctl reload httpd.servicehttp://192.168.1.71/pma/

Prompt for the same error, temporarily comment out the 467-475 lines of common.inc.php, pending the completion of PHP upgrade and then uncomment.

# Systemctl Reload Httpd.service

http://192.168.1.71/pma/

PHP 5.5+ is required.

Currently installed version is:5.4.16

Tip PHP Version Low

# yum list installed | grep phpphp.x86_64                                5.4.16-42.el7                    @iso      php-cli.x86_64                            5.4.16-42.el7                    @iso      php-common.x86_64                         5.4.16-42.el7                    @iso      php-mbstring.x86_64                      5.4.16-42.el7                    @base      php-mysql.x86_64                         5.4.16-42.el7                    @iso       php-pdo.x86_64                           5.4.16-42.el7                    @iso  # yum remove  php php-cli php-common php-mbstring php-mysql php-pdo -y# yum list php* 

No source available, so install webtatic third party yum Source

# RPM-UVH https://mirror.webtatic.com/yum/el7/epel-release.rpm# RPM-UVH https://mirror.webtatic.com/yum/el7/ webtatic-release.rpm# Yum Install php56w-y# systemctl Reload Httpd.service

http://192.168.1.71/pma/

Missing mbstring Extension

# wget http://repo.webtatic.com/yum/el7/x86_64/RPMS/php56w-mbstring-5.6.31-1.w7.x86_64.rpm# RPM-IVH php56w-mbstring-5.6.31-1.w7.x86_64.rpm# Systemctl Reload Httpd.service

http://192.168.1.71/pma/

Missing mysqli Extension

# yum Install php56w-mysql-y# systemctl Reload httpd.service# httpd-m | grep phpphp5_module (Shared)

http://192.168.1.71/pma/

Ok

650) this.width=650; "Src=" https://s1.51cto.com/wyfs02/M02/07/24/wKiom1nD6vSy3Q5BAADrZ3FE9Os692.png-wh_500x0-wm_ 3-wmp_4-s_4157861250.png "title=" qq picture 20170922003542.png "alt=" Wkiom1nd6vsy3q5baadrz3fe9os692.png-wh_50 "/>

When the installation is complete, the mouse flow-based operation is no longer allocations.

This article is from "Hello, CTO." "Blog, be sure to keep this provenance http://200622925.blog.51cto.com/13331171/1967656

phpMyAdmin Installation Record