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 phpmyadmin
Command to reconfigure phpmyadmin. Then we should be able to open it smoothly.