show grants for Īs you can see, user phpmyadmin has all privileges on database phpmyadmin. Then check the privileges of phpmyadmin user. You can use the following command to log into MariaDB server. If you are curious as I am, you can log into MariaDB and check what privileges phpmyadmin user has been granted. Once this step is done, a new database named phpmyadmin is created and the database user phpmyadmin has necessary privileges to manage this database. Then set a password for the phpmyadmin user in MariaDB/MySQL. In the next screen, select Yes to configure a database for phpMyAdmin with dbconfig-common. Then hit Tab key and Enter to confirm your choice.
(An asterisk * indicates the item is selected). During the installation, it will prompt you to select a web server to configure. The above command will install all necessary dependencies including PHP7 extensions.
so we can easily install it with the command below.
PhpMyAdmin is included in Ubuntu 18.04 software repository. Step 1: Download and Install phpMyAdmin on Ubuntu 18.04 With that out of the way, let’s get started with installing phpMyAdmin.