- Add 'skip-grant-tables' to my.cnf under the [mysqld] section
- restart mysql
- type mysql with no password and hit enter
- Run This:
How to configure Nginx
Posted in Linux Servers on Nov 02, 2020
How to configure Nginx as a reverse proxy for Apache on CentOS
Nginx and Apache are powerful web servers. Apache’s power and Nginx’s speed are well known, However, both of them do have drawbacks. Apache is hard on server’s memory while Nginx can’t process PHP on its own and needs the help of the PHP-FPM or similar modules for dynamic content. In this tutorial, we are going to combine the two web servers to get the best result of each other, We are going to set Nginx as our static content processor and Apache to processing the back end and dynamic content.
Install and configure Nginx via below ...[Read more...]
How to Install MariaDB 10.5 on CentOS 8
Posted in Linux Servers on Oct 13, 2020
How to Install MariaDB 10.5 on CentOS 8 | CentOS 7
The stable version of MariaDB 10.5 was released on June 2020 and it will be supported until June 2025. You can see all the new features in MariaDB 10.5 from the changes page. The software can be used free of charge under the conditions of the GNU General Public License Version 2.
There are multiple steps to install MariaDB 10.5 and these are steps:
Step 1. Add MariaDB YUM repository
In Linux whenever you want to install any type of packages you need to install it’s yum repositories. So Run the following commands to add the repository provided ...
[Read more...]Installing and Configuring Pure-FTPD on RHEL / CentOS 7
Posted in Linux Servers on Apr 08, 2020
Step 1: When you are ready to begin, go ahead and install Pure-FTPD using yum on server.
yum install pure-ftpd
Step 2: after installation Edit the default configuration (/etc/pure-ftpd/pure-ftpd.conf) and uncommnet the following lines.
PAMAuthentication yes
PureDB /etc/pure-ftpd/pureftpd.pdb
Save and close the file.
Step 3: Configure Service pure-ftp service
systemctl enable pure-ftpd
systemctl start pure-ftpd
Step 4: Create a new ftp user account for website account using pure-pw.
pure-pw useradd $USERNAME -u $USER -g $GROUP -d /path/to/ftp/directory
For Exmaple : pure-pw useradd rajesh...
[Read more...]
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',...
[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(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.
[Read more...]After this, define the same configuration for each virtual host file for any domain configured in apache. Like for example : www.exa...
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 -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