我正在尝试在 mysql 中执行查询.
SET GLOBAL log_bin_trust_function_creators =1;<块引用>
错误:
SQL 查询:
设置全局 log_bin_trust_function_creators =1
MySQL 说:
#1227 - 访问被拒绝；您需要此操作的 SUPER 权限
我想知道如何将SUPER权限分配给任何数据库
您可以使用 phpmyadmin 添加超级权限:
转到 PHPMYADMIN > 权限 > 编辑用户 > 在管理员选项卡下单击超级.> 去
如果你想通过Console来做，这样做:
mysql>GRANT SUPER ON *.* TO user@'localhost' IDENTIFIED BY 'password';执行上述代码后，以:
mysql>同花顺特权；你应该在 *.* 上做，因为 SUPER 不是只适用于一个数据库的特权，它是全局的.
I am trying to execute query in mysql.
SET GLOBAL log_bin_trust_function_creators =1;
Error:
SQL query:
SET GLOBAL log_bin_trust_function_creators =1
MySQL said:
#1227 - Access denied; you need the SUPER privilege for this operation
I want to know that how do i assign SUPER privileges to any database
You can add super privilege using phpmyadmin:
Go to PHPMYADMIN > privileges > Edit User > Under Administrator tab Click SUPER. > Go
If you want to do it through Console, do like this:
mysql> GRANT SUPER ON *.* TO user@'localhost' IDENTIFIED BY 'password';
After executing above code, end it with:
mysql> FLUSH PRIVILEGES;
You should do in on *.* because SUPER is not the privilege that applies just to one database, it's global.
这篇关于如何为mysql数据库添加超级权限?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！