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/config.inc.php (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.
Regards,
