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

This article mainly introduces how to use yum to install phpmyadmin, the article is very detailed, has a certain reference value, interested friends must read it!

After installing Apache, MySQL, and PHP, you can install the latest version of phpMyAdmin using the Remi source.

(1) install Remi source

Epel and remi sources of CentOS 6.5.

# rpm-Uvh http://ftp.iij.ad.jp/pub/linux/fedora/epel/6/x86_64/epel-release-6-8.noarch.rpm# rpm-Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

Source of CentOS 7. 0.

# yum install epel-release# rpm-ivh http://rpms.famillecollet.com/enterprise/remi-release-7.rpm

(2) install phpMyAdmin

# yum install-- enablerepo=remi--enablerepo=remi-php56 phpmyadmin

(3) configure phpMyAdmin

a. Modify / etc/phpMyAdmin/config.inc.php:

Open the config.inc.php file and make the following changes

/ / $cfg ['Servers'] [$I] [' controluser'] = 'pma';// $cfg [' Servers'] [$] ['controlpass'] =' pmapass';// $cfg ['Servers'] [$] [$pmadb'] =' phpmyadmin';// $cfg ['Servers'] [$] [' bookmarktable'] = 'pma_bookmark';// $cfg [' Servers'] [$I] ['relation'] =' pma_relation' / / $cfg ['Servers'] [$I] [' table_info'] = 'pma_table_info';// $cfg [' Servers'] [$] ['table_coords'] =' pma_table_coords';// $cfg ['Servers'] [$] [$pdf_pages'] =' pma_pdf_pages';// $cfg ['Servers'] [$] [' column_info'] = 'pma_column_info';// $cfg [' Servers'] [$I] ['history'] =' pma_history' Remove the / / in front of each line

$cfg ['blowfish_secret'] =''; modified to $cfg ['blowfish_secret'] =' config'

$cfg ['Servers'] [$I] [' controluser'] = 'pma'; change pma to your account

$cfg ['Servers'] [$I] [' controlpass'] = 'pmapass'; set pmapass to your mysql login password

$cfg ['blowfish_secret'] =''; add a phrase password, but any string such as: $cfg ['blowfish_secret'] =' abcd' after modification, it will be much more convenient to log in to phpMyAdmin later, but don't use an empty password.

b. Modify / etc/httpd/conf.d/phpMyAdmin.conf

This file is the access control file of phpMyAdmin, which ensures remote access. Just modify it as follows:

Order Deny,Allow # Deny from All Allow from All

(4) restart Apache with command / etc/init.d/httpd restart.

The following problems may occur:

1. If the php-mcrypt package is not installed when php is installed, there may be an error prompt, so just install it: yum-y install php-mcrypt

2. PhpMyAdmin access is denied

Change the config of $cfg ['Servers'] [$I] [' auth_type'] = 'config'; in the config.inc file to http, restart Apache, and when you access the http://ip address / phpMyAdmin/, a dialog box will pop up to enter the user name and password to enter the phpMyAdmin.

3, if after the above two steps of the changes, still prompt you that phpMyAdmin refused access, then it is likely to be caused by cookie, open the browser, select tools, click the internet option and then select General, delete cookie. Then visit the http://ip address / phpMyAdmin/

(5) after successfully logging in to phpMyAdmin, if you are prompted with "Configuration of pmadb … error", do the following:

a. Log in to mysql:mysql-uroot-p on the command line

b. Create a new database named phpmyadmin: CREATE DATABASE phpmyadmin

c. Import the create_tables.sql in the sql directory under the PHPMyAdmin installation directory into the database phpmyadmin you just created: use phpmyadmin

Source / usr/share/phpMyAdmin/sql/create_tables.sql

d. Visit phpMyAdmin. If it still doesn't work, restart Apache and try again.

The above is all the contents of the article "how to use yum to install phpmyadmin". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

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.