How to terminate MySQL query
Sometimes it may required to kill long running queries from MySQL. In-order to do the same, login to the MySQL
Read more
Mysql
How to delete procedure from MySQL
We can remove the stored procedure from MySQL using a simple query. Here name should replaced with the name of
Read more
PhpMyAdmin Error: Warning in ./libraries/sql.lib.php#601 count(): Parameter must be an array or an object that implements Countable
Warning in ./libraries/sql.lib.php#601count(): Parameter must be an array or an object that implements Countable This error occurs on using PhpMyAdmin
Read more
MySQL Dump Error: The user specified as a definerdoes not exist when using LOCK TABLES
The user specified as a definerdoes not exist when using LOCK TABLES This error happens on exporting the MySQL database
Read more
PHP: Warning: mysqli_connect(): (HY000/2002): No such file or directory
Warning: mysqli_connect(): (HY000/2002): No such file or directory This usually happens on customized LAMP installations. Here the php cannot find
Read more
How to install MySQL8 on Amazon Linux2
This tutorial explains the steps to install MySQL8 on Amazon Linux2 EC2 instance. Step1: Login to the instance via ssh
Read more
How to install MySQL 5.7 on Amazon Linux
The Amazon Linux repositories contains Mariadb packages instead of MySQL by default. This tutorial explains the steps to install MySQL
Read more
MySQL Replication Error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs
The slave I/O thread stops because master and slave have equal MySQL server UUIDs This is a common issue that
Read more
MySQL Error: mysqld_safe: command not found error
mysqld_safe: command not found error In MySQL 5.7 and prior versions, we are using mysqld_safe utility in-order to reset the
Read more
How to terminate PostgreSQL query
We can terminate the PostgreSQL query by terminating the corresponding process id. Step1: Login to PostgreSQL shell as admin user.
Read more
How to escape back quotes in MySQL query
We are execute MySQL queries directly from Linux shell by providing username, password and database name along with the query.
Read more