[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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]