Feedback Print

Linux

The automatic installation already comes with the MySQL extension only needing to connect with the database.

If you are using your own previously configured environment, you will need to enable the MySQL extension in PHP.

Server sent charset unknown to the client
If you are using MySQL 8, due to the PHP 7 bug, an error occurs when trying to connect to the Scriptcase.
Click here and see how to work around this error.

MySQL PDO

Setting up MySQL PDO on Linux

The automatic installation already comes with the MySQL driver, only needing to connect with the database with ScriptCase.

MySQLi

Setting up MySQLi on Linux

The automatic installation already comes with the MySQL driver, only needing to connect with the database with ScriptCase.

Creating a Connection with ScriptCase

  • Access ScriptCase using the URL http://127.0.0.1:8090/scriptcase
  • After accessing ScriptCase, access or create a new project, click on the new connection icon or access “Database > New Connection”

Creating a new connection Creating a new connection

  • After that, you will see a page with all the database connections that you can create. Select a “MySQL” connection

 Selecting a Linux database connection Selecting a Linux database connection

  • New connection : You will place the information of the connection to your database here:

 Connecting with Linux database Connecting with Linux database

  • Connection Name : Defines the name of your new connection.
  • DBMS Driver : Allows you to select the drivers: MySQL PDO.
  • Server/Host (Name or IP) : Insert the name or IP of the server where the Linux database is located.
  • Port : Define the port used for the connection. By default it is 3306.
  • Database Name : Select the database.
  • Username : Inform the user to access the Linux database.
  • Password : Inform the password to access the Linux database.
  • Test Connection : Displays a message of the status of the connection if successful or not.

Setting up security with Linux Setting up security with Linux

  • Use SSL : Activates or deactivates the use of secure connections with Linux.
  • Client Key : Path to the client’s private identification key in the format PEM.
  • Client Certificate : Path to the client’s public certificate key.
  • AC Path : Path to the directory that contains the Authority Certification (AC) in the format PEM, if used, it should specify the same certificate used by the server.
  • AC Certificate : Path to the Authority Certificate (AC) in the format PEM. This option, if used, should specify the same certificate as the server.
  • Specific Chipper : A list of permitted numbers to use with the cryptography of the connection. If one of the numbers is not supported, the SSL connection won’t work.

For more details, consult: Setting up MySQL to use secure connections

  • For more options on connecting, click on the Advanced tab:

 Advanced setup for the Linux database Advanced setup for the Linux database

  • client_encoding : Database Encoding.
  • Decimal Separator - Select the separator type, between a dot or a comma.
  • Persistent Connection - Persistent Connection are connections that do not close when finishing a script.
  • Use the schema before table name - Allows the use of schemas before the name of the tables.

  • Filter : Accessing this tab, we can setup which tables will be listed on this connection:

Filtering the Linux database Filtering the Linux database

  • Show - Allows the display of the the filters on the tables, views, System Tables and procedures.
    • Tables - Allows to setup the display of Tables from your database.
    • Views - Allows to setup the display of Views from your database.
    • System Tables - Allows to setup the display of System Tables from your database.
    • Procedures - Allows to setup the display of Procedures from your database.
  • Searches - Allows to define which tables and Owner will be displayed.
    • Tables - Allows to define a prefix (prefix%) or name of the tables for display.
    • Owner - Allows to define the owner of the tables for listing.
    • Show - Allows to define what will be displayed or not from the table an owner’s setup.