[root@srv-eset-01 ~]# mysql -u root -h localhost -p -e 'SHOW GRANTS;' era_db
Enter password:
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*64037E23FE82637A11CE3A2F5FAFE9EE5DD87AB3' WITH GRANT OPTION |
| GRANT ALL PRIVILEGES ON `era_db`.* TO 'root'@'localhost' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE ON `era_g2_db`.* TO 'root'@'localhost' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE ON `era_g2_proxy_db`.* TO 'root'@'localhost' |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
[root@srv-eset-01 ~]#
i have permissions, i just can not backup. i need for upgrade version of ERA Appliance.