Shulou(Shulou.com)05/31 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.