![]() ![]() The steps of the same are discussed one by one in the below section. We can connect to the virtual MariaDB database by creating a gateway of SQL in MySQL workbench. Querying the MariaDB database from Workbench This is a complete and optional configuration property, and if its value is not provided, we can access and refer to the tables from all the databases. Finally, we can even specify the name of the database to which we want to connect to by default. Next, the user’s name and password must be mentioned and set to correct user credentials provided if we have set the Integrated Security property value to false in the configurations. You can refer to the chapter titled “Getting Started” provided in the documentation of configuration of DSN using Microsoft ODBC Data Source Administration.Īfter this, the next step comes the mentioning the properties of port number and the server address to the MariaDB server of your system. For performing the configurations in DSN, we can make the use of built-in ODBC Data Source Administrator provided by Microsoft, which also makes up the last step while installing the driver. The knowledge base for the MariaDB workbench includes connecting to the MariaDB database and querying your database using the workbench to perform different operations to be carried out.Ĭonnecting to MariaDB database from workbenchīefore establishing the connection, you need to mention the values of the properties related to connection inside DSN which stands for Data Source Name. As the MariaDB workbench is just one of the versions of the workbench editor, it has many other editions and versions that are assigned with a license based upon the modules you will always get a version of the workbench that will suit your requirements. To learn more about the features and workbench, you can refer to this link.
0 Comments
Leave a Reply. |