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
TECHIES WORLD
For Techs.... Techniques.... Technologies....
Mysql
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
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