Shulou(Shulou.com)05/31 Report--

Editor to share with you how to install phpMyAdmin database management tools in Ubuntu 17.10. I hope you will get something after reading this article. Let's discuss it together.

Unlike the database management tools used directly for double-click installation under Windows, the database management tools under Linux appear to be a little more complex. Due to copyright and fee restrictions, many useful database management tools such as Data Grip and Navicat cannot be installed and used directly in Linux's package manager. However, there are still some useful DBMS,phpmyadmin is one of them.

Install LAMP

LAMP is the combined name of Linux, Apache, MySql (MariaDB), PHP (Python, Perl) and other software. We are going to install it on Ubuntu16.04 now, so we only need to install the other three software.

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

These software may also need to be configured separately, so I won't go into details here.

Configure apache

Enable PHP support

Then install the php extension for apache:

Sudo apt install libapache2-mod-php7.0

Restart apache after the installation is complete:

Sudo systemctl restart apache2

Then create a new PHP file in the default directory of apache:

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

The contents of the document are as follows:

Then check in the browser to see if it was successful: info.

Don't forget to delete info.php after success, which contains a lot of sensitive information about the server.

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

Enable SSL

Then enable SSL:

Sudo a2enmod sslsudo a2ensite default-ssl

Configure PHP

Enable PHP extension

Install the required PHP extensions, or you can install them all, which may degrade 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

Then restart apache:

Sudo systemctl restart apache2

Install APCu

APCu is a caching extension that caches and optimizes PHP intermediate code, and it is highly recommended to install it.

Sudo apt-y install php-apcu

Then restart apache:

Sudo systemctl restart apache2

Install phpmyadmin

When all the above work is done, you can install phpmyadmin.

Sudo apt-y install phpmyadmin

A graphical interface will appear asking you to enter various configuration options. After all the configuration is complete, type http://localhost/phpmyadmin/ in the browser and you should be able to enter the interface of phpmyadmin. If some of the steps are not in order, you may not be able to open the web interface smoothly, so you can finish all the previous work first, and then run the sudo dpkg-reconfigure phpmyadmin command to reconfigure phpmyadmin. And then it should be able to open smoothly.

After reading this article, I believe you have a certain understanding of "how to install phpMyAdmin database management tools in Ubuntu 17.10". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.