Tag Info

New answers tagged

0

You can deploy JIRA on a existing RDS instance itself you just need to create a DB called "jiradb". I guess you might have to change few DB parameters in RDS instance as JURA needs to be run in "STRICT" type for "SQL_mode" You can refer this documentation link on how to Configure your JIRA server to connect to your MySQL database. ...


0

In this specific case (a failed grant statement) stopping the slave, skipping the event, and restarting the slave is likely a safe operation... you just have to do it the RDS way. mysql> CALL mysql.rds_skip_repl_error; This is one of several stored procedures installed on every RDS instance that partially make up for the lack of SUPER privilege. ...


3

You want ALTER DEFAULT PRIVILEGES. Give the rds_superuser default access rights to all new tables. This only affects tables created after the ALTER. For existing tables you must GRANT rights.


0

The public schema is supposed to be visible by all users. You should not restrict rights of public schema to just one group. So, if you do not use: GRANT ALL ON SCHEMA public TO GROUP rds_superuser WITH GRANT OPTION; You may safely work with the public schema with all accounts. If you do not want specific accounts to mess up your public schema tables, ...


1

You are mistaken in your assertion that "the binary log retrieves fine." The output you are seeing is boilerplate output from mysqlbinlog... there's no evidence here that you are actually fetching the binlog. There's no such log file on the server. That's the meaning of this error. SHOW BINARY LOGS; ...to find the available logs on the server. You can ...


1

In your attempt: SELECT id FROM "players" where "players".born_on < "1950-01-01"; Then DELETE FROM "players" WHERE "players".id = 5; DELETE FROM "stats" WHERE "stats".player_id = 5; DELETE FROM "photos" WHERE "photos".player_id = 5; ... repeat First, I don't understand the "...= 5;" one each the subsequent deletes. What is the 5? But....what if ...



Top 50 recent answers are included