Securing Data Transfer in MySQL Cloud Environments Using Role-Based Access Control

The purpose of this study is to examine and improve the security of data transfer for MySQL databases in cloud environments by integrating the Role-Based Access Control (RBAC) architecture. Sensitive data is increasingly at risk during network transmission due to the quick spread of cloud solutions, which makes the implementation of multi-layered security measures necessary. To safeguard data while it is in transit, this study suggests an architecture that integrates encryption methods with the RBAC permissions governance mechanism. To assess how well this system mitigates intrusion assaults and unauthorized access, the methodology uses a simulation model. The findings show that RBAC and encryption together greatly lower vulnerabilities and offer defines in depth that conforms with strict security regulations like GDPR and HIPAA. This approach provides a comprehensive and practical solution for data security in hybrid and public cloud systems by streamlining access control and enhancing auditability. The study highlights that the suggested strategy is a necessary addition that improves the resilience and integrity of cloud infrastructure rather than a replacement for other security measures.