Virink's Blog logo

Virink's Blog

Let life be beautiful like summer flowers, and death like autume leaves.

 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;
本文标题 : MariaDB for Ubuntu 16.04 TLS
文章作者 : Virink
发布时间 :  
最后更新 :  
本文链接 : https://www.virzz.com/2017/04/11/mariadb_for_ubuntu_16.04_tls.html
转载声明 : 转载请保留原文链接及作者。
转载说明 : 本卡片有模板生成,本人转载来的文章请忽略~~