What is RELOAD privileges in MySQL used for?

Questions by nancyphilips   answers by nancyphilips

Showing Answers 1 - 3 of 3 Answers

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";

  Was this answer useful?  Yes

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";

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions