5

Just like a vps/server when I install mysql on it, it can be flexible to add/remove database in one server, but on aws rds mysql can I add database without create a new instance?

Muhamad Yulianto
  • 155
  • 3

1 Answers1

6

Sure, login with the master user / password credentials that you used when creating the instance and then create the database:

$ mysql -u{MasterUser} -p{MasterPassword} -hmysql–instance1.123456789012.us-east-1.rds.amazonaws.com
mysql> CREATE DATABASE new_db;
mysql> CREATE USER ...
mysql> GRANT ...;

Just like with any other MySQL server.

If you prefer a GUI interface you can use for example Adminer or something like that.

Hope that helps :)

MLu
  • 24,849
  • 5
  • 59
  • 86