Find MySQL Server Version

To find MySQL server version, connect to MySQL, then run

You can also use “mysql –version”

This only show MySQL client version. If you have multiple MySQL server installed or MySQL server is running on another host, this won’t help. MySQL […]

Read More…

mysql root

Change MySQL Password Change MySQL root password MySQL create user with root privileges Reset MySQL root password Reset MySQL root Password Ubuntu 16.04 MySQL 5.7 Reset root password CentOS 7 MySQL 5.7 root password reset How to Reset Root Password in MySQL 8.0 Reset MySQL root password on Bitnami server Change MySQL root password in […]

Read More…

Change MySQL root password

If you have MYSQL root password and want to change MySQL root password, first login to MYSQL with command

Method 1

Method 2

OR

Method 3 Use command

This command will ask for new and old MySQL passowrd. mysql root mysql […]

Read More…

Ubuntu

do-release-upgrade – upgrade ubuntu to next release. If you are using Ubuntu 14.04 LTS, it will upgrade to 16.04 LTS. Install PHP 7.2 on Ubuntu Ubuntu Slow Boot AMD Ryzen 3 2200G on Ubuntu 18.04 Ubuntu AppArmor Install Transmission torrent client on Ubuntu Server Set default PHP version in Ubuntu update-alternatives – Set default applications […]

Read More…

Install PHP 7.2 on Ubuntu

To install PHP 7.2, first add repository with command

Now run apt update

Install PHP 7.2 with command

To install additional modules, run

php […]

Read More…

Install ionCube Loader on CentOS 7

Go to http://www.ioncube.com/loaders.php Download latest version of ionCube Loader

Find out PHP version you are using with command

Here we have PHP version 5.6, now you need to find the available loaders for PHP 5.6 with command

The one we needed is ioncube_loader_lin_5.6.so You need to copy it to PHP extension_dir directory. […]

Read More…

git log

To see got commit log, type

To see logs in one line, run

To see one line grap, use

or

git […]

Read More…

xrdp

xrdp allow you to connect to Linux Desktop using Windows Remote Desktop. First you need to install desktop environment. Installing something light weight like XFCE is better if you are using a remote server.

This will download approx 500 MB of files and install on Ubuntu 16.04. Next install xrdp

You need to […]

Read More…

SMTP

swaks – command line SMTP testing tool. mailtrap – SMTP server for development. Cloud providers like Amazon AWS, Alibaba, Microsoft Azure, Google Cloud and DigitalOcean do not allow you to run your own mail server. If you need to sent an email from your web application, you need to use one of the Transnational Email […]

Read More…