MySQL Useful Skills in Command Prompt

Hello guys, in this digital world, hundreds of thousands of data runs in various fields. For a clerk who can operate data using certain query languages, he will get a high work efficiency as well as a promotion probably. Therefore, why not study a Structured Query Language when you are a student? If you are trapped in how to start to learn, don’t worry!! I will tell you how to begin your MySQL learning as an absolute beginner in detail.

How to build mysql service?

1. First, you should download MySQL software. Also, you can follow a graphical instructions here. The reason why we should download the MySQL Software is we want to build a mysql service in our local computer.

2. But here, we do not need this visuable workbench. Because I believe that using command prompt to execute mysql syntax, you will get well-trained.

3. Since you are already set a password to connect the server, and you do not want to enter it every time, I strongly recommand you to reset your login authentication with next several steps.

   1. Open Command Prompt as a administrator.

   2. Change the directory to “bin” folder, using cd C:\Program Files\MySQL\MySQL Server 8.0\bin (Notice: this location is on my computer)

   3. Next, input mysqld --skip-grant-tables.
      

   4. And then, input mysql -u root -p. If you are asked to enter your password, just press Enter to skip this step.
      

4. Until now you can start your mysql journey in Command Prompt.

In the end, hopefully, what I post helps you!!