Tran Nghi's Site  - Make notes and share experience

Install phpmyadmin and some issues

This post is also available in: English

Firstly, I followed this tutorial to install myadmin… link to tutorial

~# apt-get -y install phpmyadmin php-mbstring php-gettext

step1) select which one you using (this example selects apache2)
step2) answer “No” to proceed on this example

Change some settings to enable login to phpMyAdmin with root.. see my previous post here

Secondly, sometime I really get annoying that I have to create a database ‘phpmyadmin’.. so I ran this command – it will create a database ‘phpmyadmin’:

~# mysql -u root -p < /usr/share/phpmyadmin/sql/create_tables.sql

Additional step, if you see something errors like this:

Then, try to edit /etc/phpmyadmin/ (I am using Ubuntu 16.04.3)

$cfg[‘Servers’][$i][‘controluser’] = ‘root’;
$cfg[‘Servers’][$i][‘controlpass’] = ‘<your mysql root’s password>’;

or, just try to create a pma user, and grant  privileges for pma user to database ‘phpmyadmin’. I think that’s it.. will fix that annoying issue.