I use the mysqld - the console - skip - grant - tables - Shared - memory reset password


The innodb_system data file 'ibdata1' must be writable is what??

CodePudding user response:

Is probably you don't have the data catalogue write permissions, and suggested the data mobile guide other directory, then change my. Ini the datadir,

But also can be used to start the mysql administrator,

CodePudding user response:

reference 1st floor Dong Xuyang TonyDong response:

is probably you don't have the data catalogue write permissions, and suggested the data mobile guide other directory, then change my. Ini the datadir,

But also can be used to start the mysql administrator,

I was blind to change the root password and then caused the situation, now can't use the root account login, only can use the root account==after initialization

CodePudding user response:

You can directly start mysqld success?

CodePudding user response:

The

reference 3 floor Dong Xuyang TonyDong response:

you can directly start mysqld success?

Can use mysqld, but I'm sorry, I am a novice, understanding of mysqld is limited to initialize and skip validation command,

CodePudding user response:

What version? 5.7 it can ignore authorization table and then into the modified

CodePudding user response:

Modify the mysql installation directory my. Ini or my - default. Ini data storage directory, such as

CodePudding user response:

Or see the article refer to the reset password at https://blog.csdn.net/JustinQin/article/details/78871679#2%E3%80%81%E5%BF%98%E8%AE%B0%E5%AF%86%E7%A0%81