Use of local/common DB for test
Local databases reside on your local drive or on a local area network. They often have proprietary APIs for accessing the data. It makes the testing more manageable and secure at the same time. We set up a local database when the project is large and have complex data structure.
Steps
- Open Navicat application and click on the connection. Choose MySQL from the dropdown.
- A pop-up form is displayed that contains fields like connection name, host, port, user name, and password. Fill in those fields and press 'OK' button
- Finally, your database is connected and ready to use for local testing.
