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

Problem description (environment: windows7,MySql8.0)

Today, after installing MySql, start the MySql service-- > if you fail to start the service, don't look down and solve it on your own.

Open the client in a second, but you can use the database in cmd.

Normally, as long as you can use it, but the client is convenient, you don't want to type that line of code. On the Internet to find, Baidu, google, all kinds of methods have been tried.

In the end, it turned out to be useless. The problems were similar, but not all the same.

The pit I encountered (not that what others said was wrong, but that it was useless to me)

Encounter pit 1: it is said on the Internet that there is a problem with the my.ini file, but there is no my.ini in my installation path.

Yukeng 2: change the .ini suffix to my.ini anyway.

Yukeng 3: also found that there is no my.ini to create my.ini, create data folder, uninstall the service, reinstall, the result is useless.

Anyway, according to all kinds of theories, they all revolve around my.ini files.

Solve

I believe many people saw this picture when they looked it up on the Internet.

I am the default installation:

"C:\ Program Files\ MySQL\ MySQL Server 8.0\ bin\ mysql.exe"-- defaults-file=C:\ Program Files\ MySQL\ MySQL Server 8.0\ my.ini "- uroot"-p "

As most people say on the Internet, there is no my.ini file in this path-> my.ini is a configuration file for MySql.

And have you found that there is no Data folder mentioned on the Internet-- > Data is a folder where data is saved most of the time.

At this time, I'm not thinking about how to change it, but because I should look for it.

Finally, I found Data and my.ini-- > C:\ ProgramData in MySQL\ MySQL Server 8.0\ under C:\ ProgramData, which is a hidden folder.

Last

Change the path in the figure to C:\ Program Files\ MySQL\ MySQL Server 8.0\ bin\ mysql.exe "--defaults-file=C:\ ProgramData\ MySQL\ MySQL Server 8.0\ my.ini"-uroot "- p"

Actually, it is to change file=C:\ Program Files to file=C:\ ProgramData

It would be nice to open the client

Summary

The above is the editor to introduce to you to solve the MySql client second back problem (can not find my.ini), I hope to help you!

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.