Shulou(Shulou.com)06/01 Report--

This article mainly introduces the relevant knowledge of "how to install phpMyAdmin in Cetons". The editor shows you the operation process through an actual case. The method of operation is simple and fast, and it is practical. I hope this article "how to install phpMyAdmin in Cetons" can help you solve the problem.

PhpMyAdmin is a very popular web-based MySQL database management tool. It can create and delete databases, create / delete / modify tables, delete / edit / add fields, execute SQL scripts, etc.

The disadvantage of PhpMyAdmin is that it must be installed in the Web server, so without proper access, other users may compromise SQL data.

Installation environment

Deploy LAMP on the same host

Linux (CentOS 7.3), Apache (httpd2.4), MariaDB (5.5), PHP (5.4)

Host IP:192.168.29.110

Download the source package

Download the phpMyAdmin source package phpMyAdmin-4.0.10.20-all-languages.tar on the official website http://www.phpmyadmin.net/

1 install the software

(1) install LAMP

[root@centos7 ~] # yum install httpd php mariadb-server-y

(2) install the extension package for php linked database

[root@centos7 ~] # yum install php-mysql

(3) install the package that supports multi-byte string extension

[root@centos7 ~] # yum install php-mbstring-y

(4) install packages that support multiple encryption extensions

[root@centos7 ~] # yum install php-mcrypt-y2 phpmyadmin configuration

(1) decompress the file

Extract phpMyAdmin-4.0.10.20-all-languages.tar to apache's DocumentRoot directory (/ var/www/html)

[root@centos7] # tar-xf phpMyAdmin-4.0.10.20-all-languages.tar.gz-C / var/www/html/

(2) copy the simple configuration file config.sample.inc.php of phpmyadmin as the default configuration file

[root@centos7] # cp-a / var/www/html/phpMyAdmin-4.0.10.20-all-languages/config.sample.inc.php / var/www/html/phpMyAdmin-4.0.10.20-all-languages/config.inc.php

(3) Edit configuration file config.inc.php

[root@centos7 ~] # vim / var/www/html/phpMyAdmin-4.0.10.20-all-languages/config.inc.php

(4) create soft links

[root@centos7] # ln-s / var/www/html/phpMyAdmin-4.0.10.20-all-languages/ / var/www/html/pma

3 Database MariaDB configuration

(1) start the database service

[root@centos7 ~] # systemctl start mariadb.service

(2) set the database root password

[root@centos7 ~] # mysqladmin-u root password 'centos'4 starts the WEB service

[root@centos7 ~] # systemctl start httpd.service

5 Test

(1) enter http://192.168.29.110/pma/ in the browser

(2) Log in with root user

This is the end of the introduction to "how Cetons installs phpMyAdmin". Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.