This code creates an empty database named quickstartdb. For Enforce SSL connection, select Disabled.Ĭreate table and insert, read, update, and delete dataĬopy and paste the following sample SQL code into the page of a blank SQL tab to illustrate some sample data. If you need to disable SSL, on the server overview page in the Azure portal, select Connection security from the menu. Although typically no additional configuration for SSL certificates is required for MySQL Workbench to connect to your server, we recommend binding the SSL CA certification with MySQL Workbench. 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 is enforced on your Azure Database for MariaDB server. Under MySQL Connections, select the tile that corresponds to your server. To check that all parameters are configured correctly, select Test Connection. To save the password, select Store in Vault. Our example user name is If you don't remember the server admin login name, complete the steps in the preceding section to get the connection information. If you don't remember your server name, complete the steps in the preceding section to get the connection information.Īlways use port 3306 when you connect to Azure Database for MariaDB.Įnter the server admin login user name you used to create the Azure Database for MariaDB instance. Use the fully qualified domain name (*.) as shown in the example. Specify the server name value that you used to create the Azure Database for MariaDB instance. In the Setup New Connection dialog box, on the Parameters tab, enter the following information: Setting To connect to an Azure Database for MariaDB server by using MySQL Workbench: If you forgot your password, you can also reset the password on this page.Ĭonnect to the server by using MySQL Workbench On the server's Overview page, make a note of the values for Server name and Server admin login name. Search for the server you created (such as mydemoserver). In the left menu in the Azure portal, select All resources. You need the fully qualified server name and sign-in credentials. Get the connection information that's required to connect to the Azure Database for MariaDB instance. Create an Azure Database for MariaDB server by using the Azure CLIĭownload MySQL Workbench and install it on your computer.Create an Azure Database for MariaDB server by using the Azure portal.This quickstart uses the resources that are created in either of the following guides as a starting point: This quickstart demonstrates how to connect to an Azure Database for MariaDB instance by using MySQL Workbench. For more information about migrating to Azure Database for MySQL, see What's happening to Azure Database for MariaDB? We strongly recommend for you to migrate to Azure Database for MySQL. Azure Database for MariaDB is on the retirement path.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |