You are contacted by a user who does not have permission to access a database table. You determine after investigation that this user should be permitted to have access and so you execute a GRANT statement to enable the user to access the table.
Which statement describes the activation of that access for the user?
A. The access does not take effect until the user logs out and back in.
B. The access does not take effect until the next time the server is started.
C. The access is available immediately.
D. The access does not take effect until you issue the FLUSH PRIVILEGES statement.
Answer: Chttp://www.cndba.cn/hbhe0316/article/22796http://www.cndba.cn/hbhe0316/article/22796http://www.cndba.cn/hbhe0316/article/22796

一个用户联系到你，说他没有权限访问某张表，于是你执行了GRANT语句给其赋权。关于此用户的连接的权限，下面说法正确的是：
A． 新的权限不会在现有连接上生效，直到重新登录才行
B． 新的权限不会在现有连接上生效，直到重启mysqld才行
C． 立即生效
D． 新的权限不会在现有连接上生效，直到执行了FLUSH PRIVILEGES语句才行http://www.cndba.cn/hbhe0316/article/22796

版权声明：本文为博主原创文章，未经博主允许不得转载。

MYSQL