Connect with us

Hi, what are you looking for?

Linux

How to Configure phpMyAdmin with MySQL on CentOS 7

What is phpMyAdmin?

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.

Configure phpMyAdmin with MySQL on CentOS/RHEL/Scientific/Oracle Linux 7/6/5

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)

from web browser visit : http://www.yoursite.com/phpMyAdmin/
phpMyAdmin1
Congratulation now you have completed phpMyAdmin installation and configuration with MySQL Database Server.

Comments
Advertisement
Advertisement

Linux

DNF stands Dandified YUM and this is the default package manager for RHEL 8 / CentOS 8.  This tutorial explains you how to create...

Linux

If you forget a root password of your RHEL 8 and CentOS 8 and want to reset the password so that the RHEL 8...

Windows

How to auto upgrade JioFi firmware for JioFi 2 / JioFi 3 / JioFi 4 / JioFi 5 / JioFi 6 and other JioFi...

Linux

How to Upgrade WordPress Server from Ubuntu 16.04 to Ubuntu 18.04. Right now, Ubuntu 18.04 has been released with tons of new features. Upgrading...

Linux

How to Enable TLS 1.3 on Nginx Web Server. Nginx is a ultra fast web server optimized for modern web applications and servers. TLS...

Advertisement

You May Also Like

Windows

How to auto upgrade JioFi firmware for JioFi 2 / JioFi 3 / JioFi 4 / JioFi 5 / JioFi 6 and other JioFi...

Windows

How to download and install the Mobile Intel 4 Series Express Chipset Graphics Drivers for Windows 10.  Windows 10 is the one of the...

Windows

Internet is the most important public network for connecting to the WEB. For internet connection requirement the ISP is required as well as it...

Windows

How to Install and Configure PCSX2 on Windows 10. The Windows 10 is the most recommended operating system for the Games. In stream platform...