You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2021/03/28 10:27:21 UTC

[GitHub] [shardingsphere] tristaZero opened a new issue #9851: Format the loading SQL for `MySQLPrivilegeLoader`

tristaZero opened a new issue #9851:
URL: https://github.com/apache/shardingsphere/issues/9851


   Hi,
   
   This issue is to format the loading SQL for `MySQLPrivilegeLoader`.
   
   ### Intro
   MySQLPrivilegeLoader loads the privileges from MySQL using some of SQLs. But these SQLs do not have better definitions. 
   
   ### Task
   - Add statice final variable `SELECT * FROM mysql.user WHERE (user, host) in (%s)` in `MySQLPrivilegeLoader` to replace the line 124 and refactor the function `getGlobalPrivilegeSQL()`.
   - Same handling with the above for `getSchemaPrivilegeSQL()`
   - Same handling with the above for `getTablePrivilegeSQL()`
   
   ### Tip
   `MySQLTableMetaDataLoader` class is good example FYI.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] zhujunxxxxx commented on issue #9851: Format the loading SQL for `MySQLPrivilegeLoader`

Posted by GitBox <gi...@apache.org>.
zhujunxxxxx commented on issue #9851:
URL: https://github.com/apache/shardingsphere/issues/9851#issuecomment-808903499


   @totalo sorry, I didn't see you want to do this, I have finished the repair. ^_^


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] totalo commented on issue #9851: Format the loading SQL for `MySQLPrivilegeLoader`

Posted by GitBox <gi...@apache.org>.
totalo commented on issue #9851:
URL: https://github.com/apache/shardingsphere/issues/9851#issuecomment-809003771


   > @totalo sorry, I didn't see you want to do this, I have finished the repair. ^_^
   
   it's ok , i will try another.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero closed issue #9851: Format the loading SQL for `MySQLPrivilegeLoader`

Posted by GitBox <gi...@apache.org>.
tristaZero closed issue #9851:
URL: https://github.com/apache/shardingsphere/issues/9851


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero commented on issue #9851: Format the loading SQL for `MySQLPrivilegeLoader`

Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #9851:
URL: https://github.com/apache/shardingsphere/issues/9851#issuecomment-808880717


   Welcome @totalo 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] totalo commented on issue #9851: Format the loading SQL for `MySQLPrivilegeLoader`

Posted by GitBox <gi...@apache.org>.
totalo commented on issue #9851:
URL: https://github.com/apache/shardingsphere/issues/9851#issuecomment-808879852


   hi i want to have a try ,thx


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org