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

    Create DNS records at any DNS hosting provider for Office 365

    Posted in Microsoft Office 365 on Nov 07, 2019

    Create DNS records at any DNS hosting provider for Office 365

    To set the domain in office 365 you need to create the records for domain hosting in office 365.

    When you set up the Domain records yourself, these are the records to add. Note that your verification record and MX record are unique to your domain. To set them up, you'll need to get and use a specific "token" value for your domain. The steps below explain how to do that.

    Following records need to update-

    1. Add a TXT or MX record for verification
    2. Add MX record to route email
    3. Add CNAME records
    4. Add a TXT record for SPF to help prevent em...
    [Read more...]

    G Suite Gmail (MX/SPF) records

    Posted in Smarter Mail on Nov 07, 2019

    If you want to use G suite as an email solution, then you need to update G-suite mail records to your Domain provide.

    To do this, you need to sign in to your domain host and direct the email for your domain to the G Suite servers. It’s like registering your new address with the post office when you move so that your mail gets delivered to the right place.

    Add the G Suite MX records

    To direct your email to your G Suite account, you must add new MX records to your domain. Add the MX records shown in the table below in one step with synthetic records. With synthetic records you can optionally ad...

    [Read more...]

    Set up Mobile Device Management (MDM) in Office 365

    Posted in Microsoft Office 365 on Nov 06, 2019

    Set up Mobile Device Management (MDM) in Office 365

    The built-in Mobile Device Management (MDM) for Office 365 helps you secure and manage your user's mobile devices like iPhones, iPads, Androids, and Windows phones. You can create and manage device security policies, remotely wipe a device, and view detailed device reports.

    Device management is part of the Security & Compliance Center so you'll need to go there to kick off MDM setup.

    To set up Mobile Device Management for Office 365 you'll need to:

    Activate the Mobile Device Management service

    Set up Mobile Device Management

    1. Configure domain...
    [Read more...]

    Reset lost admin password on FortiGate unit (Password Recovery)

    Posted in SSL Certificates on Nov 05, 2019

    Reset a lost admin password on a FortiGate unit (password recovery)

    Periodically a situation arises where the FortiGate needs to be accessed or the admin account’s password needs to be changed but no one with the existing password is available. If a physical access to the device is possible and with a few other tools, the password can be reset.

    By this article method we can reset password of the following FortiGate device –

    1. FortiGate

    2. FortiGate v5.0

    3. FortiGate v5.2

    4. FortiGate v5.4

    5. FortiWiFi v5.0

    6. FortiWiFi v5.2

    7. FortiWiFi v5.4

    What is needed:

    1. Console cable

    2. Terminal software such...

    [Read more...]

    Plesk Installation for Windows server Using Installer GUI

    Posted in Plesk Control Panel on Sep 26, 2019

    Plesk is a commercial web hosting platform with a control panel that allows a server administrator to set up new websites, reseller accounts, e-mail accounts and DNS entries through a web-based interface. The administrator can create client and site templates, which predetermine resource-allocation parameters for the domains and/or clients.

    Plesk offers users the possibility to easily install web applications using the (APS) Application Packaging Standard. APS packages are updated by the packaging vendor when a security update is made available.

    For Plesk installation, you require a fresh Wind...

    [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 install an SSL certificate on SonicWALL?

    Posted in SSL Certificates on Aug 07, 2019

    In order to install an SSL certificate on SonicWALL, perform the below steps -

    • Download issued SSL certificate >> Extract and rename to server.crt

    inst1.jpg

    1. Create a .zip file with two files. Take the .crt downloaded from the SSLs.com Account Panel and also, use server.key generated during CSR creation on your SSL-VPN appliance.
    2. Log into the SonicWALL SSL-VPN appliance portal.
    3. After that, expand the System menu >> click Certificates.
    4. Install CA certificates in order to make your website compatible in browsers.
    5. On the System > Certificates page, in the Additional CA Certificates section > click Impor...
    [Read more...]

    How to install an SSL certificate on Google Cloud Platform?

    Posted in SSL Certificates on Jul 31, 2019

    In order to install an SSL certificate on Google cloud platform, perform the below steps -

    1. Download the archive with the certificate files from your SSLs.com account or from the email sent to you from the CA.
    2. Sign into your Google Cloud account.
    3. Navigate to Products & services >> App Engine as below.

    ggl_cld_1.jpg

    1. App Engine menu >> Open settings >> SSL certificates >> Next page as below.

    1.jpg

    1. Upload a new certificate >> Add a new SSL certificate
    2. Paste Certificate and Private Key codes in the next window.

    ggl_cld_3.jpg

    The Private Key code was generated along with the CSR (Certificate Signing Request) and code inclu...

    [Read more...]