How to Reset MySQL or MariaDB Root Password in Linux

Posted in Linux Servers on Nov 08, 2019

One of these settings is the password for the database root account – which you must keep private and use only when strictly required.

If you forget the password or need to reset it (for example, when a database administrator changes roles – or is laid off!).

This article will come in handy. We will explain how to reset or recover forgottent MySQL or MariaDB root password in Linux.

Although we will use a MariaDB server in this article, the instructions should work for MySQL as well.

To begin, stop the database service and check the service status, we should see the environment variable we set...

[Read more...]

how to install nodejs and npm on ubuntu

Posted in Linux Servers on Aug 22, 2019

Add Nodejs Package on Server

We are going to add the latest package on server so that we can install latest nodejs

sudo apt-get install curl
curl -sL https://deb.nodesource.com/setup_12.x | sudo -E bash -

Install Node.js on Ubuntu

sudo apt-get install nodejs

Check Node.js Version on server

node -v 

v12.8.0

Check NPM Version on server

npm -v 

6.10.2

Node and NPm is installed sucessfully !! Now we are going to create demo node js server

vim server.js

After creating a file, please add the following content :

var http = require('http');
http.createServer(function (req, res) {
res.writeHead(20...

[Read more...]

How to monitor apache web server load and Page statistics

Posted in Linux Servers on Jul 13, 2019

Mod_status is an Apache module which helps to monitor web server load and current httpd connections with an HTML interface which can be accessible via a web browser.

Enable mod_status in Apache

vi /etc/httpd/conf/httpd.conf

Search for the word “mod_status” or keep scrolling down until you find below line and remove # in order to enable mod_status.

Configure mod_status

Search for the word "location" and put these lines in order to configure mod_status.

After this, define the same configuration for each virtual host file for any domain configured in apache. Like for example : www.exa...

[Read more...]

managed Cpanel cloud server

Posted in Linux Servers on Feb 25, 2019

Buy 20 Gb Ram Cpanel cloud server in India INR 4100 per month along with 24/7 tech support services. Cpanel cloud server is best for web hosting & business application hosting services.

Visit: https://www.cloudtechtiq.com/vps-hosting-india

Services Cloudtechtiq offers:

• Linux VPS Hosting
• Windows Dedicated Hosting
• SSL Certificates
• Managed AWS Cloud
• Microsoft Office 365
• Microsoft Azure

[Read more...]

How To Reset Root Password On CentOS 7

Posted in Linux Servers on Jan 24, 2019

To get started, turn on the machine that you’ve forgotten the root password on. For CentOS 7 devices, you’ll be given 5 seconds at the boot menu to select the operating system kernel to boot into.

That 5 seconds is important, because allows for admins to select different kernels or edit existing kernel parameters before booting.

At the boot menu, press e to edit the existing kernel (Core) as shown below.

Next, scroll down to the list until you see the line underlined below ( ro ) . What we need to do is change that ro to rw and start into a bash shell. It should look like this rw init=/sysro...

[Read more...]

How to manage csf via command line in linux server

Posted in Linux Servers on Jan 02, 2019

We can install the csf firewall to secure the Linux servers. We can manage the firewall via command line easily. Please read our the following article and command structure.

Start the firewall rules

Csf -s

Example: #csf -s

Flush/Stop firewall rules (note: lfd may restart csf)

csf -f

Example: #csf -f

Restart the firewall rules

csf -r

Example: #csf -r

Deny an IP and add to /etc/csf/csf.deny

csf -d 

Example: #csf -d 103.129.97.14

Flush all IPs from the temporary IP entries

csf -tf

Example: #csf -tf

Remove an IP from the temporary IP ban or allow list

csf -tr

Example: #csf -tr 103.129.97.14

Al...[Read more...]

Wishing you and your family a Merry Christmas

Posted in Linux Servers on Dec 25, 2018

We would like to make the better use of this opportunity and congratulate our partners, who are benefited from our work. Hope for a better performing season in the new year.

[Read more...]

How to export import a MySQL database via SSH

Posted in Linux Servers on Nov 16, 2018

In this article, we will cover exporting and importing a database via SSH. Make sure that you replace the following variables in the commands below:

USERNAME - the MySQL user assigned to your database.

DATABASE - the name of your MySQL database.

Exporting a MySQL database

To export a MySQL database, you need to use the mysqldump command. Here is the full command for exporting your database:

mysqldump -uUSERNAME -p DATABASE > backup.sql

You will be prompted for a password - this is your MySQL user's password.

The MySQL database will be exported to a file named "backup.sql" in your current dire...

[Read more...]

How to Schedule a Backup of All MySQL Databases on Ubuntu

Posted in Linux Servers on Nov 16, 2018

Step 1: Create the Backup Script

Create a folder to store your backup script in. I suggest /scripts for this example: sudo mkdir /scripts

Create a file called mysql-backup.sh inside the scripts folder:

sudo vim /scripts/mysql-backup.sh

Add the following code to the file and save it:

#!/bin/bash
#----------------------------------------
# OPTIONS
#----------------------------------------
USER='root'       # MySQL User
PASSWORD='webdev' # MySQL Password
DAYS_TO_KEEP=0    # 0 to keep forever
GZIP=1            # 1 = Compress
BACKUP_PATH='/backups/mysql'
#----------------------------------------

...

[Read more...]

How to Schedule a Backup of All Websites Hosted on Ubuntu

Posted in Linux Servers on Nov 15, 2018

Step 1: Create the Backup Script

The first thing we need to do is create a simple backup script that will backup websites located in /var/www. The script will change into the directory and then loop through archiving each folder into /backups/www. It will also be able to cleanup backups older than X days.

Create a folder to store your backup script in. I suggest /scripts for this example:

sudo mkdir /scripts

Create a file called www-backup.sh inside the scripts folder:

sudo vim /scripts/www-backup.sh

Add the following code to the file and save it:

#!/bin/bash
#--------------------------------...

[Read more...]