Guest User

Untitled

a guest
Dec 12th, 2017
348
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.68 KB | None | 0 0
  1. [ec2-user@ip ~]$ mysql -h servidortest -u meuusuario -p
  2. Enter password:
  3. Welcome to the MySQL monitor. Commands end with ; or g.
  4. Your MySQL connection id is 17693
  5. Server version: 5.6.31 MySQL Community Server (GPL)
  6.  
  7. Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
  8.  
  9. Oracle is a registered trademark of Oracle Corporation and/or its
  10. affiliates. Other names may be trademarks of their respective
  11. owners.
  12.  
  13. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
  14.  
  15. mysql> use databaseteste;
  16. Reading table information for completion of table and column names
  17. You can turn off this feature to get a quicker startup with -A
  18.  
  19. Database changed
  20. mysql> show grants;
  21. +-------------------------------------------------------------------+
  22. | Grants for meuusuario@% |
  23. +-------------------------------------------------------------------+
  24. | GRANT ALL PRIVILEGES ON *.* TO 'meuusuario'@'%' |
  25. | GRANT ALL PRIVILEGES ON `databaseteste`.* TO 'meuusuario'@'%' |
  26. +-------------------------------------------------------------------+
  27. 2 rows in set (0,00 sec)
  28.  
  29. mysql> GRANT INSERT ON `databaseteste`.* TO 'usr_mage_fol'@'%';
  30. ERROR 1044 (42000): Access denied for user 'meuusuario'@'%' to database 'databaseteste'
  31.  
  32. string(320) "SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('usr_mage_fol'@'%') does not exist, query was: INSERT INTO..
  33.  
  34. mysql> select user, host from mysql.user;
  35. +--------------+------------------+
  36. | user | host |
  37. +--------------+------------------+
  38. | meuusuario | % |
  39. | usr_mage_fol | % |
  40. +--------------+------------------+
Add Comment
Please, Sign In to add comment