Sunday, July 29, 2018

MySQl user grant

======================================

GRANT ALL PRIVILEGES ON `*`.* TO 'root_login'@'%' IDENTIFIED BY 'Pass@123' WITH GRANT OPTION

GRANT ALL PRIVILEGES ON `%`.* TO 'root_user'@'%' IDENTIFIED BY 'Pass@123' WITH GRANT OPTION

=======================================

No comments:

Post a Comment

Postgress - Read a XML file from a postgress table XML column

SELECT xmltable.* FROM xmldata, XMLTABLE('//ROWS/ROW' PASSING data COLUMNS id int PATH ...