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

Source: Internet
Author: User
Tags apcu

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.