TO Install php below are the prerequisites For centos 7 install below remi and repo packages ——– yum install https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm yum install http://rpms.remirepo.net/enterprise/remi-release-7.rpm For centos 6 install below remi and [ … ]

Firewalld service not works in centos 6, It works only from centos 7 and higher versions rpm -qa firewalld sudo apt install firewalld $ sudo systemctl start firewalld $ sudo [ … ]

rpm -qa | grep mysql rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm vi /etc/yum.repos.d/remi.repo [remi] name=Remi’s RPM repository for Enterprise Linux 6 – $basearch #baseurl=http://rpms.remirepo.net/enterprise/6/remi/$basearch/ mirrorlist=http://rpms.remirepo.net/enterprise/6/remi/mirror enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-remi yum -y [ … ]

If you have forgotten your root password, then this post for you here’s how to reset it. 1. Shutdown the MySQL service mysqld stop 2. Start mysql in safe mode [ … ]

php -v rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm vi /etc/yum.repos.d/remi.repo [remi-php56] name=Remi’s PHP 5.6 RPM repository for Enterprise Linux 6 – $basearch #baseurl=http://rpms.remirepo.net/enterprise/6/php56/$basearch/ mirrorlist=http://rpms.remirepo.net/enterprise/6/php56/mirror # WARNING: If you enable this [ … ]

how to change listening port in ubuntu vi /etc/ssh/sshd_config # What ports, IPs and protocols we listen for can change here Port 22 sudo systemctl restart sshd how to change [ … ]

upgrade from mysql 5.6 to 5.7 ——————————- moving from 5.5 is a two step process: first follow the relevant procedure for your system above to upgrade to 5.6, then repeat [ … ]

Downgrade from MySql 5.7 to MySql 5.6 Centos 7 ================================================ sudo yum-config-manager –disable mysql57-community sudo yum-config-manager –disable mysql56-community (enable or disable) See what rpm do you have installed and erase [ … ]

In the command line open below config file vi /etc/apt/sources.list http://in.archive.ubuntu.com/ubuntu/ http://security.ubuntu.com/ubuntu In the place of above files i.e in.archive , security Replace with old-releases as below and save the [ … ]

To split csv file Into multiple files in linux split -d -l 100000 file.csv new/file_part_ split -d -l 20000 example.csv /var/lib/mysql-files/split_ output ======== split_00 split_02 split_04 split_06 split_08 split_10