You need to make sure you have MySQL set up for remote connections (See: ... The first thing to do is create a database (aka Schema). Open MySQL Workbench and connect to your database server.

The MySQL workbench executes the required SQL statement under the covers, and the schema is listed in the tool. With the schema created, you can now provide any JDBC drivers, Hibernate config or JPA ...

$ sudo mysql -u root Alter or Change the Password Mechanism. By default, MySQL uses socket authentication to authenticate a user, so we need to pass the below command to change the password mechanism.

The MySQL Server -- the core of the database. MySQL Workbench to view your databases and schemas. MySQL Shell to issue SQL statements on the command-line. MySQL Router to help with database scaling.