How to start phpmyadmin installed by 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

# 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 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'] = '';修改为$cfg['blowfish_secret'] = 'config';
$cfg['Servers'][$i]['controluser'] ='pma';把pma修改为你的帐号
$cfg['Servers'][$i]['controlpass'] ='pmapass';把pmapass设置为你的mysql登录密码
$cfg['blowfish_secret'] ='';添加短语密码，可是任意字符串例如：$cfg['blowfish_secret'] = 'abcd'修改以后，
以后登入phpMyAdmin就方便多了，但一定不要使用空密码。

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/>
OrderDeny,Allow
#Deny  from All
Allow from All
</Directory>

(4) Use the command /etc/init.d/httpd restart to restart Apache. Test: visit http://ip address/phpMyAdmin/

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 to http, restart Apache, and access http: //ip address/phpMyAdmin/ will pop up a dialog box, you can enter the user name 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 "Configuration of pmadb... error" is prompted, perform the following operations:

a. Log in to mysql from the command line:

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 into the newly created 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.

PHP Chinese website has a large number of free phpmyadmin introductory tutorials, everyone is welcome to learn!

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