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
Mysql
How to insert line breaks in WordPress manually
We can use the following HTML code to insert line breaks while updating the content. For some WordPress editors this
Read more
How to install MySQL 5.7 on Ubuntu 20.04
This article explains the steps to install MySQL 5.7 on Ubuntu 20.04. Step1: Login to the server as root. Step2:
Read more
How to disable caching_sha2_password in MySQL
In MySQL 8.0 caching_sha2_password is the default authentication plugin rather than mysql_native_password. This required many changes in the applications which
Read more
Mysql Error: Authentication requires secure connection.
Authentication requires secure connection. This is an error usually seeing in MySQL-8.0 while connecting to database. In MySQL 8.0, caching_sha2_password
Read more
How to remove MySQL replication config from slave
We can stop the replication by running the following query in MySQL terminal. But the configuration will remains there and
Read more
RDS MySQL replication error: Slave failed to initialize relay log info structure from the repository
ERROR 1872 (HY000): Slave failed to initialize relay log info structure from the repository This issue happens on configuring MySQL
Read more
Mysql replication error: Relay log read failure: Could not parse relay log event entry
Relay log read failure: Could not parse relay log event entry This error is happening due to the corrupted relay
Read more
How to import MySQL dump in Windows
We can import MySQL dump in Windows through the phpmyadmin application provided by WAMP softwatre. But if the size of
Read more
How to clear MySQL query cache without restarting service
MySQL query cache will be cleared on restarting the service. But its not the right way to restart MySQL to
Read more
MySQL ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' Some times you may face this error while
Read more