Database management Tools PhpMyadmin

1 overview

PhpMyAdmin is a PHP as a basis to Web-base The way schemas are on the site host MySQL database management tools to make it available to managers Web Interface Management MySQL Database

This article describes how to deploy the PhpMyAdmin

2 deployment phpMyadmin

PhpMyadminThis software is used to manage the database, the implementation of the Web page management, attention to version compatibility issues,PhpMyadminand thePHPcompatibility issues with the version, ifPHPThe version is too low to causePhpMyadminThis package is not compatible, it cannot be used, compatibility issues can be seen in the officialthe https://www.phpmyadmin.net/ page corresponds to the phpMyAdmin version. If Phpshi 5.2--5.4 version. PhpMyadminwith4.0Half version 2.1 Installation related Service Pack

The server has installed four packages httpd php php-mysql php-mbstring, command

Yum-y Install httpd php php-mysql php-mbstring

The software can be installed by default without modifying the configuration, but restarting the service

Systemctl start Httpdsystemctl start mariadb

2.2 Download the source package

Download the source package from the official website https://www.phpmyadmin.net/, but it is a program that can be executed, so you do not need to compile, unzip and put it to the website you want to visit (for example /etc/www/html/ ) directory, configure the configuration file to use

cd/var/www/html/unzip/var/www/html/source/phpmyadmin-4.0.10.20-all-languages.zip# unpack the package to the current directory/var/www/html/LN- s phpmyadmin-4.0.10.20-all-languages/pma# creating a soft link PMA

2.3 Modifying a configuration file

After decompression, the configuration file of the software is modified to configure

CD/VAR/WWW/HTML/PMACP config.sample.inc.php config.inc.php #拷贝配置文件模板vim config.inc.php$cfg[' blowfish_secret '] = ' ABC123A8B7C6D '; /* must FILLIN this for COOKIE auth! */#修改口令abc123a8b7c6d, this password can be entered casually, but be sure to fill in, if it is not empty, change the password a little longer

2.4 Testing

In the browser input HTTP://172.18.50.75/PMA, at this time, enter the database account (root) and password, you can enter the page, the first click, the page needs to load, relatively slow

3 Abnormal error handling

After login, prompt three exception, cause click any button is unable to load, related problem description and solution are as follows

Issue One: PhpMyAdmin advanced features are not fully set and some features are not activated. Please click here to see why.

Solutions

1. Login phpmyadmin, Click Import , select /var/ww/html/phpmyadmin/ Examples/create_tables.sql and execute

when you are done, you can see that there is more than one library phpMyAdmin .

2. Span style= "font-size:15px;" > edit /var/www/html/phpmyadmin/ config.inc.php file ( config.simple.inc.php)

vim  /var/www/html/pma/config.inc.php$cfg[' Servers ' [$i] [' Pmadb '] =  ' phpmyadmin '; $cfg [' Servers '] [$i] [' bookmarktable '] =  ' Pma__bookmark '; $cfg [' Servers '] [$i] [' Relation '] =  ' pma__relation '; $cfg [' Servers '] [$i] [' Table_info '] =  ' pma__ Table_info '; $cfg [' Servers '] [$i] [' table_coords '] =  ' pma__table_coords '; $cfg [' Servers '] [$i] ' pdf_pages '] =  ' pma__pdf_pages '; $cfg [' Servers '] [$i] [' Column_info '] =  ' pma__column_info '; $cfg [' Servers ' [$i] [' History '] =  ' pma__history '; $cfg [' Servers '] [$i] [' table_uiprefs '] =  ' pma__ Table_uiprefs '; $cfg [' Servers '] [$i] [' Tracking '] =  ' pma__tracking '; $cfg [' Servers '] [$i] ' Designer_ Coords '] =  ' pma__designer_coords '; $cfg [' Servers '] [$i] [' userconfig '] =  ' pma__userconfig '; cfg[' Servers ' [$i] [' recent '] =  ' pma__recent '; 

Question two: The Secretpassphrase in Configuration (Blowfish_secret) was too short.

Solutions

vim/var/www/html/pma/config.inc.php$cfg[' blowfish_secret '] = ' abc123a8b7c6d '; /* must FILLIN this for COOKIE auth! */#将这里的密码加长

issue three: missing mcrypt extension. Please check your PHP configuration.

Workaround, install three packages, this three package is a Epel source package

Yum-y Install Php-mcrypt Libmcrypt libmcrypt-devel

This article is from the "Sunshine Ops" blog, please be sure to keep this source http://ghbsunny.blog.51cto.com/7759574/1970714

Database management Tools PhpMyadmin