![]() To run the sample SQL Code, select the lightening bolt icon in the toolbar of the SQL File tab. The screenshot shows an example of the SQL code in SQL Workbench and the output after it has been run. UPDATE inventory SET quantity = 200 WHERE id = 1 INSERT INTO inventory (name, quantity) VALUES ('apple', 100) INSERT INTO inventory (name, quantity) VALUES ('orange', 154) INSERT INTO inventory (name, quantity) VALUES ('banana', 150) Create a databaseĬREATE TABLE inventory (id serial PRIMARY KEY, name VARCHAR(50), quantity INTEGER) Finally it deletes a row, and then reads the rows again. It changes the data with an update statement, and reads the rows again. It inserts some rows, then reads the rows. This code creates an empty database named quickstartdb, and then creates a sample table named inventory. If you need to disable SSL, visit the Azure portal and select the Connection security page to disable the Enforce SSL connection toggle button.Ĭreate a table, insert data, read data, update data, delete dataĬopy and paste the sample SQL code into a blank SQL tab to illustrate some sample data. For more information on how to download and bind the certification, see Configure SSL connectivity in your application to securely connect to Azure Database for MySQL. Although typically no additional configuration with SSL certificates is required for MySQL Workbench to connect to your server, we recommend binding the SSL CA certification with MySQL Workbench. In the listing of MySQL Connections, select the tile corresponding to your server, and then wait for the connection to be established.Ī new SQL tab opens with a blank editor where you can type your queries.īy default, SSL connection security is required and enforced on your Azure Database for MySQL server. Select Test Connection to test if all parameters are correctly configured. Our example username is Follow the steps in the previous section to get the connection information if you don't remember the username. Type in the server admin login username supplied when you created the Azure Database for MySQL earlier. ![]() Follow the steps in the previous section to get the connection information if you don't remember your server name.Īlways use port 3306 when connecting to Azure Database for MySQL. Use the fully qualified domain name (*.) as shown in the example. Specify the server name value that was used when you created the Azure Database for MySQL earlier. In Setup New Connection dialog box, enter the following information on the Parameters tab: Launch the MySQL Workbench application on your computer. ![]() To connect to Azure MySQL Server by using the GUI tool MySQL Workbench: If you forget your password, you can also reset the password from this panel.Ĭonnect to the server by using MySQL Workbench You need the fully qualified server name and login credentials.įrom the left-hand menu in Azure portal, select All resources, and then search for the server you have created (such as mydemoserver).įrom the server's Overview panel, make a note of the Server name and Server admin login name. Get the connection information needed to connect to the Azure Database for MySQL. Use the same password you used when previously configuring the server to accept remote connections.Ensure the IP address you're connecting from has been added the server's firewall rules using the Azure portal or Azure CLI Install MySQL Workbenchĭownload and install MySQL Workbench on your computer from the MySQL website. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |