MariaDB for Ubuntu 16.04 TLS

Install

apt-get install mariadb-server

Init Set Password

mysql_secure_installation

• Enter current password for root (enter for none)：Enter
• Set root password? [Y/n] y
• Remove anonymous users? [Y/n] y
• Disallow root login remotely? [Y/n] y
• Remove test database and access to it? [Y/n] y
• Reload privilege tables now? [Y/n] y

Error #1

[Warning] ‘user’ entry root@localhost’ has both a password and an authentication plugin specified. The password will be ignored.

update mysql.user set plugin='' where User='root';
flush privileges;

FROM : virzz.com | Author:Virink