phpmyadmin - Operate MySQL with Web Browser

Install phpmyadmin to operate MySQL from Web browser. Web server is required.

[1] Install and configure phpmyadmin

[root@www ~]# yum -y install phpmyadmin php-mysql php-mcrypt

[root@www ~]# vi /usr/share/phpmyadmin/config.inc.php

# line 16: set password
$cfg['blowfish_secret'] = 'password';

[root@www ~]# vi /etc/httpd/conf.d/phpmyadmin.conf

# line 8: add IP address you allow
Allow from

# line 11: add alias
Alias /mysql /usr/share/phpmyadmin

[root@www ~]# /etc/rc.d/init.d/httpd reload
Reloading httpd: [ OK ]

[2] Access to 'http://(your hostname or IP address)/(alias name you set)/' with web browser,then following screen is shown. Login with a user in MySQL.

[3] Just logined. You can operate MySQL on here.

No comments:

Post a Comment