Be sure to make sure MySQL users have the privileges required. PhpMyAdmin is now installed and configured. Restart Apache for your changes to be saved: $ sudo systemctl restart apache2 This can be done by running the following command: $ sudo phpenmod mbstring You may need to explicitly enable the mbstring PHP extension if it has not been previously enabled. The phpMyAdmin Apache configuration file will be added to the /etc/apache2/conf-enabled/ directory.

Choose and confirm a MySQL application password for phpMyAdmin.

Select Yes when asked whether to use dbconfig-common to set up the database.

For the server selection, choose apache2.

Php-mbstring and php-gettext extensions will only be installed if they are not already installed.įollow the prompts in order to configure your installation correctly with the following hints: $ sudo apt install phpmyadmin php-mbstring php-gettext Use the following commands: $ sudo apt update The process involves updating your server’s package index and then using apt install them on your Ubuntu system. The steps to install the latest phpMyAdmin will be highlighted later in this tutorial. This will not install the latest available phpMyAdmin version. PhpMyAdmin can be installed from the default Ubuntu repositories. Default Step (Optional) - Installing phpMyAdmin If you have the above in place you are ready to proceed.

This is because phpMyAdmin communicates directly with your MySQL installation, uses MySQL credentials to authenticate as well as create users, databases, and their objects, as well as executes and returns results for SQL queries. We will also recommend you have an existing domain configured with an SSL/TLS certificate. $ sudo vi /etc/httpd/conf.d/phpmyadmin.How to install the latest PHPMyAdmin on Ubuntu 18.04 Hence, simply create a new file with the below command in it and paste the code in the 'nf' file as well. It tells Apache where the PHPMyAdmin file is located, as well as how the request should be handled. $ sudo chmod 777 /usr/share/phpmyadmin/tmpįinally, an Apache configuration file for phpMyAdmin is required to access it through the web interface. $ sudo chown -R apache:apache /usr/share/phpmyadmin Set up a Temporary Directory for PHPMyAdmin and assign its permissions. Failure to declare the above temp directory may result in an error and may prevent access to phpMyAdmin.

Download phpmyadmin ubuntu