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


apt-get install mariadb-server

Init Set Password

  • 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
发布时间 :  
最后更新 :  
本文链接 :
转载声明 : 转载请保留原文链接及作者。
转载说明 : 本卡片有模板生成,本人转载来的文章请忽略~~