MySQLDump – How to Skip Email Addresses When Creating Production to Staging Flow

I prefer using MySQL workbench. It's much more easier & user friendly than the command line way.

It provides a simple GUI.

MySQL workbench or SQL Yog.

These are the steps that I did:

1. Install MySQL Workbench.
2. In AWS console, there must be a security group for your RDS instance. Add an inbound rule to that group for allowing connections from your machine. It's simple. Add your IP-address.
3. Open MySQL workbench, Add a new connection.
4. Give the connection a name you prefer.
5. Choose connection method- Standard TCP/IP
6. Enter your RDS endpoint in the field of Hostname.
7. Port:3306
8. Username: master username (the one which which you created during the creation of your RDS instance)
9. Password: master password
10. Click Test Connection to check your connection.
11. If connection is successful, click OK.
12. Open the connection.
13. you will see your database there.
14. Now you can export your mysqldump file to this database. Go to-> Server. Click Data Import.
15. You can check whether the data has been migrated by simply opening a blank SQL file & typing in basic SQL commands like use database, select * from table;

That's it. Viola.

Your GRANT statement seems incorrect.

GRANT select ON `database-name.tableA`.* TO 'userB'@'localhost';

This grants the SELECT privilege on all tables (*) in a database called "database-name.tableA".

The correct statement would be this:

GRANT select ON `database-name`.`tableA` TO 'userB'@'localhost';

Since "database-name.tableA" isn't a valid database, userA can't possibly have permission to access it. When a user tries to grant a permission to another use, the first user must have the privilege they are trying to give to another user, and the first user must have the GRANT OPTION.

You may be asking, "why doesn't the error message tell me there's no such database?"

The reason is because of security. If you don't have permission to access an object, then you also, in most cases, don't have permission to know whether that object exists. If the error message told you the object didn't exist, it would be giving you information that you aren't entitled to know.