vino

sudo apt install vino http://ftp.debian.org/debian/pool/main/m/minizip/

shortcut to jhcis

 sudo ln -s /home/jhcis/.wine/drive_c/'Program Files'/jhcis-client/jhcis.jar /home/jhcis/Desktop

ubuntu startup command

 https://aur.archlinux.org/packages/overgrive/?O=30&PP=10

Install MySQL 5.6.xx on Ubuntu 18.04

 credit : Anthony Orona 

on https://gist.github.com/Ajorona/e44ca0d0e9cfa055976ea91d9a2cba2a

MySQL Download URL

https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.45-linux-glibc2.12-x86_64.tar.gz

Open the terminal and follow along:

• Uninstall any existing version of MySQL

sudo rm /var/lib/mysql/ -R

• Delete the MySQL profile

sudo rm /etc/mysql/ -R

• Automatically uninstall mysql

sudo apt-get autoremove mysql* --purge
sudo apt-get remove apparmor

• Download version 5.6.45 from MySQL site

wget https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.45-linux-glibc2.12-x86_64.tar.gz

• Add mysql user group

sudo groupadd mysql

• Add mysql (not the current user) to mysql user group

sudo useradd -g mysql mysql

• Extract it

sudo tar -xvf mysql-5.6.45-linux-glibc2.12-x86_64.tar.gz

• Move it to /usr/local

sudo mv mysql-5.6.45-linux-glibc2.12-x86_64 /usr/local/

• Create mysql folder in /usr/local by moving the untarred folder

cd /usr/local/
sudo mv mysql-5.6.45-linux-glibc2.12-x86_64 mysql

• set MySql directory owner and user group

cd mysql/
sudo chown -R mysql:mysql *

• Install the required lib package

sudo apt-get install libaio1

• Execute mysql installation script

sudo scripts/mysql_install_db --user=mysql

• Set mysql directory owner from outside the mysql directory

sudo chown -R root .

• Set data directory owner from inside mysql directory

sudo chown -R mysql data

• Copy the mysql configuration file

sudo cp support-files/my-default.cnf /etc/my.cnf

• Start mysql

sudo bin/mysqld_safe --user=mysql &
sudo cp support-files/mysql.server /etc/init.d/mysql.server

• Set root user password

sudo bin/mysqladmin -u root password '[your new password]'

example : sudo bin/mysqladmin -u root password '123456'

• Add mysql path to the system

sudo ln -s /usr/local/mysql/bin/mysql /usr/local/bin/mysql

• Reboot!

• Start mysql server

sudo /etc/init.d/mysql.server start

• Stop mysql server

sudo /etc/init.d/mysql.server stop

• Check status of mysql

sudo /etc/init.d/mysql.server status

• Enable myql on startup

sudo update-rc.d -f mysql.server defaults

*Disable mysql on startup (Optional)

sudo update-rc.d -f mysql.server remove

• REBOOT!

• Now login using below command, start mysql server if it's not running already

mysql -u root -p

[Addict] Change port and remote access
sudo nano /etc/my.cnf
	[mysqld]
		bind-address = 0.0.0.0
		port = 3333
sudo /etc/init.d/mysql.server restart
mysql --port=3333 -u root -p
UPDATE mysql.user SET Password=PASSWORD('123456') WHERE User='root';
UPDATE mysql.user SET authentication_string=PASSWORD('123456') WHERE User='root';
GRANT ALL PRIVILEGES ON *.* TO root@'%' IDENTIFIED BY '123456';
FLUSH PRIVILEGES;
sudo /etc/init.d/mysql.server restart

last

 mysql --port=3333 -u root -p

sudo nano /etc/my.cnf

sudo /etc/init.d/mysql.server restart

mysql-backup-jhcisdb.sh

 # !/bin/sh

    /usr/local/mysql/bin/mysqldump --skip-comments --default-character-set=utf8 --routines --lock-tables=false --compatible=no_key_options -u root -p123456 jhcisdb > /home/jhcis/Google\ Drive/jhcisbackup/jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql

cd /home/jhcis/Google\ Drive/jhcisbackup/

FILE1=jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").sql

if [ -f "$FILE1" ]; then

     sudo zip -r jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").zip "$FILE1"

fi

cd /home/jhcis/Google\ Drive/jhcisbackup/

FILE2=jhcisdb-03301.$(date -d "+0 day" "+%Y-%m-%d").zip

if [ -f "$FILE2" ]; then

     sudo rm -f /home/jhcis/Google\ Drive/jhcisbackup/jhcisdb-03301.$(date -d "-0 day" "+%Y-%m-%d").sql

     sudo rm -f /home/jhcis/Google\ Drive/jhcisbackup/jhcisdb-03301.$(date -d "-32 day" "+%Y-%m-%d").zip

     sudo rm -f /home/jhcis/Google\ Drive/jhcisbackup/jhcisdb-03301.$(date -d "-33 day" "+%Y-%m-%d").zip

fi

create-pdf.sh

 # !/bin/sh

/opt/lampp/bin/php -f /opt/lampp/htdocs/fpdf17/PhpCreatePdf.php