PhpMyAdmin is a PHP-based, web-base-style MySQL database management tool that is architected on a Web site host, allowing administrators to manage the MySQL database using a Web interface. This web interface can be an easy way to enter complex SQL syntax, especially to handle the import and export of large amounts of data. One of the bigger advantages is that because phpMyAdmin is executed on the Web server like any other PHP program, you can use the HTML pages generated by these programs anywhere, that is, to manage the MySQL database remotely, to easily create, modify, and delete databases and data tables. It is also possible to build common PHP syntax by phpMyAdmin, which is convenient for writing web pages with the correct SQL syntax.
Environment Introduction;
System Environment: CentOS 7
installation process
1. Install the required packages
# yum install httpd mariadb mariadb-server php php-mbstring php-mysql-y
2. Unzip the phpMyAdmin package and copy it to the Apache root directory
# tar ZXVF phpmyadmin-xxx
# MV Phpmyadmin-xxx/var/www/html/phpmyadmin
3. Edit the Apache configuration file and load the PHP module so that it can parse the PHP program
# vim/etc/httpd/conf.d/php.conf
Add an Line:loadmodule php5_module/usr/lib64/httpd/modules/libphp5.so
4. Edit phpMyAdmin configuration file, configure access path and MARIADB user name password and other information
# cp/var/www/html/phpmyadmin/libraries/config.default.php \
/var/www/html/phpmyadmin/config.inc.php
# vim/var/www/html/phpmyadmin/config.inc.php
$cfg [' pmaabsoluteuri '] = '; ==> \
$cfg [' pmaabsoluteuri '] = ' http://localhost/phpmyadmin/';
$cfg [' blowfish_secret '] = '; ==> \
$cfg [' blowfish_secret '] = ' your secret password ';
$cfg [' Servers '] [$i] [' auth_type '] = ' config '; ==> \
$cfg [' Servers '] [$i] [' auth_type '] = ' cookie ';
$cfg [' Servers '] [$i] [' user '] = '; ==> $cfg [' Servers '] [$i] [' user '] = ' root ';
$cfg [' Servers '] [$i] [' password '] = '; ==> \
$cfg [' Servers '] [$i] [' password '] = ' your MySQL password ';
5. Start the MARIADB program
# Systemctl Start mariadb
6. Initializing the MARIADB database
# mysql_secure_installation
7. Launch Apache Program
# Systemctl Start httpd
Test:
1. Open the browser and enter the following URL
Web Site:http://localhost/phpmyadmin
MySQL can be managed by entering the MySQL username and password.
Summarize:
The program is very powerful, but it is not recommended to novice database users to use the tool, or use the command line to manually write SQL statements to learn better! If you start with the tool, it is not conducive to the nature of learning! If it is a developer, do not want to learn the database, you can use the tool to operate, the efficiency is quite high!
This article is from the "Keyman" blog, make sure to keep this source http://keyman.blog.51cto.com/9807984/1600819
CentOS7 installation PhpMyAdmin