Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [ec2-user@ip ~]$ mysql -h servidortest -u meuusuario -p
- Enter password:
- Welcome to the MySQL monitor. Commands end with ; or g.
- Your MySQL connection id is 17693
- Server version: 5.6.31 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 databaseteste;
- Reading table information for completion of table and column names
- You can turn off this feature to get a quicker startup with -A
- Database changed
- mysql> show grants;
- +-------------------------------------------------------------------+
- | Grants for meuusuario@% |
- +-------------------------------------------------------------------+
- | GRANT ALL PRIVILEGES ON *.* TO 'meuusuario'@'%' |
- | GRANT ALL PRIVILEGES ON `databaseteste`.* TO 'meuusuario'@'%' |
- +-------------------------------------------------------------------+
- 2 rows in set (0,00 sec)
- mysql> GRANT INSERT ON `databaseteste`.* TO 'usr_mage_fol'@'%';
- ERROR 1044 (42000): Access denied for user 'meuusuario'@'%' to database 'databaseteste'
- string(320) "SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('usr_mage_fol'@'%') does not exist, query was: INSERT INTO..
- mysql> select user, host from mysql.user;
- +--------------+------------------+
- | user | host |
- +--------------+------------------+
- | meuusuario | % |
- | usr_mage_fol | % |
- +--------------+------------------+
Add Comment
Please, Sign In to add comment