Atur Ulang Kata Sandi Database MySQL di Linux turunan Debian

Berikut Langkah-langkah dalam setup ulang kata sandi MySQL di Linux turunan Debian :

1. Login sebagai Super User dan Matikan service MySQL terlebih dahulu

2. Skip Grant Table dan Login ke Root ( gunakan perintah sudo mysqld_safe --skip-grant-tables
atau sudo mysqld_safe --skip-grant-tables --skip-networking &)

3. Ubah Password MySQL

4. Restart MySQL

5. Cek Login MySQL

Pemasangan PHP SqlServer di Linux Mint 18.1

Berikut Langkah-langkah pemasangannya :

1. Register the Microsoft Linux repositories and add their keys

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - 

curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server-2017.list | sudo tee /etc/apt/sources.list.d/mssql-server-2017.list

2. Install SQL Server

sudo apt-get update 

sudo apt-get install mssql-server

3. Setup SQL Server

sudo /opt/mssql/bin/mssql-conf setup

4. Install PHP 7.0

sudo apt-get -y install php7.0 libapache2-mod-php7.0 mcrypt php7.0-mcrypt php-mbstring php-pear php7.0-dev apache2

5. Install the ODBC Driver and SQL Command Line Utility for SQL Server

curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add - 

curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/mssql-tools.list 

sudo apt-get update 

sudo ACCEPT_EULA=Y apt-get install mssql-tools 

sudo apt-get install unixodbc-dev 

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile 

echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc 

source ~/.bashrc

6. Testing SQL Server

sqlcmd -S localhost -U sa -P yourpassword -Q "SELECT @@VERSION"

7. Install sqlsrv.so

sudo pecl install sqlsrv 

sudo pecl install pdo_sqlsrv 

Note: Jika saat pemasangan terdapat error, coba cek di c++ nya (mpu-nya install g++ terlebih dahulu kemudia eksekusi lagi sqlsrv)

8. Register into php.ini

extension=sqlsrv.so 

extension=pdo_sqlsrv.so

Jika ingin menyalakan, mematikan dan lihat status SQL Server

systemctl start mssql-server 

systemctl stop mssql-server 

systemctl status mssql-server

Sumber Terkait :
https://github.com/Microsoft/msphpsql/issues/298
https://www.microsoft.com/en-us/sql-server/developer-get-started/php/ubuntu/

Mount Partition Drive di Linux Mint 18.1

Berikut langkah-langkah mount:

1. Install program gparted untuk membuat partisi drive baru sudo apt-get install gparted
2. Jalankan program sudo gparted
3. Buat partisi dengan menggunakan gparted
4. Setelah selesai jalankan perintah lsblk untuk melihat status drive
5. Jalankan perintah udisksctl mount -b /dev/sd[b1, b2, etc.] (sesuaikan drive dari perintah lsblk)
6. Partisi seharusnya sudah ada di file manager

Pemasangan NginX pada LinuxMint 18.1

Langkah-langkah pemasangan nginx di LinuxMint 18.1

Base Repository
sudo apt-get install nginx


Nginx Repository
wget http://nginx.org/keys/nginx_signing.key
sudo apt-key add nginx_signing.key
echo "deb http://nginx.org/packages/ubuntu/ xenial nginx" | sudo tee /etc/apt/sources.list.d/nginx.list
echo "deb-src http://nginx.org/packages/ubuntu/ xenial nginx" | sudo tee -a /etc/apt/sources.list.d/nginx.list


Update Repository Index
sudo apt-get update
sudo apt-get install nginx


Start Nginx
sudo systemctl start nginx