Error while loading application state mysql workbench

Connect to a database with MySQL Workbench on your shared, VPS, or Dedicated hosting account. MySQL Workbench is a free tool you can use to connect to your server databases from your personal computer. MySQL Workbench can be Downloaded for free at the following link:

Table of Contents Show

Add IP to your Remote MySQL
Steps to connect to your database remotely
Prerequisite
Install and Configure MySQL Server
Configure MySQL Workbench

You will want to use the Windows (x86, 64-bit), MSI Installer if you are on Windows. The file we are installing in this tutorial is the mysql-workbench-gpl-5.2.47-win32.msi file.

Once you have downloaded MySQL Workbench, you can install it onto your computer. After you have the program installed, follow the steps below to set up a remote connection.

Don’t have time to read the article? Watch our walk-through video.

Add IP to your Remote MySQL

In order for you to be able to connect to your databases remotely you will need to add your local computer IP address to the Remote MySQL in cPanel. You can get your IP address by going to the following link:

What’s My IP address?

Steps to connect to your database remotely

Open MySQL Workbench.
Click New Connection towards the bottom left of MySQL Workbench.
In the “Set up a New Connection Dialogue” box, Type your Database connection credentials. The credentials will be like the following:
Connection Name: You can name this whatever you like.
Connection Method: Standard (TCP/IP).
Hostname: You can use your domain our your cPanel IP address.
Port: 3306
Username: Your cPanel username or the user you created for the database.
Password: cPanel password or the password for the database user that was created.
Default Schema: This can be left blank.
Click Test Connection.
Type your password and click the “Save Password in Vault” check box.Click Ok.
MySQL Workbench should say “Connection parameters are correct“. Click Ok.
Click Ok again to accept the connection settings.
Now under the SQL Development section you will see your connection listed in the Open Connection to Start Querying box. Click your newly created account.
Now you will see the databases list in the area on the left.

Last updated on July 26, 2021
7.1, 7.2, administrator, installation, on-prem, sql

This article provides the instructions to install and configure the MySQL database service with MySQL Workbench for Appspace on-prem.

Prerequisite
Install and Configure MySQL Server
Configure MySQL Workbench

Prerequisite

Download MySQL 8.x: https://dev.mysql.com/downloads/mysql/

Important

Links to the installation instructions on the provider’s website are provided.
Please ensure you take note of and complete the specific configuration required for each application, described in each step below.
Please right-click each installer file and select Run as Administrator to install.

Install and Configure MySQL Server

Follow the instructions below to install and configure the MySQL Server with MySQL Workbench:

Warning

SQL passwords should NOT contain shell metacharacters such as ! # ’ ” ` & ; or spaces.
The database credentials CANNOT be changed once Appspace has been installed.
The database user account must NOT be deleted once Appspace has been installed.

Install MySQL 8.x on your server, as outlined in the Installing MySQL on Microsoft Windows guide here: https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html
Ensure the following configuration settings are made:
- Select the Custom option on the Choosing a Setup Type window, and click Next to continue.
- On the Select Products and Features window, ensure the following options are selected, and moved under the Products/Features To Be Installed section.
  - MySQL Server 8.x (x64 version)
  - MySQL Workbench CE 8.0.x (x64 version)
    Warning
    Only select these 2 options. Leave all the other options unchecked. It is important to make sure that the other options (such as MySQL Connectors) are NOT selected during the MySQL installation.
- In the Group Replication window, select the Standalone MySQL Server/Classic MySQL Replication option.
- In the Type and Networking window, do the following:
  - Select Server Machine from the Config Type drop-down menu.
  - Under Connectivity, check the TCP/IP checkbox, and set the Port Number to 3306.
  - Check Open Firewall port for network access.
  - Check Show Advanced and Logging Options.
- In the Authentication Method window, select the Use Legacy Authentication Method (Retain MySQL 5.x Compatibility) option.
- In the Accounts and Roles window, enter in the MySQL Root Password.
  Warning
  SQL passwords should NOT contain shell metacharacters such as ! # ’ ” ` & ; or spaces.
Proceed to configure the MySQL Workbench by following the instruction in the next section below.

Configure MySQL Workbench

Warning

Ensure the SQL root password created during installation has been granted System Administrator privileges in Windows before proceeding.

Follow the instructions below to configure MySQL Workbench:

Launch the MySQL Workbench from the desktop.
Click the Local instance MySQL80 button, and click Connect to begin the configuration process.
When prompted, enter in the MySQL server root password which was created during the MySQL installation process. Optionally, you may check the Save password in vault check box. Click OK to continue.
In the Navigator pane, click Options File under the INSTANCE section to access the Administration – Options File tab.
Click the General tab, and scroll down to the SQL section.
Edit the sql-mode text field by adding the following to the existing string (before the closing quotation marks): ,ANSI_QUOTES
Warning
Ensure the comma is added, and do NOTleave any blank spaces.
Click the Networking tab, and scroll down to the Timeout Settings and Advanced sections. Check the following check boxes, and set its values as stated:
- interactive_timeout, set the value at 30.
- wait_timeout, set the value at 30.
- max_connect_errors, set the value at 300.
- max_connections, set the value at 500.
Click the Security tab, and uncheck the secure-file-priv option in the Security section.
Click Apply once all configurations have been done.
The Apply Changes to MySQL Configuration File window is displayed, and lists all the configurations that were just made. Click Apply to confirm the changes.
In the Navigator pane, click Startup / Shutdown under the INSTANCE section to access the Administration – Startup / Shutdown tab. The database server instance is status should display running. Click Stop Server to stop the MySQL server.
Once The database server instance is status displays stopped, it can be confirmed that the MySQL server has shutdown.
Click Start Server to restart the MySQL server.