Use this guide to learn how to easily create and manage a MySQL 8 user with remote access to all databases.

SQL> create database link capital3 using 'capital3'; Notice that the database link is stored on the server, so the tnsnames.ora file is being used to access these services, not the client.