开发者

How to reset root password for a single mysql process

I need to reset a root password for one of my mysqld processes. I know in mysql, you can use mysqld_safe with the skip grant tables option, but what do you do when you have multiple mysql processes and want to reset their root user p开发者_Go百科asswords? I can't use this option with mysqld_multi.

thanks,


mysqld_multi is basically just a collection of mysqld processes. So you can simply start that specific process manually with the skip grant tables option.

Do note that you have to stop the specific group with mysqld_multi first though.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜