Month: November 2019

Cara Reset Passwd Mysql server yang lupa

~ suji2019 ~ Leave a comment

masuk ke terminal linux kemudian ketikan perintah seperti di baawah.

service mysql stop
service mariadb stop
mysqld_safe --skip-grant-tables &

UPDATE user SET password=PASSWORD('PASSWORD_BARU') WHERE user='root';
FLUSH PRIVILEGES;

CREATE NEW USER
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
FLUSH PRIVILEGES;

Lalu restart service mariadb dan mysqlnya

service mysql start
service mariadb start

GET DUMP DATABASES
mysqldump -u root db > save.sql --routines

Install PHP 7.3 / PHP 7.3-FPM With Apache2

~ suji2019 ~ Leave a comment

Step 1: Setup PHP with Apache2 HTTP Server

sudo apt update
sudo apt install apache2
sudo systemctl stop apache2.service
sudo systemctl start apache2.service
sudo systemctl enable apache2.service

Step 2: Install PHP 7.3 with Apache2 Support

sudo apt-get install software-properties-common
sudo add-apt-repository ppa:ondrej/php
sudo apt update

sudo apt-get install php7.3 libapache2-mod-php7.3 php7.3-cli php7.3-mysql php7.3-gd php7.3-imagick php7.3-recode php7.3-tidy php7.3-xmlrpc

Step 3: Configure PHP 7.3 for Apache2

sudo nano /etc/php/7.3/apache2/php.ini

file_uploads = On
allow_url_fopen = On
memory_limit = 256M
upload_max_filesize = 100M
max_execution_time = 360
date.timezone = America/Chicago

sudo systemctl restart apache2.service