Create a MariaDB Database and User for phpMyAdminĬreate the configuration storage database and tables by running the following command. $cfg = 'pma_navigationhiding' Īdd the following line to bottom of the file. Then uncomment this section of the /usr/share/phpmyadmin/ file will look like as follows: /* Storage database and tables */ Note: Do not re-use 'STRINGOFTHIRTYTWORANDOMCHARACTERS', generate a random 32 character string and use. $cfg = 'STRINGOFTHIRTYTWORANDOMCHARACTERS' /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ nano /usr/share/phpmyadmin/Įnter a string of 32 random characters in between single quotes. Make a copy to the file /usr/share/phpmyadmin/ cp /usr/share/phpmyadmin/ /usr/share/phpmyadmin/Įdit the /usr/share/phpmyadmin/ file as follows using preferred text editor. chown -R www-data:www-data /var/lib/phpmyadmin Make the web server user www-data as the owner of this directory. Let's create a temporary directory for phpMyAdmin storage, create a sub-directroy with the following command. mv phpMyAdmin-* /usr/share/phpmyadmin Configuring phpMyAdmin Move the phpMyAdmin-* to /usr/share/ directory. Then run the following command to download it. Navigate to phpMyAdmin download page to check the latest stable version. PhpMyAdmin isn’t included in Debian 10 software repository, so you'll need to manually download the software. apt install php-mbstring php-zip php-gd Downloading phpMyAdmin Install the required phpMyAdmin packages.

Your Ubuntu system can be updated easily with the following command. We first update the system to make sure that all our installed packages are upto date. We also have the guide for LAMP Stack as well. With phpMyAdmin, managing and administering databases becomes much easier and more efficient, even for users with little or no experience with command-line interfaces.

It is a popular tool among developers, database administrators, and webmasters who work with MySQL or MariaDB databases. PhpMyAdmin is written in PHP and can be installed on any web server that supports PHP and MySQL. It provides an easy-to-use graphical user interface that allows users to perform a wide range of database management tasks, such as creating and modifying tables, running queries, importing and exporting data, and managing users and permissions. PhpMyAdmin is a free, open-source web application for managing and administering MySQL and MariaDB databases.

Download phpmyadmin