phpMyAdmin – A software to manage MySql Database


Read {count} times since 2020

If you want to manage your MySql table you can use a software called phpMyAdmin. You can install phpMyAdmin in any Operating Systems. This tutorial will help you to install phpMyAdmin in Linux.

<h2 id="require" style="font-family: sans-serif; max-width: 70em;">
  Requirements
</h2>

<ul style="font-family: sans-serif; margin: 1em; max-width: 70em;">
  <li style="margin-top: 0.5em;">
    <b>PHP</b> <ul style="margin: 1em 1em 0px; max-width: 70em;">
      <li style="margin-top: 0.5em;">
        You need PHP 5.2.0 or newer, with&nbsp;<tt>session</tt>&nbsp;support&nbsp;and the Standard PHP Library (SPL) extension.
      </li>
      <li style="margin-top: 0.5em;">
        To support uploading of ZIP files, you need the PHP&nbsp;<tt>zip</tt>&nbsp;extension.
      </li>
      <li style="margin-top: 0.5em;">
        For proper support of multibyte strings (eg. UTF-8, which is currently default), you should install mbstring and ctype extensions.
      </li>
      <li style="margin-top: 0.5em;">
        You need GD2 support in PHP to display inline thumbnails of JPEGs ("image/jpeg: inline") with their original aspect ratio
      </li>
      <li style="margin-top: 0.5em;">
        When using the "cookie"&nbsp;authentication method, the&nbsp;<tt>mcrypt</tt>&nbsp;extension is strongly suggested for most users and is&nbsp;<b>required</b>&nbsp;for 64–bit machines. Not using mcrypt will cause phpMyAdmin to load pages significantly slower.
      </li>
      <li style="margin-top: 0.5em;">
        To support upload progress bars.
      </li>
    </ul>
  </li>
  
  <li style="margin-top: 0.5em;">
    <b>MySQL</b>&nbsp;5.0 or newer (details);
  </li>
  <li style="margin-top: 0.5em;">
    <b>Web browser</b>&nbsp;with cookies enabled.
  </li>
</ul>
Press ALT + CTRL + T.
You will get the Terminal window.
Type the command shown below.

sudo apt-get install phpmyadmin

Press Enter and the installation will begin.
You will get a setup window during the installation. Type in the details and continue the installation.
One of the setup process will ask for MySql Database password and username so be careful not to type in the wrong password or username.
After installation go to localhost/phpmyadmin.
You will get a page of a login screen.

Type the username and password of MySql Database. Press Go and you will enter in to phpMyAdmin. That’s it.
In the next tutorial I will tell you how to use phpMyAdmin.