Now we’ll access Scriptcase from Scriptcase from the browser and create a connection with the MySQL database.
Step 1: Access your Scriptcase, for example, http://localhost:8081/scriptcase/ on
the toolbar
go to the marked icon in the image below, referring to “New Connection”.
Step 2: After clicking “New Connection”, the page for creating connections will appear, click on the
MySQL database image.
Step 3: On the following image, place the required information:
Connection Name - Define the name of your new connection.
DBMS Driver - Allows you to define the driver that’ll be used, by default it’s MySQL PDO.
Test Connection - Validates the connection and informs if it was successful or not.
Server/Host (Name or IP) - Inform the location of the MySQL database.
Port - Inform the port to be used for your connection. By Default port is 3306.
Database Name - Select the name of your database.
User - Inform the user of your MySQL database.
Password - Inform the password of your MySQL database.
For more details on configuring the connection of the database click on Advanced
Decimal Separator - Select the type of separator, between coma and period.
Persistent Connection - Persistent connections are connections that don’t close after running
your script.
Use the schema before the table name - Allows the use of schemas before the table names.
Filter - By clicking on this tab, you will see this page:
Show - Allows to show Tables, Views, System Tables and Procedures.
Searches - Allows to define which tables and owners will be shown.
Step 4: Always test your connection before saving, if the message “Connection Success” appears, then
save the connection. If it fails to connect, revise the fields that were informed, especially Username, Password,
Database and Server/Host.
