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

preface

phpMyAdmin is a web-based administration tool for MySQL.

I. Download and configure phpMyAdmin1. Download phpMyAdmin package

~]# wget https://files.phpmyadmin.net/phpMyAdmin/4.0.10.20/phpMyAdmin-4.0.10.20-all-languages.tar.gz

2. Modify configuration file:

deployment package

~]# tar xf tar xf phpMyAdmin-4.0.10.20-all-languages.tar.gz -C /opt

~]# cd /opt

opt]# ln -sv phpMyAdmin-4.0.10.20-all-languages/ phpMyAdmin

generate a random string

~]# openssl rand -hex 16

dd139c3092a3ea7e8909325386656363

~]# cp /opt/phpMyAdmin/conf.simple.inc.php /opt/phpMyAdmin/conf.inc.php

~]# vim /opt/phpMyAdmin/conf.inc.php

$cfg['blowfish_secret'] = '53a2d0539062db50ff4406176ab2faad';

$cfg['Servers'][$i]['host'] = '192.168.196.220';

The first parameter is used for cookie authentication; the second parameter is used to set the mysql host that needs to be managed.

II. Configuration php1. Install dependent packages

~]# yum -y install php php-mysql php-mbstring php-mcrypt php-fpm

2. start the service

~]# service php-fpm start

III. Configure Nginx1. modify the configuration file

~]# vim /etc/nginx/conf.d/default.conf

server { ... location /phpMyAdmin { index index.php; root /opt/phpMyAdmin; location ~ \.php$ { fastcgi_index index.php; fastcgi_pass 127.0.0.1:9000; fastcgi_param SCRIPT_FILENAME $document_root$script_script_name; include fastcgi_params; } } ...}

Yes can be accessed at http://IP/phpMyAdmin

2. Reload configuration file

~]# nginx -t Check syntax

~]# nginx -s reload reload configuration file

IV. Assign MySQL account

mysql> GRANT ALL ON . TO 'php_user'@'192.168.% ' IDENTIFIED BY 'php_pass';

This command runs on MySQL that needs to be managed. This username and password is the login username and password.

v. login

PHP connect mysql driver, php cannot connect mysql without installation.

Errors encountered 1. php-mbstring package not installed

2. php-mysql is not installed

resources

php Configuration File Description: https://docs.phpmyadmin.net/zh_CN/latest/setup.html#quick-install

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.