CODEWITHSUNDEEP
mysqlamazon-rds
Suraj
Suraj

Reputation: 373

While Executing Stored Procedure in MySQL Amazon RDS Show Access Denied

Error show while executing stored procedure

MySQL said: Documentation
#1045 - Access denied for user 'root'@'%' (using password: YES)

Permissions on mysql

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'root'@'%' IDENTIFIED BY PASSWORD <secret> WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `product`.* TO 'root'@'%' WITH GRANT OPTION
GRANT ALL PRIVILEGES ON `%`.* TO 'root'@'%' WITH GRANT OPTION
GRANT EXECUTE ON PROCEDURE `product`.`export_product` TO 'root'@'%' WITH GRANT OPTION

Upvotes: 1

Views: 1675

Answers (1)

Shaju Nr
Shaju Nr

Reputation: 358

Create DB parameter group.Try the above link to create db parameter group in amazon rds and enable log_bin_trust_function_creators for creating and executing functions triggers and stored procedures

Upvotes: 3

Related Questions