What is the MySQL reload permission?
This article will explain in detail how MySQL reload permissions are. The quality of the article is high, so Xiaobian shares it with you for reference. I hope you have a certain understanding of relevant knowledge after reading this article.
MySQL reload permissions:
reload is an administrative-level permission, i.e. server administration; this type of permission includes:
CREATE USER, PROCESS, RELOAD, REPLICATION CLIENT, REPLICATION SLAVE, SHOW DATABASES, SHUTDOWN, SUPER
Authorization for this type of permission is not specific to a database, so use on *.* to carry out:
C:\Users\Igor>mysql -ufiletest -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.11-log MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use test;
Database changed
mysql> flush table c;
ERROR 1227 (42000): Access denied; you need (at least one of) the RELOAD privile
ge(s) for this operation
##Root login authorization:
mysql> grant reload on *.* to 'filetest'@'localhost';
Query OK, 0 rows affected (0.06 sec)
##Flush table again successfully
C:\Users\Igor>mysql -ufiletest -p
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.11-log MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use test;
Database changed
mysql> flush table c;
Query OK, 0 rows affected (0.00 sec)
About MySQL reload permissions is how to share here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.
