Hack The Sec-Leading Resource Of Linux Tutorial: phpmyadmin

How To Install phpMyAdmin on Ubuntu 22.04

<p style="text-align: center;"><b><u><span style="font-family: verdana; font-size: large;"> How To Install phpMyAdmin on Ubuntu 22.04</span></u></b></p><p style="text-align: left;"><span style="font-family: verdana; font-size: large;">PhpMyAdmin is a free and open source administration tool for MySQL and MariaDB. It's an excellent tool for browsing, editing, creating, and dropping tables, as well as modifying columns and data. You don't need to login into execute any query from the MySQL command line.  As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services.</span></p><p><span style="color: #2b00fe; font-family: verdana; font-size: large;"><b>Step 1 – Install Apache and PHP</b></span></p><p><span style="font-family: verdana; font-size: large;">We are assuming you already have installed the MySQL server on Ubuntu system if you haven't then <a href="https://www.hackthesec.co.in/2023/05/how-to-install-mysql-server-on-ubuntu.html" target="_blank">install from here </a>So just install the other required packages to run and access phpMyAdmin.</span></p><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; color: #f8f8f2; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="font-family: verdana; font-size: large;"><code class="language-markup" style="box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal; word-spacing: normal;">[<a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none;">root@hackthesec</a> ~]# </code>sudo apt install apache2 wget unzip</span></pre><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; color: #f8f8f2; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="font-family: verdana; font-size: large;"><code class="language-markup" style="box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal; word-spacing: normal;">[<a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none;">root@hackthesec</a> ~]# </code>sudo apt install php php-zip php-json php-mbstring php-mysql </span></pre><p><span style="font-family: verdana; font-size: large;">Once the installation is finished, enable and start the Apache web server.</span></p><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; color: #f8f8f2; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="font-family: verdana; font-size: large;"><code class="language-markup" style="box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal; word-spacing: normal;">[<a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none;">root@hackthesec</a> ~]# </code>sudo systemctl enable apache2 </span></pre><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; color: #f8f8f2; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="font-family: verdana; font-size: large;"><code class="language-markup" style="box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal; word-spacing: normal;">[<a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none;">root@hackthesec</a> ~]# </code>sudo systemctl start apache2 </span></pre><div><span style="font-family: verdana; font-size: large;">Step 2 – Install phpMyAdmin on Ubuntu 22.04</span></div><p><span style="font-family: verdana; font-size: large;">You can quickly install the phpMyAdmin from the default Ubuntu repositories. But they contain an older version of phpMyAdmin. you can install the older using this command <b>apt install phpMyAdmin</b>, but to install the latest version, you need to download it from the official website.</span></p><p><span style="font-family: verdana; font-size: large;">Download the latest phpMyAdmin archive from the <a href="https://www.phpmyadmin.net/downloads/" target="_blank">official download page</a>.</span></p><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="font-family: verdana; font-size: large;"><code class="language-markup" style="box-sizing: border-box; color: #f8f8f2; direction: ltr; hyphens: none; line-height: 1.2; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal; word-spacing: normal;">[<a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none;">root@hackthesec</a> ~]# wget https://files.phpmyadmin.net/phpMyAdmin/5.2.0/phpMyAdmin-5.2.0-all-languages.zip 
[<a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none; word-spacing: normal;">root@hackthesec</a><span style="word-spacing: normal;"> ~]# </span>unzip phpMyAdmin-5.2.0-all-languages.zip 
[<a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none; word-spacing: normal;">root@hackthesec</a><span style="word-spacing: normal;"> ~]# </span>sudo mv phpMyAdmin-5.2.0-all-languages /usr/share/phpmyadmin 
</code><code class="language-markup" style="box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; white-space: normal; word-break: normal;">
</code></span></pre><div><div><span style="font-family: verdana; font-size: large;">Next, create tmp directory and set the proper permissions. This is a necessary step to make it work properly.</span></div></div><div><span style="font-family: verdana; font-size: large;"><br /></span></div><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="font-family: verdana; font-size: large;"><code class="language-markup" style="box-sizing: border-box; color: #f8f8f2; direction: ltr; hyphens: none; line-height: 1.2; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal; word-spacing: normal;">[<a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none; word-spacing: normal;">root@hackthesec</a><span style="word-spacing: normal;"> ~]# </span></code><span style="color: #f8f8f2;"><span>sudo mkdir /usr/share/phpmyadmin/tmp 
</span></span><span style="color: white;">[</span><a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none; word-spacing: normal;">root@hackthesec</a><span style="color: #f8f8f2; word-spacing: normal;"> ~]# </span><span style="color: #f8f8f2;"><span>sudo chown -R www-data:www-data /usr/share/phpmyadmin 
</span></span><span style="color: white;">[</span><a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none; word-spacing: normal;">root@hackthesec</a><span style="color: #f8f8f2; word-spacing: normal;"> ~]#</span><span style="color: #f8f8f2;"><span>sudo chmod 777 /usr/share/phpmyadmin/tmp</span></span></span></pre><div><div><b><span style="color: #2b00fe; font-family: verdana; font-size: large;">Step 3 – Configure phpMyAdmin</span></b></div><div><span style="font-family: verdana; font-size: large;"><br /></span></div><div><span style="font-family: verdana; font-size: large;">Now, you need to configure the webserver to serve phpMyAdmin on the network. Create an Apache configuration file for phpMyAdmin and edit it in a text editor:</span></div></div><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="font-family: verdana; font-size: large;"><span style="color: white;">[</span><a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none; word-spacing: normal;">root@hackthesec</a><span style="color: #f8f8f2; word-spacing: normal;"> ~]# sudo </span><span style="color: #f8f8f2;"><span>nano /etc/apache2/conf-available/phpmyadmin.conf</span></span></span></pre><p><span style="font-family: verdana; font-size: large;">add the below content to the file.</span></p><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="color: white; font-family: verdana; font-size: large;">Alias /phpmyadmin /usr/share/phpmyadmin
Alias /phpMyAdmin /usr/share/phpmyadmin
 
<Directory /usr/share/phpmyadmin/>
   AddDefaultCharset UTF-8
   <IfModule mod_authz_core.c>
      <RequireAny>
      Require all granted
     </RequireAny>
   </IfModule>
</Directory>
 
<Directory /usr/share/phpmyadmin/setup/>
   <IfModule mod_authz_core.c>
     <RequireAny>
       Require all granted
     </RequireAny>
   </IfModule>
</Directory></span></pre><p><span style="font-family: verdana; font-size: large;">Save and exit after that reload or restart the apache2 once using below command also you have to enable the newly created config file </span></p><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="font-family: verdana; font-size: large;"><span style="color: white;">[</span><a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none; word-spacing: normal;">root@hackthesec</a><span style="color: #f8f8f2; word-spacing: normal;"> ~]# </span><span style="color: #f8f8f2;"><span>sudo a2enconf phpmyadmin 
</span></span><span style="color: white;">[</span><a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none; word-spacing: normal;">root@hackthesec</a><span style="color: #f8f8f2; word-spacing: normal;"> ~]# </span><span style="color: #f8f8f2;"><span>sudo systemctl restart apache2</span></span></span></pre><p><span style="font-family: verdana; font-size: large;">Step 4 – Adjusting FirewallD</span></p><p><span style="font-family: verdana; font-size: large;">The systems with enabled firewalls need to allow HTTP service from the firewall. Run the below commands to open a port for the webserver in the firewall.</span></p><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="font-family: verdana; font-size: large;"><span style="color: white;">[</span><a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none; word-spacing: normal;">root@hackthesec</a><span style="color: #f8f8f2; word-spacing: normal;"> ~]# </span><span style="color: #f8f8f2;"><span>sudo firewall-cmd --permanent --add-service=http</span></span></span></pre><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="font-family: verdana; font-size: large;"><span style="color: white;">[</span><a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none; word-spacing: normal;">root@hackthesec</a><span style="color: #f8f8f2; word-spacing: normal;"> ~]# </span><span style="color: #f8f8f2;"><span>sudo firewall-cmd --reload </span></span></span></pre><p><span style="font-family: verdana; font-size: large;">Step 5 – Create a MySQL Database and User</span></p><p><span style="font-family: verdana; font-size: large;">Connect to the MySQL server running on your system.</span></p><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="font-family: verdana; font-size: large;"><span style="color: white;">[</span><a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none; word-spacing: normal;">root@hackthesec</a><span style="color: #f8f8f2; word-spacing: normal;"> ~]# mysql</span></span></pre><p><span style="font-family: verdana; font-size: large;"> If you already setup the root password for mysql then you have to use </span></p><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="font-family: verdana; font-size: large;"><span style="color: white;">[</span><a class="token email-link" href="https://www.hackthesec.co.in/2023/02/root@hackthesec" style="background-color: transparent; box-sizing: border-box; color: #007abe; text-decoration-line: none; word-spacing: normal;">root@hackthesec</a><span style="color: #f8f8f2; word-spacing: normal;"> ~]# mysql -uroot -p</span></span></pre><p><span style="font-family: verdana; font-size: large;">Execute the following MySQL queries one by one to create a database and user. Also, assign the privileges to the user on the database. </span></p><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="color: white; font-family: verdana; font-size: large;">mysql> CREATE DATABASE  hackthesec;
Query OK, 1 row affected (0.01 sec)
 
mysql> CREATE USER 'hackthesec'@'localhost' IDENTIFIED BY 'Strong@password';
Query OK, 0 rows affected (0.01 sec)
 
mysql> GRANT ALL ON hackthesec.* TO 'hackthesec'@'localhost';
Query OK, 0 rows affected (0.01 sec)
 
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)</span></pre><p><span style="font-family: verdana; font-size: large;">Step 6 – Access phpMyAdmin</span></p><p><span style="font-family: verdana; font-size: large;"></span></p><p><span style="font-family: verdana; font-size: large;">All done. You have finished the setup with the phpMyAdmin on the Ubuntu Linux system. Now access phpMyAdmin with the server IP address or domain name.</span></p><pre class="language-markup" style="background: rgb(39, 40, 34); border-radius: 0.3em; box-sizing: border-box; direction: ltr; hyphens: none; line-height: 1.2; margin-bottom: 20px; margin-top: 0px; max-width: 100%; overflow: auto; padding: 10px; tab-size: 4; text-shadow: rgba(0, 0, 0, 0.3) 0px 1px; word-break: normal;"><span style="color: white; font-family: verdana; font-size: large;">http://your-server-ip-domain/phpmyadmin
</span></pre><div><span style="font-family: verdana; font-size: large;"><br /></span></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s508/login_phpmyadmin_www.hackthesec.co.in.png" style="margin-left: 1em; margin-right: 1em;"><span style="font-family: verdana; font-size: large;"><img border="0" data-original-height="508" data-original-width="483" height="315" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/w450-h315/login_phpmyadmin_www.hackthesec.co.in.png" width="450" /></span></a></div><div class="separator" style="clear: both; text-align: left;"><span style="font-family: verdana; font-size: large;">@hackthesecurity</span></div>

How To Install phpMyAdmin on Ubuntu 22.04

How To Install phpMyAdmin on Ubuntu 22.04 PhpMyAdmin is a free and open source administration tool for MySQL and MariaDB. It's an excel...

How to Install and Configure phpMyAdmin on Fedora 21

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; border: 0px; box-sizing: inherit; font-family: proxima-nova, sans-serif; line-height: 3.4rem; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-size: large;"><u>Install and Configure phpMyAdmin on Fedora</u></span></h1>
<div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
<span style="background-color: transparent; font-size: 15px; line-height: 26px;"><span style="color: #222222;"><b>phpMyAdmin </b>is a free and open source tool written in PHP intended to handle the administration of <span style="color: #999999;">MySQL</span> or <a href="http://www.hackthesec.co.in/search/label/MaraiDB">MariaDB </a>with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions</span></span><span style="color: #222222; font-size: 15px; line-height: 26px;">.</span></div>
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" imageanchor="1" style="color: #999999; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" style="border: 1px solid rgb(192, 192, 192); height: auto; max-width: 95%; padding: 4px; transition: all 0.4s ease-in-out;" /></a></div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
<span style="color: #222222; font-size: 15px; line-height: 26px;"><br /></span></div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
<span style="color: #0b5394; font-family: 'Trebuchet MS', sans-serif; font-size: medium;"><span style="line-height: 26px;"><b><u>Features</u></b></span></span></div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; line-height: 19.2px;">
<ul style="font-size: 12px;">
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Web interface</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">MySQL and MariaDB database management</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Import data from CSV and SQL</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Export data to various formats: CSV, <a href="http://www.hackthesec.co.in/search/label/sql" style="color: #999999; text-decoration: none;">SQL</a>, XML, PDF (via the TCPDF library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LaTeX and others</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Administering multiple servers</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Creating PDF graphics of the database layout</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Creating complex queries using Query-by-Example (QBE)</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Searching globally in a database or a subset of it</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Live charts to monitor MySQL server activity like connections, processes, CPU/Memory usage, etc.</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Working with different operating systems</span></li>
</ul>
<div style="line-height: 19.2px;">
<span style="color: #0b5394; font-family: 'Trebuchet MS', sans-serif;"><span style="line-height: 26px;"><u><span style="font-size: large;">Install phpMyAdmin</span></u></span></span></div>
<div style="font-size: 12px; line-height: 19.2px;">
<span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">First, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new.</span></span></div>
<div style="line-height: 19.2px;">
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span><span style="color: white;"><span style="line-height: 15.6px;">yum -y update</span></span></span></pre>
</div>
<div style="font-size: 12px;">
<span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">After That Run Following Command:-</span></span></div>
</div>
<div style="line-height: 19.2px;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span><span style="line-height: 15.6px;"><span style="color: white;">yum -y install </span><span style="color: orange;">phpmyadmin</span></span></span></pre>
</div>
<div style="font-size: 12px; line-height: 19.2px;">
<span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">To secure <b>phpMyAdmin </b>we should lock down access to a specific IP address. When the phpMyAdmin package is installed, an Apache Virtual Host file is added to configure web access. Let’s edit that file:</span></span></div>
<div style="line-height: 19.2px;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# vi </span><span style="line-height: 15.6px;"><span style="color: white;">/etc/httpd/conf.d/</span><span style="color: lime;">phpMyAdmin.conf</span></span></span></pre>
</div>
<div style="font-size: 12px; line-height: 19.2px;">
<span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">By default, the configuration for phpMyAdmin only allows access from the server on which it is installed. so you want to allow for all or you can only use your IP address for access..</span></span></div>
</div>
</div>
<div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
<span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;"><div>
Require ip 127.0.0.1</div>
<div>
<br /></div>
<div>
Allow from 127.0.0.1</div>
<div>
<br /></div>
<div>
Require ip 127.0.0.1</div>
<div>
<br /></div>
<div>
Allow from 127.0.0.1</div>
<div>
Allow from your IPadress ... </div>
<div>
Or </div>
</span></span></div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
<span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">Just Commit the following line </span></span><span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">"</span></span><span style="background-color: transparent; font-size: 15px; line-height: 26px;"><b><span style="color: red;">Deny from All</span></b><span style="color: #222222;">"</span></span></div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; line-height: 19.2px;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"> <span style="font-size: large;"><IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
</span></span><span style="font-size: large;"><span style="color: lime;">     #Deny from All
</span><span style="color: white;">     Allow from 127.0.0.1
     Allow from ::1
   </IfModule></span></span></span><span style="font-family: 'Times New Roman'; font-size: 12px;"><span style="white-space: normal;"></span></span></pre>
<div style="font-size: 12px;">
<span style="color: #222222; font-family: 'Trebuchet MS', sans-serif; font-size: medium;"><span style="line-height: 26px;"><b><u>Restart Apache:</u></b></span></span></div>
</div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; line-height: 19.2px;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6px;"><span style="font-size: large;">service httpd restart</span></span></span></pre>
<div>
<div>
<span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">Verify that phpMyAdmin is working by visiting http://the_IP_of_your_server/phpmyadmin. </span></span></div>
<div style="font-size: 12px;">
<span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">For example: http://demo.hackthesec.co.in/phpmyadmin</span></span></div>
</div>
</div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
<span style="color: #222222; font-size: 15px; line-height: 26px;"><span style="color: #999999;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></span></div>
</div>
</div>

How to Install and Configure phpMyAdmin on Fedora 21

Install and Configure phpMyAdmin on Fedora phpMyAdmin is a free and open source tool written in PHP intended to handle the administrat...

How to Install and Configure phpMyAdmin on CentOS 6

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; border: 0px; box-sizing: inherit; font-family: proxima-nova, sans-serif; line-height: 3.4rem; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-size: large;"><u>Install and Configure phpMyAdmin on CentOS</u></span></h1>
<div>
<div style="background-color: white;">
<span style="background-color: transparent; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><b>phpMyAdmin </b>is a free and open source tool written in PHP intended to handle the administration of <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a> or <a href="http://www.hackthesec.co.in/search/label/MaraiDB">MariaDB </a>with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions</span></span><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">.</span></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" /></a></div>
<div style="background-color: white;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;"><br /></span></div>
<div style="background-color: white;">
<span style="color: #0b5394; font-family: Trebuchet MS, sans-serif; font-size: large;"><span style="line-height: 26px;"><b><u>Features</u></b></span></span></div>
<div style="background-color: white;">
<ul style="text-align: left;">
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Web interface</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">MySQL and MariaDB database management</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Import data from CSV and SQL</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Export data to various formats: CSV, <a href="http://www.hackthesec.co.in/search/label/sql">SQL</a>, XML, PDF (via the TCPDF library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LaTeX and others</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Administering multiple servers</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Creating PDF graphics of the database layout</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Creating complex queries using Query-by-Example (QBE)</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Searching globally in a database or a subset of it</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Live charts to monitor MySQL server activity like connections, processes, CPU/Memory usage, etc.</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Working with different operating systems</span></li>
</ul>
<div style="background-color: white;">
<span style="line-height: 26px;"><span style="color: #0b5394; font-family: Trebuchet MS, sans-serif; font-size: large;"><b><u>Add the EPEL Repository</u></b></span></span></div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/search/label/phpmyadmin">phpMyAdmin </a>is part of Extra Packages for Enterprise Linux (<a href="http://www.hackthesec.co.in/search/label/EPEL">EPEL</a>), which is a community repository of non-standard packages for the <a href="http://www.hackthesec.co.in/search/label/RHEL">RHEL</a> distribution. First, we’ll install the EPEL repository:</span></div>
<div style="background-color: white;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span><span style="color: white;"><span style="line-height: 15.6px;">rpm -iUvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm</span></span></span></pre>
</div>
<div style="background-color: white;">
<span style="color: #0b5394; font-family: Trebuchet MS, sans-serif; font-size: large;"><span style="line-height: 26px;"><u>Install phpMyAdmin</u></span></span></div>
<div style="background-color: white;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">First, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new.</span></span></div>
<div style="background-color: white;">
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span><span style="color: white;"><span style="line-height: 15.6px;">yum -y update</span></span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">After That Run Following Command:-</span></span></div>
</div>
<div style="background-color: white;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span><span style="line-height: 15.6px;"><span style="color: white;">yum -y install </span><span style="color: orange;">phpmyadmin</span></span></span></pre>
</div>
<div style="background-color: white;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">To secure <b>phpMyAdmin </b>we should lock down access to a specific IP address. When the phpMyAdmin package is installed, an Apache Virtual Host file is added to configure web access. Let’s edit that file:</span></span></div>
<div style="background-color: white;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# vi </span><span style="line-height: 15.6px;"><span style="color: white;">/etc/httpd/conf.d/</span><span style="color: lime;">phpMyAdmin.conf</span></span></span></pre>
</div>
<div style="background-color: white;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">By default, the configuration for phpMyAdmin only allows access from the server on which it is installed. so you want to allow for all or you can only use your IP address for access..</span></span></div>
<div style="background-color: white;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div>
Require ip 127.0.0.1</div>
<div>
<br /></div>
<div>
Allow from 127.0.0.1</div>
<div>
<br /></div>
<div>
Require ip 127.0.0.1</div>
<div>
<br /></div>
<div>
Allow from 127.0.0.1</div>
<div>
Allow from your IPadress ... </div>
<div>
Or </div>
</span></span></div>
<div style="background-color: white;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Just Commit the following line </span></span><span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">"</span></span><span style="background-color: transparent; font-size: 15px; line-height: 26px;"><span style="font-family: Verdana, Geneva, sans-serif;"><b><span style="color: red;">Deny from All</span></b><span style="color: #222222;">"</span></span></span></div>
<div style="background-color: white;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: medium;"><span style="line-height: 15.6px;"><span style="color: white;"> <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
</span><span style="color: lime;">     #Deny from All
</span><span style="color: white;">     Allow from 127.0.0.1
     Allow from ::1
   </IfModule></span></span></span><span style="font-family: Times New Roman;"><span style="white-space: normal;">
</span></span></pre>
<div>
<span style="color: #222222; font-family: Trebuchet MS, sans-serif; font-size: large;"><span style="line-height: 26px;"><b><u>Restart Apache:</u></b></span></span></div>
</div>
<div style="background-color: white;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 15.6px;">service httpd restart</span></span></pre>
<div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Verify that phpMyAdmin is working by visiting http://the_IP_of_your_server/phpmyadmin. </span></span></div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">For example: http://demo.hackthesec.co.in/phpmyadmin</span></span></div>
</div>
</div>
<div>
<span style="color: #222222; font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></div>
</div>

How to Install and Configure phpMyAdmin on CentOS 6

Install and Configure phpMyAdmin on CentOS phpMyAdmin is a free and open source tool written in PHP intended to handle the administrati...

How to install phpMyAdmin on ubuntu 14.04

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #990000; font-size: x-large;"><u>phpMyAdmin on ubuntu 14.04</u></span><br />
<span style="color: #990000; font-size: x-large;"><u><br /></u></span>
<a href="http://www.phpmyadmin.net/home_page/index.php" rel="nofollow" style="background-color: white; color: #0f4884; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px; text-decoration: none;" title="phpmyadmin">Phpmyadmin</a><span style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"> is a free web tool used to administrative MySQL database. You can perform all major tasks like creating , deleting  and modifying databases. you can also repair and optimize tables with a single click .</span><br />
<strong style="background-color: white; display: block; font-family: Arial, sans-serif; margin: 0px 0px 3px; padding: 0px; text-decoration: none;"></strong><br />
<ul style="text-align: left;">
<li><strong style="background-color: white; display: block; font-family: Arial, sans-serif; margin: 0px 0px 3px; padding: 0px; text-decoration: none;"><strong style="display: inline !important; margin: 0px 0px 3px; padding: 0px;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-phpmyadmin-on-centos-7.html" style="margin: 0px; padding: 0px; text-decoration: none;"><span style="color: red; font-size: large;">How to install <mark style="display: inline; margin: 0px; padding: 0px;">phpmyadmin</mark> on centos 7</span></a></strong></strong></li>
</ul>
<div>
<br /></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" /></a></div>
<span style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"><br /></span>
<div style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;">
</div>
<h3 style="background-color: white; color: #0f4884; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 18px; font-weight: normal; height: auto; line-height: 28px; margin: 0px; padding: 0px; width: 614px;">
<u>Install phpmyadmin on ubuntu 14.04 :</u></h3>
<div style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;">
Before proceeding with phpmyadmin installation, you must have webserver configured in your machine .Here we choose <a href="http://www.hackthesec.co.in/2016/01/how-to-install-php-54-apache-22-and.html">LAMP</a> ( Apache, Mysql and PHP ) stack for webserver . Please follow the links to configure LAMP server . <a href="http://www.hackthesec.co.in/2016/01/how-to-install-php-54-apache-22-and.html">LAMP Installation</a> </div>
<div style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;">
<br /></div>
<div style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;">
<span style="color: #222222;">After configuring <a href="http://www.hackthesec.co.in/2016/01/how-to-install-php-54-apache-22-and.html">LAMP</a> server, you can continue with below steps to install and configure phpmyadmin.</span><br /><span style="color: #0b5394;">Step 1 : </span><span style="color: #222222;">Update repositories using the below command</span><br /><code style="background-color: #0e0e0e; border-radius: 5px; display: block; font-family: Verdana, 'MS Sans Serif', sans-serif, serif; font-size: 14px; line-height: 25px; padding: 4px;"><span style="color: white;">root@hackthesec:~$ sudo </span><span style="color: lime;">apt-get update</span></code><br /><span style="color: #0b5394;">Step 2 :</span><span style="color: #222222;"> Issue the below command to install phpmyadmin .</span><br /><code style="background-color: #0e0e0e; border-radius: 5px; display: block; font-family: Verdana, 'MS Sans Serif', sans-serif, serif; font-size: 14px; line-height: 25px; padding: 4px;"><span style="color: white;">root@hackthesec:~$ sudo </span><span style="color: lime;">apt-get install</span><span style="color: white;"> phpmyadmin</span></code><br /><span style="color: #0b5394;">Step 3 :</span><span style="color: #222222;"> During the installation, You will prompted to choose the type of web server . just choose “</span><span style="color: red;">apache2</span><span style="color: #222222;">”.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8PT7SUlQnMVLCn75KlhaucC-J7xwQlDWoLP-eEI3AUL59Pyy70uOUZmEUWgURASu-A9IfXUoYK1qq_vasvg_2BIn5XtvEo2m9WJXv3_Ja0MpqKGmVVa5r_JNu52mnYM0v_Hr99XXbO9R-/s1600/Install-phpmyadmin-ubuntu14-04-1-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8PT7SUlQnMVLCn75KlhaucC-J7xwQlDWoLP-eEI3AUL59Pyy70uOUZmEUWgURASu-A9IfXUoYK1qq_vasvg_2BIn5XtvEo2m9WJXv3_Ja0MpqKGmVVa5r_JNu52mnYM0v_Hr99XXbO9R-/s1600/Install-phpmyadmin-ubuntu14-04-1-www.hackthesec.co.in.png" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="color: #0b5394;"><span style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px; text-align: start;">S</span><span style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px; text-align: start;">tep 4</span><span style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px; text-align: start;"> </span><span style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px; text-align: start;">:</span></span><span style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px; text-align: start;"> Now you will be prompted for mysql database configuration, just choose “No” as we already configured mysql server manually and hit enter to complete the installation.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVXWh5KnWGEeKMgtNjBAAUOaM9H-UcVwZfxc17CUYN-L_02H-WNCkYtqk4cNbPG3XwWjgB-R6dvv5f9CHWdLplo9wcLJmzVw9iZrPWNsTWIiOsxNI9EFbdiP-OiNmrMxpF1V_G_S9H5Ipt/s1600/Install-phpmyadmin-ubuntu-14-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVXWh5KnWGEeKMgtNjBAAUOaM9H-UcVwZfxc17CUYN-L_02H-WNCkYtqk4cNbPG3XwWjgB-R6dvv5f9CHWdLplo9wcLJmzVw9iZrPWNsTWIiOsxNI9EFbdiP-OiNmrMxpF1V_G_S9H5Ipt/s1600/Install-phpmyadmin-ubuntu-14-www.hackthesec.co.in.png" /></a></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="background-color: white; color: #993300; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="color: #0b5394;"><span style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;">Step 5</span><span style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"> :</span></span><span style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"> That’s it, now open the path “</span><strong style="background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;"><em><span style="color: red;">http://localhost/phpmyadmin</span></em></strong><span style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;">” in the browser , you will prompted for username and password . just type Mysql root username and password given during the Mysql installation. Now after successfull login , you can see the screen like below .</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGmnnnFYrv_KhbsyQn4fD-YMrWz9dlU3sYSvAUS3jx6ftL78bkN2jppqKv_O0LIoFzZCqJ_uuwHn-RYnGWrTSYFNiu5qZKDsOoXIjH7huq53J9fyiM0_SFp27wAIAZbv4e6rPA0J1aYcgF/s1600/install-phpmyadmin-centos-7_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGmnnnFYrv_KhbsyQn4fD-YMrWz9dlU3sYSvAUS3jx6ftL78bkN2jppqKv_O0LIoFzZCqJ_uuwHn-RYnGWrTSYFNiu5qZKDsOoXIjH7huq53J9fyiM0_SFp27wAIAZbv4e6rPA0J1aYcgF/s1600/install-phpmyadmin-centos-7_www.hackthesec.co.in.png" /></a></div>
<div style="background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; line-height: 30px;">
</div>
<div style="-webkit-text-stroke-width: 0px; background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 30px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
</div>
<br />
<div style="-webkit-text-stroke-width: 0px; background-color: white; color: #222222; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 30px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<br /></div>
<div style="-webkit-text-stroke-width: 0px; background-color: white; font-family: Trebuchet, 'Trebuchet MS', Arial, Verdana, sans-serif; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 30px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;">
<span style="color: #222222;">If you are getting “</span><span style="color: #38761d;">Page not found</span><span style="color: #222222;">” issue .Include the below line in</span><strong style="color: #222222;">/etc/apache2/apache2.conf</strong><span style="color: #222222;"> file.</span><br /><code style="background-color: #0e0e0e; border-radius: 5px; display: block; font-family: Verdana, 'MS Sans Serif', sans-serif, serif; font-size: 14px; line-height: 25px; padding: 4px;"><span style="color: white;">Include /etc/</span><span style="color: lime;">phpmyadmin/apache.conf</span></code><br /><span style="color: #222222;">and restart apache2 service</span><br /><code style="background-color: #0e0e0e; border-radius: 5px; display: block; font-family: Verdana, 'MS Sans Serif', sans-serif, serif; font-size: 14px; line-height: 25px; padding: 4px;"><span style="color: white;">sudo /etc/init.d/</span><span style="color: lime;">apache2</span><span style="color: white;"> restart</span></code><code style="background-color: #0e0e0e; border-radius: 5px; display: block; font-family: Verdana, 'MS Sans Serif', sans-serif, serif; font-size: 14px; line-height: 25px; padding: 4px;"><span style="color: white;"><br /></span></code><code style="background-color: #0e0e0e; border-radius: 5px; display: block; font-family: Verdana, 'MS Sans Serif', sans-serif, serif; font-size: 14px; line-height: 25px; padding: 4px;"><span style="color: white;"><a href="http://www.hackthesec.co.in/p/about-us.html">Hack The Security</a><br /><a href="https://www.twitter.com/hackthesecurity">Hack The Security Twitter.com</a></span></code></div>
</div>

How to install phpMyAdmin on ubuntu 14.04

phpMyAdmin on ubuntu 14.04 Phpmyadmin is a free web tool used to administrative MySQL database. You can perform all major tasks like cre...

How to install phpmyadmin on centos 7

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<span style="font-family: "trebuchet" , "trebuchet ms" , "arial" , "verdana" , sans-serif; font-size: 30px; line-height: 31px;"><span style="color: #990000;">Install phpmyadmin on centos 7</span></span></div>
<div style="text-align: center;">
<span style="font-family: "trebuchet" , "trebuchet ms" , "arial" , "verdana" , sans-serif; font-size: 30px; line-height: 31px;"><span style="color: #990000;"><br /></span></span></div>
<div style="text-align: left;">
<span style="background-color: white; color: #333333; font-family: "roboto slab"; font-size: 16px; line-height: 28px;"><a href="http://www.phpmyadmin.net/" target="_blank">Phpmyadmin</a> is an opensource tool to manage <a href="http://www.hackthesec.co.in/search/label/Mysql" target="_blank">MySQL</a> database using web browser.</span></div>
<div style="background-color: white; border: 0px; color: #333333; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
it can perform almost all tasks such as creating,deleting,modifying databases,users,tables and fields .</div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "roboto slab";"><span style="background-color: white; line-height: 28px;"><span style="font-size: large;">This guide helps you to install phpmyadmin on <a href="http://www.hackthesec.co.in/search/label/Centos" target="_blank">centos 7</a>. it contains step by step installation through YUM using EPEL repository.</span></span></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "roboto slab";"><span style="background-color: white; line-height: 28px;"><span style="font-size: large;"><br /></span></span></span><strong style="font-family: Verdana, Geneva, sans-serif; line-height: 19.2000007629395px;"><span style="color: red; display: inline; font-family: "open sans" , serif , sans-serif; font-stretch: normal; line-height: 1.4em; margin: 0px; max-height: 200px; overflow: visible; text-decoration: none;"><span style="line-height: 1.4em; max-height: 200px;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-lamp-apache-24-mysql-56.html" target="_blank">How to Install LAMP (Apache 2.4, MySQL 5.6, and PHP 5.4) on CentOS/RHEL 7</a></span></span></strong></div>
<div style="text-align: left;">
<strong style="font-family: Verdana, Geneva, sans-serif; line-height: 19.2000007629395px;"><br /></strong></div>
<div style="text-align: left;">
<strong style="background-color: white; font-family: Verdana, Geneva, sans-serif; line-height: 19.2000007629395px;"><a class="titlex" href="http://www.hackthesec.co.in/2016/01/how-to-install-lamp-apache-24-mysql-56.html" style="display: block; font-family: 'Open Sans', serif, sans-serif; font-stretch: normal; line-height: 1.4em; margin: 0px; max-height: 200px; overflow: visible; text-decoration: none;"></a><a class="titlex" href="http://www.hackthesec.co.in/2016/01/how-to-install-lamp-apache-24-mysql-56.html" style="display: inline !important; font-stretch: normal; line-height: 1.4em; margin: 0px; max-height: 200px; overflow: visible; text-decoration: none;"></a></strong></div>
<div class="separator" style="clear: both; text-align: center;">
<strong style="background-color: white; font-family: Verdana, Geneva, sans-serif; line-height: 19.2000007629395px;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNwOQO6gfdYtrDV28BiI5f9hO9AAn3RhKOO73nHMK-aboQ3L1Cw0cWU1u_6lJSgNX0AeIiR2vL7mNGhyphenhyphen-ttCWcHhOoQ-6SJZSnum-5EBaYU7E9vK9MizzlPifG0s1McucKLDYUK_Xp7mQI/s1600/login_phpmyadmin_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNwOQO6gfdYtrDV28BiI5f9hO9AAn3RhKOO73nHMK-aboQ3L1Cw0cWU1u_6lJSgNX0AeIiR2vL7mNGhyphenhyphen-ttCWcHhOoQ-6SJZSnum-5EBaYU7E9vK9MizzlPifG0s1McucKLDYUK_Xp7mQI/s1600/login_phpmyadmin_www.hackthesec.co.in.png" /></a></strong></div>
<div style="color: #333333; font-size: 12px;">
<strong style="background-color: white; font-family: Verdana, Geneva, sans-serif; line-height: 19.2000007629395px;"><br /></strong></div>
<br />
<div>
<h2 class="heading1" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-stretch: normal; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="background-color: transparent; line-height: 34px;"><span style="color: red; font-family: "roboto slab"; font-size: x-large;">Prerequisite – LAMP server</span></span></h2>
<div style="background-color: white; border: 0px; color: #333333; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
Before starting phpmyadmin installation, You must setup LAMP server on your <a href="http://www.hackthesec.co.in/2016/01/how-to-install-lamp-apache-24-mysql-56.html" target="_blank">centos 7</a> server. Copy and paste below command in terminal for quick setup . At the end, you need to provide some inputs .</div>
<div style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333;">» </span><b><span style="color: blue;">leave blank for current mysql password.</span></b></div>
<div style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="color: #333333;">» </span><span style="color: blue;">provide new password and press enter for the rest.</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: 12px;"># </span><span style="font-size: large;"><span style="color: white;">yum -y </span><span style="color: lime;">install httpd</span><span style="color: white;"> mariadb-server mariadb php php-mysql php-gd php-pear php-mbstring && systemctl start httpd.service && systemctl enable httpd.service && systemctl start mariadb && systemctl enable mariadb && firewall-cmd --permanent --add-service http && systemctl restart firewalld.service && mysql_secure_installation</span></span><span style="color: white; font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; color: #333333; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
By default, centos 7 repository does not contains phpmyadmin package. we need to enable EPEL repository. Find the latest EPEL for centos 7 from <a href="http://www.hackthesec.co.in/2016/01/how-to-install-epel-repo-on-centos-and.html" target="_blank">EPEL for Centos 7</a></div>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<h2 class="heading1" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: normal; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394; font-family: "roboto slab"; font-weight: bolder; line-height: 34px;">Step 1: </span><span style="font-family: "roboto slab";"><span style="line-height: 34px;"><span style="color: #0b5394;">Download and install </span><span style="color: red;">epel-release-7-x.noarch.rpm</span><span style="color: #0b5394;"> file . or install directly by copying the rpm link.</span></span></span></h2>
</div>
</div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white;">[root@hackthesec ~]# </span><span style="color: lime;">rpm -ivh</span><span style="color: white;"> http://epel.mirror.net.in/epel/7/x86_64/e/epel-release-7-1.noarch.rpm</span></span></pre>
</div>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<h2 class="heading1" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: normal; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394; font-family: "roboto slab"; font-weight: bolder; line-height: 34px;">Step 2: </span><span style="color: #0b5394; font-family: "roboto slab";"><span style="line-height: 34px;">Update repositories by issuing below command </span></span></h2>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); font-family: 'Roboto Slab'; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white;">[root@hackthesec ~]# yum </span><span style="color: lime;">check-update</span></span></pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<h2 class="heading1" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: normal; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394; font-family: "roboto slab"; font-weight: bolder; line-height: 34px;">Step 3: </span><span style="color: #0b5394; font-family: "roboto slab";"><span style="line-height: 34px;">Now install phpmyadmin package along with dependencies.</span></span></h2>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); font-family: 'Roboto Slab'; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white;">[root@hackthesec ~]# yum -y install </span><span style="color: lime;">phpmyadmin</span></span></pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<h2 class="heading1" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: normal; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394; font-family: "roboto slab"; font-weight: bolder; line-height: 34px;">Step 4: </span><span style="font-family: "roboto slab";"><span style="line-height: 34px;"><span style="color: #0b5394;">After installation, Open </span><span style="color: red;">/etc/httpd/conf.d/phpMyAdmin.conf</span><span style="color: #0b5394;"> file ( Apache config file for phpmyadmin ) and edit as follows.</span></span></span><span style="color: #0b5394; font-family: "roboto slab"; line-height: 34px;">Find these lines . ( Found 2 times )</span></h2>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; font-family: 'Roboto Slab'; font-size: 12px; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><pre style="background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"># Apache 2.4
     <RequireAny>
       Require ip 127.0.0.1
       Require ip ::1
     </RequireAny> </pre>
</pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: "roboto slab"; font-size: 16px; line-height: 28px;">Replace with </span></div>
<div style="border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<pre style="background-attachment: scroll; background-color: #3c3c3c; background-image: none; background-position: 0px 0px; background-repeat: repeat; border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; font-family: 'roboto slab'; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"># Apache 2.4
    <RequireAny>
      # Require ip 127.0.0.1
      # Require ip ::1
      Require all granted
    </RequireAny></span></pre>
<h2 class="heading1" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; color: black; font-family: 'Times New Roman'; font-size: 16px; font-stretch: normal; line-height: normal; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394; font-family: "roboto slab"; font-weight: bolder; line-height: 34px;">Step 5: </span><span style="color: #0b5394; font-family: "roboto slab";"><span style="line-height: 34px;">Restart Apache service.</span></span></h2>
<pre style="background-attachment: scroll; background-color: #3c3c3c; background-image: none; background-position: 0px 0px; background-repeat: repeat; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: black; font-family: 'roboto slab'; font-size: medium; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white;">[root@hackthesec ~]# systemctl restart httpd.service</span></span></pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; color: black; font-family: 'Times New Roman'; font-size: medium; line-height: normal; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="color: #333333; font-family: 'roboto slab'; line-height: 28px;">
<span style="font-size: large;">Now open http://serverIP/phpmyadmin in your browser. You can login using root as username and mysql root password .</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_cGI1PxQmIJ7U3szB4gdBkBbnXsE4jhZNzEjGFumPO9WKnkMFS6XE5XtRDCtnViBOIQs3SDWPjjtspFHKrwIAFU0IJoZdtsT_QY37e-uMjQiwLlQLehwxTH6UV3Ey27mSvw0OFuQs7FKb/s1600/install-phpmyadmin-centos-7_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_cGI1PxQmIJ7U3szB4gdBkBbnXsE4jhZNzEjGFumPO9WKnkMFS6XE5XtRDCtnViBOIQs3SDWPjjtspFHKrwIAFU0IJoZdtsT_QY37e-uMjQiwLlQLehwxTH6UV3Ey27mSvw0OFuQs7FKb/s1600/install-phpmyadmin-centos-7_www.hackthesec.co.in.png" /></a></div>
<div style="color: #333333; font-family: 'roboto slab'; line-height: 28px;">
<span style="font-size: large;"><br /></span></div>
<br /></div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; font-family: 'roboto slab'; font-size: 12px; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><a href="http://www.hackthesec.co.in/" target="_blank">Hack The Security</a>
<a href="https://www.twitter.com/hackthesecurity" target="_blank">Hack The Security Twitter</a>
<a href="https://www.facebook.com/htsecu" target="_blank">Hack The Security Facebook</a></pre>
</div>
</div>
</div>
</div>
</div>

How to install phpmyadmin on centos 7

Install phpmyadmin on centos 7 Phpmyadmin is an opensource tool to manage MySQL database using web browser. it can perform almost ...