Common DBA tasks for MySQL DB instances (original) (raw)
Understanding predefined users
In the following content, you can find descriptions of the Amazon RDS-specific implementations of some common DBA tasks for DB instances running the MySQL database engine. To deliver a managed service experience, Amazon RDS doesn't provide shell access to DB instances. Also, it restricts access to certain system procedures and tables that require advanced privileges.
For information about working with MySQL log files on Amazon RDS, see MySQL database log files.
Understanding predefined users
Amazon RDS automatically creates several predefined users with new RDS for MySQL DB instances. Predefined users and their privileges can't be changed. You can't drop, rename, or modify privileges for these predefined users. Attempting to do so results in an error.
- rdsadmin – A user that's created to handle many of the management tasks that the administrator with
superuserprivileges would perform on a standalone MySQL database. This user is used internally by RDS for MySQL for many management tasks. - rdsrepladmin – A user that's used internally by Amazon RDS to support replication activities on RDS for MySQL DB instances and clusters.
For information about other common DBA tasks, see the following topics.
Topics
- Role-based privilege model for RDS for MySQL
- Dynamic privileges for RDS for MySQL
- Ending a session or query for RDS for MySQL
- Skipping the current replication error for RDS for MySQL
- Working with InnoDB tablespaces to improve crash recovery times for RDS for MySQL
- Managing the Global Status History for RDS for MySQL
- Configuring buffer pool size and redo log capacity in MySQL 8.4
Parameters for MySQL
Role-based privilege model
Did this page help you? - Yes
Thanks for letting us know we're doing a good job!
If you've got a moment, please tell us what we did right so we can do more of it.
Did this page help you? - No
Thanks for letting us know this page needs work. We're sorry we let you down.
If you've got a moment, please tell us how we can make the documentation better.