How to load sample database in mysql workbench

• • 1.3 Loading the sample database into your own local MySQL database server

    Nội dung chính Show

    • 1.3 Loading the sample database into your own local MySQL database server
    • Summary: in this section, you will learn how to load the MySQL sample database into MySQL database server using MySQL Workbench. After the tutorial, you will have classicmodels sample database loaded into MySQL server for practicing and learning MySQL.Step 1. Download the classicmodels database from the MySQL sample database section.Step 2. Unzip the downloaded file into a temporary folder.You can use any folder you want. To make it simple we will unzip it to the C:\temp  folder as follows.Step 3. Launch MySQL Workbench application from the Program Files > MySQL > MySQL Workbench 5.2 . The newer version of MySQL Workbench is also relevant.Step 4. To add a new database connection for querying, click New Connection as follows:Step 5. Setup a new connection: you must enter all connection parameters on this Setup New Connection window. The following information is required:Connection name: the name of the connection. If you connect to the localhost , just type local. In case you connect to a specific host, use the host name for the name of the connection to make it clear.Host name: in this case it is 127.0.0.1 i.e., localhost . You can enter either IP address or the name of the database server.Username: the user that you use connect to the MySQL database. In this case it it the root user.You can also provide the following information optionally:Password: the password of the user that you use to connect to the database.Default Schema: is the database that you want to connect. You can leave it blank and select later using the use database command.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. Once you complete, you will see connections window as follows:Step 6. Click the local database connection to connect to MySQL database server. Because we didn’t provide the password in the previous step, MySQL asks us to enter the password for the root account. We enter our password and click OK button.If you enter both user and password correctly, you will see the following window:Step 7. Open SQL Script by choosing File > Open SQL Script  or press the Ctrl+Shift+O keyboard shortcut.Step 8. Choose SQL Script File by selecting the File C:\temp\mysqlsampledatabase.txtStep 10. To execute SQL Script, you click execute button from the toolbar as following:Step 11. Right click inside the Schemas panel and click Refresh All button to update the panel. The classimodels database is loaded successfully into MySQL database server.In this section, we have shown you step by step how to load the MySQL sample database into MySQL database server using MySQL Workbench.
    • How do I run a sample database in MySQL?
    • How do I import a database sample?
    • How do I load a MySQL database?
    • Does MySQL have sample database?

1.3 Loading the sample database into your own local MySQL database server

Summary: in this section, you will learn how to load the MySQL sample database into MySQL database server using MySQL Workbench. After the tutorial, you will have classicmodels sample database loaded into MySQL server for practicing and learning MySQL.Step 1. Download the classicmodels database from the MySQL sample database section.Step 2. Unzip the downloaded file into a temporary folder.You can use any folder you want. To make it simple we will unzip it to the C:\temp  folder as follows.Step 3. Launch MySQL Workbench application from the Program Files > MySQL > MySQL Workbench 5.2 . The newer version of MySQL Workbench is also relevant.Step 4. To add a new database connection for querying, click New Connection as follows:Step 5. Setup a new connection: you must enter all connection parameters on this Setup New Connection window. The following information is required:Connection name: the name of the connection. If you connect to the localhost , just type local. In case you connect to a specific host, use the host name for the name of the connection to make it clear.Host name: in this case it is 127.0.0.1 i.e., localhost . You can enter either IP address or the name of the database server.Username: the user that you use connect to the MySQL database. In this case it it the root user.You can also provide the following information optionally:Password: the password of the user that you use to connect to the database.Default Schema: is the database that you want to connect. You can leave it blank and select later using the use database command.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. Once you complete, you will see connections window as follows:Step 6. Click the local database connection to connect to MySQL database server. Because we didn’t provide the password in the previous step, MySQL asks us to enter the password for the root account. We enter our password and click OK button.If you enter both user and password correctly, you will see the following window:Step 7. Open SQL Script by choosing File > Open SQL Script  or press the Ctrl+Shift+O keyboard shortcut.Step 8. Choose SQL Script File by selecting the File C:\temp\mysqlsampledatabase.txtStep 10. To execute SQL Script, you click execute button from the toolbar as following:Step 11. Right click inside the Schemas panel and click Refresh All button to update the panel. The classimodels database is loaded successfully into MySQL database server.In this section, we have shown you step by step how to load the MySQL sample database into MySQL database server using MySQL Workbench.