Sunday 23 September 2018

How to fix Authentication refused: bad ownership or modes for directory

This is common issue faced while configuring public-key authentication for other users. Incorrect permission on $HOME/.ssh/ directory and $HOME/.ssh/authorized_keys is root which cause permission denied.

Saturday 22 September 2018

How to install Screen utility in CentOS 7

Screen utility allows running multi-tasking environment and keeping processes running in the background. By default, package is not available in Centos distribution. Follow the below article to installed.

How to enable timestamp in command history CentOS 7

By default, time stamp information is not associated with executed history commands. To enable the time stamp on every bash command follow the below steps:

Thursday 20 September 2018

How to enable and disable GitLab services during start up in CentOS 7

Run the following command to disable GitLab services on startup.

How to enable Multiple PHP versions for websites in CentOS 7

Follow below steps to enable PHP 7.2 for a particular website:

Saturday 15 September 2018

How to Install MySQL Server 5.7 on CentOS 6

MySQL Community Server is an open source free database management system. It uses a relational database and SQL (Structured Query Language) to manage its data.

How to Start/Stop MySQL Server in CentOS 6

The service and chkconfig script are used to verify all the services whether it is running or stopped and enable or disabled at startup.

How to resolve “Too many connections” Error MySQL

The “too many connections” error occur when maximum number of clients may be connected to the server has been reached maximum number of connections that are allowed in MySQL configuration. The default value is 151 for the variable max_connections in MySQL.

How to Change Password for a User in MySQL 5.6

MySQL provides UPDATE and other statements which can use to change the password of a MySQL user. This tutorial will describe how to change password of a MySQL user using UPDATE statement.

Sunday 9 September 2018

How to create database user account in MySQL

MySQL provides the CREATE USER statement that allows creating a new user account.

How to Grant Privileges to a User in MySQL

To grant privileges to a database user account, the GRANT statement can use to provide requires access grants to the user.

Revoking Privileges from Users Using MySQL REVOKE

To revoke privileges from a user account, the MySQL REVOKE statement will use to revoke the access/grants one or more privileges or all privileges from a user.

How to delete a Samba user in Centos 7

Use the following commands to delete the samba user. Also need to delete to OS user from the server:

How to add a samba user in Centos 7

To allow access in samba share directory, first need to create a local/OS user account (If already not exist) and then create a samba password for the same account for samba user.

How to disable the Apache default welcome Page in CentOS 7

Post apache (httpd) installation, a default Welcome Page created inside apache document root directory or /etc/httpd/conf.d/ directory.

Saturday 8 September 2018

How to Redirect HTTP to HTTPS on Apache

Before setting up an Apache HTTP to HTTPS redirect for a site, make sure a SSL vhost already created and mod_rewrite module is loaded in Apache.

How to add SSH public key to the Server in Centos 7

In key-based authentication, we need to generate SSH key pairs and the pair use for authentication. The private key is used for client machine and public key uploaded to the remote machine.