Suppose theĬonfiguration file is in C:\MySQL_Home, then you must specify Specified with \\ (double backslash) or / (Forward slash) character.
#Mysql workbench setup archive
Set the values of the PATH variable to access MySQLĬonnect to MySQL instance using MySQL workbenchįirst, let us download the Zip archive of MySQL 8.0 from the download page.
Start the MySQL server services using the command prompt Initialization of the MySQL data directory and system databases
#Mysql workbench setup install
The steps to install MySQL is as the following: In my previous article, I have explained the step-by-step installation process of MySQL 8.0
#Mysql workbench setup password
Use the same password you used when previously configuring the server to accept remote connections.In this article, I am going to explain the step-by-step installation process of MySQL server 8.0.19 using a noinstall Zip archive. If the connection is successful, click “OK” to save the connection.ĭouble-click the new connection to launch the MySQL Workbench SQL Editor. Select “Standard (TCP/IP)” as the “Connection Type”.Įnter your cloud server’s IP address in the “Hostname” field.Ĭlick “Test Connection” to test the connection. Follow these steps:Ĭlick the “+” symbol in the “MySQL Connections” tab to add a new connection.Įnter a name for the connection in the “Connection Name” field. Once your MySQL server is configured to accept remote connections, you can connect to it using MySQL Workbench. To connect to your remote MySQL database server using MySQL Workbench, you have to allow remote connections to the server. NOTE: This section assumes that you have downloaded and installed MySQL Workbench. The output of the command indicates which database server (MySQL or MariaDB) is used by the installation, and will allow you to identify which guides to follow in our documentation for common database-related operations. To identify which database server is used in your stack, run the command below: $ test -d /opt/bitnami/mariadb & echo "MariaDB" || echo "MySQL"
On account of these changes, the file paths and commands stated in this guide may change depending on whether your Bitnami stack uses MySQL or MariaDB.
NOTE: We are in the process of modifying the configuration for many Bitnami stacks.