A business might choose the 'Standard Create' method when setting up a MySQL database on AWS RDS because it provides a full range of configuration options, allowing them to tailor the database instance according to specific requirements like performance, availability, and reliability. This method is particularly useful when businesses need to customize their setup beyond what is provided in preset configurations such as the 'Free Tier' .

Enabling port 3306 in the security group inbound rules for a MySQL database in AWS RDS is crucial because port 3306 is the default port used by MySQL databases for communications. Allowing traffic through this port ensures that the client applications such as MySQL Workbench can establish connections to the database server, facilitating processes like querying and data management .

To ensure data integrity and security when using AWS RDS for storing sensitive information, several steps should be considered. Firstly, implementing encryption both at rest and in transit protects data from unauthorized access. Employing IAM roles and policies to manage permissions ensures that only authorized users have access to the database. Regularly monitoring and auditing database activities provides insights into any unusual access patterns, and enabling automated backups helps in data recovery scenarios. Additionally, configuring the security group to restrict access to only trusted IP ranges enhances security .

AWS RDS automates many administrative tasks through a managed service model, reducing the complexity and overhead associated with database management. This includes automated backups, software patching, and scaling, which relieve the database administrators from routine maintenance tasks. Cost management is also enhanced through the "pay as you go" pricing model, which ensures that users only pay for the resources they actually use, as opposed to the fixed costs of maintaining an on-premise setup .

Enabling public access for a MySQL database on AWS RDS can lead to potential security risks as it exposes the database to the internet, increasing vulnerability to unauthorized access and attacks. It is crucial to implement strong security measures, such as configuring security groups with restrictive inbound rules, using encrypted connections, and ensuring that authentication is robust, to mitigate these risks .

According to AWS RDS documentation, testing a MySQL DB connection using MySQL Workbench involves several steps: creating the MySQL DB Server using RDS, enabling the MySQL 3306 port number in the Security Group Inbound Rules, and using MySQL Workbench software, which is a client software, to test the DB connection. Finally, it allows for execution of SQL queries as needed .

To create tables and insert data in a MySQL database hosted on AWS RDS, you can follow these procedures: after testing the DB connection with MySQL Workbench, execute SQL queries such as `create table` to define new tables. For instance, the query `create table emp(eid int(10), ename varchar(100), esal int(10));` creates an employee table with id, name, and salary fields. Insert data with `insert into emp values(1, 'john', 1000);` to add records into the table. Practice typical select queries to retrieve these records .

In the context of setting up AWS RDS, the term 'DB endpoint' refers to the network address used by client applications to connect to the database instance. It is significant because it acts as the gateway through which all database operations, such as executing queries or managing data, are conducted. The DB endpoint ensures that the applications can communicate correctly and efficiently with the database service .

AWS RDS offers several advantages over traditional on-premise databases, including elimination of complex database setup and maintenance tasks such as purchasing a database server license, installing database server software, and handling security and network configurations. It simplifies these processes with a fully managed service model, ensuring higher availability and scalability. Additionally, AWS RDS offers a "pay as you go" model, which can reduce costs by avoiding upfront investments .

To avoid unnecessary billing after practicing SQL queries on AWS RDS, it is important to delete the RDS instance once practice is completed. This action stops further charges associated with instance usage, storage, and any additional features that might incur costs. Regularly reviewing and managing instances post-usage ensures efficient cost management within the "pay as you go" model .