Note: Skip this ‘password’ option if you want to enter the password each time you attempt to connect to this connection config.Hostname - The Hostname can either be the IP Address of the MySQL/MariaDB server, or a FQDN (Fully Qualified Domain Name) that points back to that servers IP Address. This should remain as ‘Standard (TCP/IP)’ for all normal-use cases. When you open Workbench the next time this connection should be available to choose from and it will automatically attempt to connect with the information stored in this connection configuration settings.Ĭonnection Method - The type of connection being made. This will ask for the following:Ĭonnection Name - The connection name determines the name used to display in your list of existing connection options. You will now be prompted to fill out the new connection information. Click this button to add a new connection. Once the application is opened you should see a list of existing connections ( if any), along with the button to add a new connection ( ‘+’ ). Once you have the above-mentioned criteria and have MySQL WorkBench installed then you can follow the steps below to make a connection: If on Linux/cPanel then you can view cPanels guide on managing MySQL/MariaDB databases. Note: If needed… see our guide on managing MySQL/MariaDB databases for our windows environment. Password - The password of the MySQL/MariaDB database you’re wanting to connect to. Username - The username of the MySQL/MariaDB database you’re wanting to connect to.
If on cPanel you can use the IP Address of the server that your cPanel site is hosted on. If in the windows environment you can view the guide mentioned below for finding the hostname of the server.
Hostname - The hostname of the MySQL/MariaDB server that you need to connect to. You’ll also need to obtain the following information in order to connect: The installer for MySQL workbench can be obtained from the site and you can choose your proper OS type ( such as MacOS or Windows). In order to connect to MySQL Workbench, you will need to download this application and install this on your local computer. There are a few applications out there that are fully supported by MariaDB management ( such as HeidiSQL). Since MariaDB is just a drop-in replacement for MySQL, some functionality/features of MySQL WorkBench may not be supported and it’s best to use another application for MariaDB database management for these cases. MySQL is owned and developed by Oracle, which is also the application developer for this MySQL WorkBench application. With MySQL WorkBench you have a newer GUI packed with awesome new features and capabilities to manage your MySQL/MariaDB databases. MySQL WorkBench is the successor to the formerly known ‘ MySQL Administrator’, which has been discontinued for quite some time.
0 kommentar(er)
