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.
精彩评论