Ubuntu 16.04 installs mariadb and configures phpMyAdmin

First install MARIADB

Apt Install Mariadb-server

Once installed, you can log in and the default root password is empty

Mysql-uroot-p

Then install phpMyAdmin

Apt Install phpMyAdmin

Install the password need to set, I do not set here, empty

Then visit http://localhost/phpmyadmin return 404, the information on the net should be relatively old, have failed, should do so

Under Root permissions

Ln-s/etc/phpmyadmin/apache.conf/etc/apache2/sites-enabled/phpmyadmin.conf

/etc/init.d/apache2 restart

It means to add phpMyAdmin configuration information to Apache, connect to the filename randomly, and then restart the service

And then you can see the phpMyAdmin login interface.

Login with Root will fail at this time, I am logged in with another user

The procedure is to log on to the database as root in the command line, create new users, assign permissions

And then you can log in to phpMyAdmin.

If the user does not have a password, you need to modify the phpMyAdmin configuration so that it supports null password logon, which is prohibited by default

Configuration file in/etc/phpmyadmin/config.inc.php, you can find a line that is commented out

    /* Uncomment the following to enable logging into passwordless accounts, * after taking note of the
     associated Securi Ty risks. * *
    $cfg [' Servers '] [$i] [' allownopassword '] = TRUE;

Here I have removed the comments, and then refresh the page, login, you can go to the main page

The end