Difference between revisions of "MariaDB: Instalasi"

From OnnoWiki
Jump to navigation Jump to search
(Undo revision 62073 by Onnowpurbo (talk))
 
Line 14: Line 14:
 
  sudo mysql -u root -p
 
  sudo mysql -u root -p
  
  update mysql.user set plugin='' where user='root';
+
  update mysql.user set plugin=’’ where user=’root’;
  
 
Restart
 
Restart
  
 
  /etc/init.d/mysql restart
 
  /etc/init.d/mysql restart

Latest revision as of 11:43, 16 July 2020

Instalasi

sudo apt update
sudo apt -y install mariadb-client mariadb-server

Supaya aman

sudo mysql_secure_installation


Update user root

mysql -u [user] -p
sudo mysql -u root -p
update mysql.user set plugin=’’ where user=’root’;

Restart

/etc/init.d/mysql restart