INR
USD- Add 'skip-grant-tables' to my.cnf under the [mysqld] section
- restart mysql
- type mysql with no password and hit enter
- Run This:
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:
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',
...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 nodejsCheck Node.js Version on server
node -v
v12.8.0Check NPM Version on server
npm -v
6.10.2Node and NPm is installed sucessfully !! Now we are going to create demo node js server
vim server.jsAfter creating a file, please add the following content :
var http = require('http');
http.createServer(function (req, res) {
res.writeHead(200...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.confSearch 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.
[Read more...]After this, define the same configuration for each virtual host file for any domain configured in apache. Like for example : www.exam...
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
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 -sExample: #csf -s
Flush/Stop firewall rules (note: lfd may restart csf)
csf -fExample: #csf -f
Restart the firewall rules
csf -rExample: #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 -tfExample: #csf -tf
Remove an IP from the temporary IP ban or allow list
csf -trExample: #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.
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 databaseTo 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.sqlYou 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.shAdd 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'
#----------------------------------------
#...