Reset the Root Password of MySQL on Windows

When we install MySQL on Windows, we usually specify the password of the root user. This helps keep the MySQL Server secured. Suppose you joined a new organization, and the management of that organization plan to migrate some MySQL databases to SQL Server. To perform this, you need the credential of the root user, but the organization did not keep track of the password. In this scenario, we must reset the password of the root user.

In this article, we are going to learn how we can reset the root password in MySQL Server on Windows 10. I have prepared a demo environment on my workstation for demonstration, and the details are explained in the next section.

CodingSight - Reset the Root Password of MySQL on Windows
Read More

How to Make the Best Use of Comment Function in MySQL

Comments are used to add information to the code. It is mostly ignored by the compiler, but human specialists can read those comments when they view your code. Comments are essential for developers because they have limited time, and commenting allows them to get valuable information at once or note some crucial details in regards to the code. Accessing this data lets them make the right decisions and work faster.

CodingSight - How to Make the Best Use of Comment Function in MySQL
Read More