How to save PostgreSql query output to file
The PostgreSql query should be be terminated with a semicolon for execution. We can use a '\g' also as an
Read More
TECHIES WORLD
For Techs.... Techniques.... Technologies....
Mysql
ERROR: cPanel PhpMyadmin asking for authentication
Basically auto-login feature is enabled for cPanel PhpMyadmin which means the users can login to phpMyadmin from cPanel without any
Read More
How to reduce the memory usage of MySQL
Sometimes it appears that the server’s free memory runs very low because MySQL is using more memory than expected. The
Read More
MySQL Restore Error: Unknown collation: 'utf8mb4_unicode_520_ci'
Unknown collation: 'utf8mb4_unicode_520_ci' This error will occur if we are attempting to restore database dump from Mysql 5.5.3+ to older
Read More
How to configure replication between RDS MySQL and Self-hosted MySQL
Amazon Relational Database Service is a distributed relational database service by Amazon Web Services. We can create the replicas of
Read More
How to enable slow query log in MySQL
Slow queries can affect the perfomance of database and also the server as well. MySQL providing an option to log
Read More
How to reset MySQL user password in Linux
Step1: Login to MySQL as root. Step2: Run the query to change the user password. Here we need to replace
Read More
How to remove user from Mysql
To remove a user from Mysql, we can use the following query. Here we need to replace user and host
Read More
How to configure Mysql server as read-only
Sometimes we need to configure Mysql server as readonly. This is mainly required on setting replication servers. In order to
Read More
How to ignore tables from mysqldump
The mysqldump is a backup program in mysql. It can be used to dump a database or a collection of
Read More
How to enable apache to accept connections from outside in WAMP
WampServer refers to a software stack for the Microsoft Windows operating system, created by Romain Bourdon and consisting of the
Read More