Search code examples
mysqlamazon-auroramysql-5.7

Master user can't connect to an existing database in Aurora MySQL - RDS

I have a set of databases as below

mysql> show databases;
+------------------------+
| Database               |
+------------------------+
| information_schema     |
| sys                    |
| system                 |
| test                   |

When I try to access 'test' database using the master user I'm getting below error

mysql> use information_schema;
Database changed
mysql>
mysql>
mysql> use test;
ERROR 1049 (42000): Unknown database 'test'
mysql>

Why is this error generating ? MySQL Version 5.7

Solution

  • Issue seems to be that the database was not properly created.

    create database test;

    Resolved the issue.