1,234
edits
Changes
→Create an SQL user
Instead creating a user in AWS RDS takes these three steps:
#Create a user with this username and password (replace andrewdb with yours):<source>CREATE USER 'andrewdbasmith15db'@'%' IDENTIFIED BY 'andrewdbpasswordasmith15dbpassword';</source>
#Find what privileges your dbroot is able to assign:<source>show grants for 'dbroot';</source>
#Give the most important permissions to your db user:<source>GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE ON firstdb.* TO 'asmith15db'@'%';</source>
