Difference between revisions of "MariaDB: Instalasi"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) (Undo revision 62073 by Onnowpurbo (talk)) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 7: | Line 7: | ||
sudo mysql_secure_installation | 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 | ||
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