phpMyAdmin is a Admin panel for MySQL based Database System it has been the most popular Admin Panel for MySQL or Maria-db Database server. that is written using php programming language hence it is called as phpMyAdmin. The PHPmyAdmin is the best in class online dashboard to manage mysql databases graphically without have any knowledge of database queries this enable us to operate the sysadmin with ease this means any one can update the databases restore reload and manage different types of queries within one command. this is use type to manage website with the ease. also found this use fully when it is works.

Configure phpMyAdmin with MySQL

Step-I (Download of phpMyAdmin)
# wget http://kaz.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/4.2.7/phpMyAdmin-4.2.7-all-languages.tar.gz
Step-II (Extract the downloaded tarball archives)
# tar -zxvf phpMyAdmin-4.2.7-all-languages.tar.gz
Step-III (Move to the extracted phpMyAdmin folder to the www directory)
# mv /phpMyAdmin-4.2.7-all-languages/* /var/www/html/phpMyAdmin/
Step-IV (Installation of PHP and PHP-MySQL)
# yum install php-mysql
# yum install php
Step-V (Restart the mysqld and httpd Services)
# service mysqld restart
# service httpd restart
Step-VI (Configure the phpMyAdmin)
# cd /var/www/html/phpMyAdmin/
# cp config.sample.inc.php config.inc.php
# vi config.inc.php
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['blowfish_secret'] = 'auth_type';
Step-VII (Install the php-mcrypt)
# yum install php-mcrypt
Step-VIII ( Login to the phpMyAdmin portal by opening Web browser)

That’s all for now.

Linux File Permissions and Disc Partition on CentOS / RHEL

Previous article

How to Install MySQL Database Server on CentOS / RHEL

Next article

You may also like


Leave a reply

Your email address will not be published. Required fields are marked *

More in Linux