RE: new password will not be effective for connection immediately

[Jay Blanchard]

[snip]
My question is I hope the new password will be effective for connection
immediately
without ' Stop and Start ' the mysql Service.
[/snip]

Instead of stopping and starting the service you should do the following
query;

FLUSH PRIVILEGES;

That will cause new passwords to take effect.