Install phpMyAdmin on CentOS7

Install phpMyAdmin on CentOS7

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!