Install phpMyAdmin database management tool in Ubuntu 17.10, and 17.10 phpmyadmin

Install phpMyAdmin database management tool in Ubuntu 17.10, and 17.10 phpmyadmin

Different from the database management tools directly used for double-click installation in Windows, the database management tools in Linux seem a little complicated. Due to copyright and billing restrictions, many useful database management tools such as Data Grip and Navicat cannot be directly installed and used in the Linux Package Manager. However, there are still some useful DBMS, and phpmyadmin is one of them.

 

Install LAMP

LAMP is a combination of Linux, Apache, MySql (MariaDB), PHP (Python, Perl) and other software. Now we need to install Ubuntu, so we only need to install the other three software.

sudo apt install mysql-server-5.7 mysql-client-5.7 php7.0 apache2

You may need to configure the software separately.

Configure apache to enable PHP support

Then install the php extension of apache:

sudo apt install libapache2-mod-php7.0

After the installation is complete, restart apache:

sudo systemctl restart apache2

Create a new PHP file in the default directory of apache:

sudo nano /var/www/html/info.php

The file content is as follows:

<?phpphpinfo();?>

Then, check whether info is successful in the browser.
After the operation is successful, do not forget to delete info. php, which contains a lot of sensitive server information.

sudo rm -f /var/www/html/info.php

Enable SSL

Then enable SSL:

sudo a2enmod sslsudo a2ensite default-ssl

Configure PHP to enable PHP Extension

You can also install all the required PHP extensions. The installation may reduce the performance:

sudo apt -y install php7.0-mysql php7.0-curl php7.0-gd php7.0-intl php-pear php-imagick php7.0-imap php7.0-mcrypt php-memcache  php7.0-pspell php7.0-recode php7.0-sqlite3 php7.0-tidy php7.0-xmlrpc php7.0-xsl php7.0-mbstring php-gettext

Restart apache:

sudo systemctl restart apache2

Install APCu

APCu is a cache extension that can cache and optimize PHP intermediate code. It is strongly recommended that you install it.

sudo apt -y install php-apcu

Restart apache:

sudo systemctl restart apache2

Install phpmyadmin

After all the above work is completed, you can install phpmyadmin.

sudo apt -y install phpmyadmin

A graphical interface requires you to enter various configuration options. After the configuration is complete, enter http: // localhost/phpmyadmin/in the browser to enter the phpmyadmin interface. If some steps are not in order, you may not be able to open the web interface smoothly. At this time, you can finish the previous work and then run it.sudo dpkg-reconfigure phpmyadminCommand to reconfigure phpmyadmin. Then we should be able to open it smoothly.