Restoring deleted 'root' user and password for MySQL

    Posted in Linux Servers on Nov 08, 2019

    If you accidentally deleted the root user on my local setup MySQL running on OS linux. There are no other users created to get back into MySQL. I am sharing solution for the recover the root user. Get someone with SysAdmin rights and do the following:

    1. Add 'skip-grant-tables' to my.cnf under the [mysqld] section
    2. restart mysql
    3. type mysql with no password and hit enter
    4. Run This:
    DELETE FROM mysql.user 
    WHERE  user = 'root' 
          AND host = 'localhost'; 
    
    INSERT INTO mysql.user 
    SET user = 'root', 
        host = 'localhost', 
        password = Password('whatevernewpassword'), 
        Select_priv = 'y',
    ...
    [Read more...]

    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(200...
    [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.

    1.PNG

    Configure mod_status

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

    2.PNG

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

    [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/linux-cloud-servers-india

    Cpanel Cloud Server.jpg

    [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

    All...[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.

    christmas.jpg

    [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 direc...

    [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...]