How to create MySQL user and grant permissions in AWS RDS

How to create MySQL user and grant permissions in AWS RDS

Explains how to create a new MySQL/MariaDB user and grant permission on the AWS RDS instance. Further, learn how to enforce TLS/SSL connections.

How do I create a new MySQL user and grant permissions in AWS RDS cloud service from the Linux command line?

MySQL is a free and open-source database. Many websites on the Internet use MySQL along with Python, Perl, PHP, and other server-side programming languages. AWS offers managed MySQL service with high availability options, including backups, restores, and patching. This quick tutorial explains how to create MySQL user accounts and grant privileges on AWS RDS using Linux command-line options.

Tutorial requirementsOperating system/appAWS RDS (MySQL or MariaDB instance)Root privileges requiredYesDifficultyEasy (rss)Estimated completion time5mTable of contents

ADVERTISEMENTS

Prerequisite

The following commands work with both MariaDB and MySQL RDS instance.

Obviously, you need an AWS account along with MySQL/MariaDB RDS and EC2/Lightsail instance running. I am also assuming that you have mysql client installed on your EC2/Lightsail Linux server. For example, we can install the mysql client as follows. First, log in using the ssh command:

ssh -i ~/.ssh/EC2-keypem.pem [email protected]

[object object] [object object] [object object] [object object] [object object] [object object]

Bootstrap 5 Complete Course with Examples

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Building a simple Applications with Vue 3

Deno Crash Course: Explore Deno and Create a full REST API with Deno

How to Build a Real-time Chat App with Deno and WebSockets

Convert HTML to Markdown Online

HTML entity encoder decoder Online

How to Find Ulimit For user on Linux

Explains how to find ulimit values of currently running process or given user account under Linux using the 'ulimit -a' builtin command.

MEAN Stack Tutorial MongoDB ExpressJS AngularJS NodeJS

MEAN Stack Tutorial MongoDB ExpressJS AngularJS NodeJS - We are going to build a full stack Todo App using the MEAN (MongoDB, ExpressJS, AngularJS and NodeJS). This is the last part of three-post series tutorial.

Creating RESTful APIs with NodeJS and MongoDB Tutorial

Creating RESTful APIs with NodeJS and MongoDB Tutorial - Welcome to this tutorial about RESTful API using Node.js (Express.js) and MongoDB (mongoose)! We are going to learn how to install and use each component individually and then proceed to create a RESTful API.

systemctl List All Failed Units/Services on Linux

Explains how to use the systemctl command to list all failed units or services on Debian, Ubuntu, CentOS, Arch, Fedora, and other Linux distros.

CentOS Linux 8.2 Released and Here is How to Upgrade it

CentOS Linux 8.2 (2004) released. This release adds corrections for security issues based upon RHEL 8.2 souce and here is how to upgrade it.