CentOS7 installation PhpMyAdmin

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.