Get the App
SLTechnology News&Howtos  ›  Database  › 

What about the mysql database flashback?

Shulou Source: shulou.com Published: 2022-06-01 02:02:45 10月01日 Update

Xiaobian to share with you how to do mysql database flash back, I believe most people still do not know how to, so share this article for your reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

mysql work too flashback solution: first enter MySQL installation directory bin; then enter the command "mysqladmin -uroot password root"; finally open MySQL 5.0 Command Line Client, enter the password root.

Just learned the database, and installed MySQL, just happy, found that my MySQL appeared flash back. Internet search for a long time solution. Finally solved this problem and was comfortable.

The question starts here:

Then I opened MySQL and wondered if I could use it, but it flashed back.

Then I went to the server, checked if it was open, tried to open it, and found that it didn't work.

There are results on the Internet that say you want to delete my.ini under Windows.

However, I hesitated for a long time, feeling that the problem is not here, and do not want to delete.

The Internet says to set up hosts, about "127.0.0.1 localhost" I have set it up before.

Some netizens said that as an administrator to operate cmd Balabala, tried for a long time. It doesn't work with me.

Then I found a way, feeling closer to the answer I wanted, tried it and it worked!!!

MySQL flashback problem solving steps are as follows:

1. Use cmd to enter MySQL installation directory bin;

2. Enter a command:

mysqladmin -uroot password root, then Enter,

At this point, MySQL user root password is set to root.

3. Open MySQL 5.0 Command Line Client, enter the password root, there is no flash back, the problem is solved.

or

The above is mysql database flash back how to do all the content, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Tags: Question input data database password what to do content method command feeling directory article result Barra study no happy hesitant not much most Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Docker macOS Shulou Technology Apple Shulou Tech Info