Shulou(Shulou.com)06/02 Report--

This article introduces the relevant knowledge of "mysql installation, use, connection error reasons and solutions". In the actual case operation process, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can read carefully and learn something!

Follow the steps to install to the last step, start service error, the reason is that the registry is not cleaned up, this is expected, before installing mysql once. However, I am too lazy to find the registry. I reinstall the system directly (because it is Tencent's Cloud Virtual Machine). After doing it twice, it still doesn't work. So I delete the registry obediently. After reinstalling the system, the registry is clean. Why does Tencent Cloud (Cloud) still exist?

The registry is closed.

Start----> Run Enter regedit to enter the registry

----> Delete MySQL directory under HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Applications

----> Delete MySQL directory under HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Applications

---> Delete MySQL directory under HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Applications

---> Restart the machine. Installation is complete.

Enter the second pit: local connection denied

1045 Access denied for user 'root'@'localhost' (using password:YES)

I don't know why it happened. I just got mysql. It's possible that I made a mistake when installing it.

The solution is to change the my.ini file, skip password verification and update the root password of the user table on DOS.

Specific steps:

1. Find my.ini under the installation path

Open the file with the text tool and add skip-grant-tables to that location, then restart the service.

Open DOS window:

Comment out the skip-grant-tables you added earlier.

Restart the service and it's OK.

"mysql installation, use, connection times wrong reasons and solutions" content is introduced here, thank you for reading. If you want to know more about industry-related knowledge, you can pay attention to the website. Xiaobian will output more high-quality practical articles for everyone!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.