How to install phpmyadmin using yum

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

(1) Install Remi source

CentOS 6.5 epel and remi source.

# 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 for 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 modifications;

// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
// $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
// $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
// $cfg['Servers'][$i]['relation'] = 'pma_relation';
// $cfg['Servers'][$i]['table_info'] = 'pma_table_info';
// $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
// $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
// $cfg['Servers'][$i]['column_info'] = 'pma_column_info';
// $cfg['Servers'][$i]['history'] = 'pma_history';

去掉每行前面的//

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

$cfg['Servers'][$i]['controluser'] ='pma';Change pma to your account

$cfg['Servers'][$i ]['controlpass'] ='pmapass'; Set pmapass as your mysql login password

$cfg['blowfish_secret'] =''; Add a phrase password, but any string. For example: $cfg[ After modifying 'blowfish_secret'] = 'abcd', it will be much more convenient to log in to phpMyAdmin in the future, but be sure not to use an empty password.

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

This file is the access control file of phpMyAdmin to ensure remote access. Just modify it as follows:

<Directory /usr/share/phpMyAdmin/>
   Order Deny,Allow
   #Deny  from All
   Allow from All
</Directory>

(4) Use the command /etc/init.d/httpd restart to restart Apache.

The following problems may occur:

1. If the php-mcrypt package is not installed when installing php, an error message may appear. In this case, 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 For http, restart Apache. When accessing http://ip address/phpMyAdmin/, a dialog box will pop up. You can enter your username and password to enter phpMyAdmin.

3. If after modifying the above two steps, you are still prompted that phpMyAdmin refuses access, then it is likely that the cookie is to blame. Open the browser, select Tools, click Internet Options and then select General to delete cookies. Then visit http://ip address/phpMyAdmin/

(5) After successfully logging in to phpMyAdmin, if it prompts "Configuration of pmadb... error", perform the following operations:

a. Command line Log in to mysql: mysql -uroot -p

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

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

source /usr/share/phpMyAdmin/sql/create_tables.sql

d. Access phpMyAdmin. If it still doesn’t work, restart Apache and try again.

For more phpmyadmin related technical articles, please visit the phpmyadmin tutorial column!

The above is the detailed content of How to install phpmyadmin using yum. For more information, please follow other related articles on the PHP Chinese website!