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.