Manual install PHP7.4 dan Database MySQL MariaDB server Ubuntu 18

manual_install_php_mysql.sh

timedatectl set-timezone Asia/Jakarta
apt install software-properties-common
add-apt-repository ppa:ondrej/php
apt-get update
apt-get install php7.4-cli php7.4-json php7.4-common php7.4-mysql php7.4-zip php7.4-gd php7.4-mbstring php7.4-curl php7.4-xml php7.4-bcmath
apt-get install php7.4 php7.4-mysql php7.4-cli php7.4-json php7.4-common php7.4-mysql php7.4-zip php7.4-gd php7.4-mbstring php7.4-curl php7.4-xml php7.4-bcmath
php -m
apt update
apt install mysql-server
apt install mariadb-server mariadb-client
mysql_secure_installation
systemctl start mysql.service
apt install mysql-server
mysql
SELECT user,authentication_string,plugin,host FROM mysql.user;
describe mysql.user;
update mysql.user set plugin='mysql_native_password';
UPDATE mysql.user SET authentication_string=password('inipasswordnya!') WHERE user='root';