Once you complete, you will see connections window as follows: You should click on Test Connection to make sure that the parameters you provided are correct, and then click OK button to create a new connection. You can leave it blank and select later using the use database command. Default Schema: is the database that you want to connect.
In case you connect to a specific host, use the host name for the name of the connection to make it clear. If you connect to the localhost , just type local. Connection name: the name of the connection.Setup a new connection: you must enter all connection parameters on this Setup New Connection window. To add a new database connection for querying, click New Connection as follows: The newer version of MySQL Workbench is also relevant.
Step 3. Launch MySQL Workbench application from the Program Files > MySQL > MySQL Workbench 5.2 . To make it simple we will unzip it to the C:\temp folder as follows. Unzip the downloaded file into a temporary folder.You can use any folder you want. Download the classicmodels database from the MySQL sample database section. After the tutorial, you will have classicmodels sample database loaded into MySQL server for practicing and learning MySQL.
MYSQL LOAD SAMPLE DATABASE WORKBENCH HOW TO
Summary : in this tutorial, you will learn how to load the MySQL sample database into MySQL database server using MySQL Workbench.