开发者

How to reset root password for a single mysql process

开发者 https://www.devze.com 2023-01-20 20:47 出处:网络
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 an

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

精彩评论

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

关注公众号