rockxy1214

 Profile Answers by rockxy1214 

• Feb 20th, 2008

 

Reload privileges are mainly used when a new user is created and
you want to apply the changes without re starting Mysql

syntax to use:

mysql -u username -ppassword -e"flush privileges";

adilraufkhan

 Profile Answers by adilraufkhan 

• Feb 17th, 2009

 

Reload privileges are used to apply any changes on settings related to privileges without re starting Mysql's current session

syntax to use:

mysql -u username -p password -e "flush privileges";

Altaf Hussain Sayyed

 Profile Answers by Altaf Hussain Sayyed 

• Jun 29th, 2011

 

Hi,

When you update or add privileges in MySQL grant tables(db,users,tables,columns,hosts etc) are updated. These changes takes effect when mysql server restarts. MySQL server reads all grant tables at the time of startup.

If you need to affect grant table update for next client connection immediately you need command flush_privileges.

RELOAD privilege allows user to fire flush_privileges command.


If you need any further assistance or discussion please mail me at altafhsayyed@yahoo.com

Thanks and regards