How to grant access to binlog for user in MySQL
Sometime it may require to to grant access to binlog for a user other that superuser in MySQL. We can
Read More
TECHIES WORLD
For Techs.... Techniques.... Technologies....
Cpanel
How to change the MySQL password policy level
MySQL used a plugin called validate_password which setup the password policy level. There are three password policy levels in MySQL
Read More
How to remove replication slot in PostgreSQL
We can use pg_drop_replication_slot to delete replication slot in PostgreSQL. Where NAME need to be replaced with the name of
Read More
What's the difference between inventory_hostname and ansible_hostname
inventory_hostname is the one which configured in the ansible inventory file (eg: /etc/ansible/hosts). It can be an IP address or
Read More
How to check get the list of processes those using a specific mount point
Sometimes we might get the message "device busy" on trying umount. This is because some processes are still accessing those
Read More
How to enable password-less authentication for PostgreSQL user
We can configure the bash in such a way that it doesn't prompt for a password during PostgreSQL connections via
Read More
How to export data from PostgreSQL table to csv file
We can use COPY command to in PostgreSQL to export data from table to csv file. Where, That's all…
Read More
How to loop through a comma separated variable in bash
To loop through a comma separated variable in bash, need cut the elements first and then iterate over each. Sample
Read More
How to get the data count for all tables in a MySQL database
We can use the following query to get the data count for all tables in MySQL database. Where dbname need
Read More
How to describe table in PostgreSQL
We can use '\d' query to describe table in PostgreSQL. Here schemaname and tablename needs to be replaced accordingly. If
Read More
How to log request header in Apache
Sometimes its required to analyze the the request headers as the part of troubleshooting purposes. But Apache will not log
Read More