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

This article will explain in detail how to start yum and install phpmyadmin for you. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

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

# yuminstall--enablerepo=remi--enablerepo=remi-php56phpmyadmin

(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 / / $cfg before each line ['blowfish_secret'] =''; change it 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' is modified to make it much easier 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:

OrderDeny,Allow#Deny from AllAllow from All

(4) restart Apache with command / etc/init.d/httpd restart, test: access http://ip address / phpMyAdmin/

The following problems may occur:

1. If the php-mcrypt package is not installed when you install php, you may get an error prompt, so just install it:

Yum-y install php-mcrypt

2.phpMyAdmin access 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 you are still prompted to deny access by phpMyAdmin after the changes in the above two steps, it is likely to be caused by cookie. Open the browser, select the tool, click the internet option, and then select General to 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 on the command line:

Mysql-uroot-p

b. Create a new database named phpmyadmin:

CREATE DATABASE phpmyadmin

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

Use phpmyadminsource / usr/share/phpMyAdmin/sql/create_tables.sql

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

On how to start yum installation phpmyadmin to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.