Install phpMyAdmin on CentOS7

Source: Internet
Author: User
PhpMyAdmin is a MySQL database management tool based on PHP and based on Web-Base architecture on the website host. it allows managers to use Web interfaces to manage MySQL databases. By using this Web interface, you can become a better way to easily input complicated SQL syntax, especially to process the import and export of a large amount of data. One of the biggest advantages is that phpMyAdmin runs on the web server like other PHP programs, but you can use these programs to generate

PhpMyAdmin is a MySQL database management tool based on PHP and based on Web-Base architecture on the website host. it allows managers to use Web interfaces to manage MySQL databases. By using this Web interface, you can become a better way to easily input complicated SQL syntax, especially to process the import and export of a large amount of data. One of the biggest advantages is that phpMyAdmin runs on the web server like other PHP programs, but you can use the HTML pages generated by these programs anywhere, that is, remote management of MySQL databases, allows you to easily create, modify, and delete databases and data tables. You can also use phpMyAdmin to create common php syntaxes to facilitate the correctness of the SQL syntaxes required for compiling webpages.

 

Environment introduction;

System environment: CentOS 7

 

Installation process

1. install the required software package

# Yum install httpd mariadb-server php-mbstring php-mysql-y

2. decompress 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 The phpmyadmin configuration file and configure the access path and mariadb username and password.

# 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'] = 'cooker ';
$ 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. initialize the mariadb database.

# Mysql_secure_installation

7. start the Apache program
# Systemctl start httpd

 

Test:

1. open your browser and enter the following URL

Web site: http: // localhost/phpmyadmin

Enter the mysql User name and password for mysql management.

 

Summary:

This program is very powerful, but it is not recommended for beginners to use this tool. it is better to use the command line to manually write SQL statements! If you use this tool from the beginning, it is not conducive to learning the essence! If you are a developer and do not want to learn databases, you can use this tool to perform operations, which is very efficient!

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.