Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.83 KB | None | 0 0
  1. $ mysql --user=license --password=test123 --host=mariadb.devlocal --database=license -s '--execute=CALL config_sp_License_Update("missing","29b7ec4250df4fb30ce8634c98ae412a328652bb463749eec7a11b033b1e4eef","0","0","2019-06-19 09:04:26","2019-06-19 09:04:26", "0");'
  2. status
  3. missing
  4.  
  5. $ mysql --user=license --password=test123 --host=mariadb.devlocal --database=test_license -s '--execute=CALL config_sp_License_Update("missing","29b7ec4250df4fb30ce8634c98ae412a328652bb463749eec7a11b033b1e4eef","0","0","2019-06-19 09:04:26","2019-06-19 09:04:26", "0");'
  6. ERROR 1370 (42000) at line 1: execute command denied to user 'license'@'%' for routine 'test_license.config_sp_License_Update'
  7.  
  8. Welcome to the MariaDB monitor. Commands end with ; or g.
  9. Your MariaDB connection id is 4653
  10. Server version: 10.4.2-MariaDB-1:10.4.2+maria~bionic mariadb.org binary distribution
  11.  
  12. Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
  13.  
  14. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
  15.  
  16. MariaDB [(none)]> SHOW GRANTS FOR 'license'@'%';
  17. +--------------------------------------------------------------------------------------------------------+
  18. | Grants for license@% |
  19. +--------------------------------------------------------------------------------------------------------+
  20. | GRANT USAGE ON *.* TO 'license'@'%' IDENTIFIED BY PASSWORD '*676243218923905CF94CB52A3C9D3EB30CE8E20D' |
  21. | GRANT ALL PRIVILEGES ON `license`.* TO 'license'@'%' |
  22. | GRANT ALL PRIVILEGES ON `test_license`.* TO 'license'@'%' |
  23. +--------------------------------------------------------------------------------------------------------+
  24. 3 rows in set (0.00 sec)
  25.  
  26. MariaDB [(none)]>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement