title
MySQL Workbench Installation on Windows 10 | Install MySQL Server and Workbench | Simplilearn

description
🔥Post Graduate Program In Data Analytics: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=InstallMYSQLServer&utm_medium=Descriptionff&utm_source=youtube 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=InstallMYSQLServer&utm_medium=Descriptionff&utm_source=youtube 🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=InstallMYSQLServer&utm_medium=Descriptionff&utm_source=youtube 🔥Data Analyst Masters Program (Discount Code - YTBE15): https://www.simplilearn.com/data-analyst-masters-certification-training-course?utm_campaign=InstallMYSQLServer&utm_medium=Descriptionff&utm_source=youtube This video, Install MySQL Server And Workbenchby Simplilearn, will help you learn about MySQL Workbench installation on Windows 10. This video gives you the step by step instructions for MySQL workbench installation on Windows 10. Once it's set up, you will also get an idea of the basic commands in MySQL. Following are the topics that you will learn in this video: 00:00:00 - 00:01:16 Downloading MySQL on Windows 00:01:16 - 00:06:09 Installing MySQL Community Installer 00:06:09 - 00:16:16 MySQL Demo ✅Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH ⏩ Check out the SQL training videos: https://www.youtube.com/playlist?list=PLEiEAq2VkUUKL3yPbn8yWnatjUg0P0I-Z #SQL #WhatIsSQL #IntroductionToSQL #SQLForBeginners #SQLTutorialForBeginners #LearnSQL #SQLExplained #SQLTraining #Simplilearn What is MySQL? MySQL is one of the most popular relational databases used in the industries. With MySQL, you can build fast, powerful, and secure data storage systems. It is open-source, secure, flexible, and easy to use. You can run MySQL on various platforms such as UNIX, Linux, Windows, etc. You can install it on a server or even on a desktop. ➡️ About Post Graduate Program In Data Analytics This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects. ✅ Key Features - Post Graduate Program certificate and Alumni Association membership - Exclusive hackathons and Ask me Anything sessions by IBM - 8X higher live interaction in live online classes by industry experts - Capstone from 3 domains and 14+ Data Analytics Projects with Industry datasets from Google PlayStore, Lyft, World Bank etc. - Master Classes delivered by Purdue faculty and IBM experts - Simplilearn's JobAssist helps you get noticed by top hiring companies - Resume preparation and LinkedIn profile building - 1:1 mock interview - Career accelerator webinars ✅ Skills Covered - Data Analytics - Statistical Analysis using Excel - Data Analysis Python and R - Data Visualization Tableau and Power BI - Linear and logistic regression modules - Clustering using kmeans - Supervised Learning 👉 Learn More at: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=InstallMYSQLServer&utm_medium=Description&utm_source=youtube 🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=InstallMYSQLServer&utm_medium=Description&utm_source=youtube 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688

detail
{'title': 'MySQL Workbench Installation on Windows 10 | Install MySQL Server and Workbench | Simplilearn', 'heatmap': [{'end': 181.513, 'start': 137.167, 'weight': 0.726}, {'end': 220.357, 'start': 209.308, 'weight': 0.708}, {'end': 326.921, 'start': 302.147, 'weight': 0.772}], 'summary': "Learn to install mysql on windows 10 with step-by-step instructions including selecting and installing mysql server, mysql shell, and mysql workbench, configuring the sql server instance, and running commands to show databases, tables, and components. additionally, the chapter covers creating a 'persons' table, inserting 4 rows of data, and executing basic sql queries, with specific examples and a call-to-action for feedback and subscription to the channel.", 'chapters': [{'end': 502.099, 'segs': [{'end': 33.836, 'src': 'embed', 'start': 8.575, 'weight': 3, 'content': [{'end': 14.06, 'text': 'Hello everyone, welcome to this video tutorial on how to install MySQL on Windows 10 by SimplyLearn.', 'start': 8.575, 'duration': 5.485}, {'end': 19.724, 'text': 'In this session, we will learn how to install MySQL Workbench and then we will run some commands.', 'start': 14.8, 'duration': 4.924}, {'end': 28.051, 'text': 'So hey everyone, I am Abhisar Raoja from SimplyLearn and welcome to this video on how to install MySQL on Windows 10.', 'start': 20.845, 'duration': 7.206}, {'end': 33.836, 'text': 'But before we begin, if you love watching tech videos, subscribe to our channel and hit the bell icon to never miss an update.', 'start': 28.051, 'duration': 5.785}], 'summary': 'Video tutorial on installing mysql on windows 10 by simplylearn.', 'duration': 25.261, 'max_score': 8.575, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YSOY_NyOg40/pics/YSOY_NyOg408575.jpg'}, {'end': 181.513, 'src': 'heatmap', 'start': 123.197, 'weight': 1, 'content': [{'end': 129.502, 'text': 'and choose the mysql workbench version you want to install and click on the arrow.', 'start': 123.197, 'duration': 6.305}, {'end': 133.425, 'text': 'we will do the same thing for mysql shell.', 'start': 129.502, 'duration': 3.923}, {'end': 135.426, 'text': "we'll choose the latest version.", 'start': 133.425, 'duration': 2.001}, {'end': 137.167, 'text': 'click on the arrow.', 'start': 135.426, 'duration': 1.741}, {'end': 140.51, 'text': 'so these are the products that have to be installed in a system.', 'start': 137.167, 'duration': 3.343}, {'end': 144.833, 'text': "now we'll click next.", 'start': 140.51, 'duration': 4.323}, {'end': 150.297, 'text': 'now click execute to download and install the server.', 'start': 144.833, 'duration': 5.464}, {'end': 152.519, 'text': 'this may take a while, depending on your internet speed.', 'start': 150.297, 'duration': 2.222}, {'end': 161.197, 'text': 'as the download is completed, click next.', 'start': 155.433, 'duration': 5.764}, {'end': 164.74, 'text': 'now you will see the product configuration.', 'start': 161.197, 'duration': 3.543}, {'end': 166.762, 'text': 'click next.', 'start': 164.74, 'duration': 2.022}, {'end': 169.924, 'text': 'now we will configure our sql server instance.', 'start': 166.762, 'duration': 3.162}, {'end': 179.611, 'text': 'here we will go with the default settings and click next and under authentication, select use strong password encryption for authentication,', 'start': 169.924, 'duration': 9.687}, {'end': 181.513, 'text': 'which is recommended and click on next.', 'start': 179.611, 'duration': 1.902}], 'summary': 'Install mysql workbench and shell, configure server and select strong password encryption.', 'duration': 29.322, 'max_score': 123.197, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YSOY_NyOg40/pics/YSOY_NyOg40123197.jpg'}, {'end': 232.263, 'src': 'heatmap', 'start': 209.308, 'weight': 0, 'content': [{'end': 210.349, 'text': 'Now I will click on next.', 'start': 209.308, 'duration': 1.041}, {'end': 220.357, 'text': 'and here also we will keep the default settings and click on next now to apply configuration.', 'start': 212.853, 'duration': 7.504}, {'end': 225.98, 'text': 'we will execute the process once all the configuration steps are complete.', 'start': 220.357, 'duration': 5.623}, {'end': 230.162, 'text': 'click finish.', 'start': 225.98, 'duration': 4.182}, {'end': 232.263, 'text': 'now you will see the installation is complete.', 'start': 230.162, 'duration': 2.101}], 'summary': 'Installation completed after executing the process and clicking finish.', 'duration': 45.515, 'max_score': 209.308, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YSOY_NyOg40/pics/YSOY_NyOg40209308.jpg'}, {'end': 326.921, 'src': 'heatmap', 'start': 302.147, 'weight': 0.772, 'content': [{'end': 326.921, 'text': 'we will go into this pc localhost 3 program files mysql, mysql server 8.0 bin and now we will copy this path.', 'start': 302.147, 'duration': 24.774}], 'summary': 'Copying the mysql server 8.0 bin path from the pc localhost 3 program files.', 'duration': 24.774, 'max_score': 302.147, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YSOY_NyOg40/pics/YSOY_NyOg40302147.jpg'}, {'end': 394.93, 'src': 'embed', 'start': 347.281, 'weight': 2, 'content': [{'end': 355.526, 'text': 'just enter the password and press enter.', 'start': 347.281, 'duration': 8.245}, {'end': 361.21, 'text': "now the server has started and now we'll see some commands in my sql workbench.", 'start': 355.526, 'duration': 5.684}, {'end': 362.871, 'text': 'first we will open my sql workbench.', 'start': 361.21, 'duration': 1.661}, {'end': 377.298, 'text': 'Now we will click on the local instance, mysql80, and enter the password to connect to the localhost.', 'start': 370.413, 'duration': 6.885}, {'end': 388.485, 'text': 'Now the mysql workbench has started.', 'start': 386.164, 'duration': 2.321}, {'end': 390.687, 'text': 'Now we will see some commands.', 'start': 388.505, 'duration': 2.182}, {'end': 394.93, 'text': 'The first command we will see is show databases.', 'start': 392.488, 'duration': 2.442}], 'summary': "Starting server, connecting to mysql, executing 'show databases' command.", 'duration': 47.649, 'max_score': 347.281, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YSOY_NyOg40/pics/YSOY_NyOg40347281.jpg'}], 'start': 8.575, 'title': 'Installing mysql on windows 10', 'summary': 'Explains step-by-step instructions to install mysql on windows 10, covering downloading the mysql installer, selecting and installing mysql server, mysql shell, and mysql workbench, configuring the sql server instance, and running commands to show databases, tables, and components.', 'chapters': [{'end': 502.099, 'start': 8.575, 'title': 'Install mysql on windows 10', 'summary': 'Explains how to install mysql on windows 10 by simplylearn, including downloading the mysql installer, selecting and installing mysql server, mysql shell, and mysql workbench, configuring the sql server instance, and running commands to show databases, tables, and components.', 'duration': 493.524, 'highlights': ['The chapter explains how to install MySQL on Windows 10 by SimplyLearn, including downloading the MySQL installer, selecting and installing MySQL Server, MySQL Shell, and MySQL Workbench, configuring the SQL server instance, and running commands to show databases, tables, and components.', 'The download and installation process may take a while, depending on the internet speed.', "The default user 'root' will have access to everything in the MySQL server.", 'The chapter demonstrates running commands in MySQL Workbench to show databases, tables, and components, providing a practical understanding of the installed system.']}], 'duration': 493.524, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YSOY_NyOg40/pics/YSOY_NyOg408575.jpg', 'highlights': ["The default user 'root' will have access to everything in the MySQL server.", 'The download and installation process may take a while, depending on the internet speed.', 'The chapter demonstrates running commands in MySQL Workbench to show databases, tables, and components, providing a practical understanding of the installed system.', 'The chapter explains how to install MySQL on Windows 10 by SimplyLearn, including downloading the MySQL installer, selecting and installing MySQL Server, MySQL Shell, and MySQL Workbench, configuring the SQL server instance, and running commands to show databases, tables, and components.']}, {'end': 990.268, 'segs': [{'end': 535.131, 'src': 'embed', 'start': 502.099, 'weight': 0, 'content': [{'end': 506.161, 'text': 'that is, component id, component group id, component new rn.', 'start': 502.099, 'duration': 4.062}, {'end': 507.862, 'text': 'but there are no values.', 'start': 506.161, 'duration': 1.701}, {'end': 512.664, 'text': 'there are null values in the table now.', 'start': 507.862, 'duration': 4.802}, {'end': 516.426, 'text': 'now we will write a command to create a table.', 'start': 512.664, 'duration': 3.762}, {'end': 524.845, 'text': 'now we will create a table in the mysql database for creating the table.', 'start': 516.426, 'duration': 8.419}, {'end': 535.131, 'text': "the syntax is create table, table name and then we'll start with the round brackets and then we'll write the column name and then what column it is,", 'start': 524.845, 'duration': 10.286}], 'summary': 'Creating a table in mysql database with specified column names.', 'duration': 33.032, 'max_score': 502.099, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YSOY_NyOg40/pics/YSOY_NyOg40502099.jpg'}, {'end': 672.947, 'src': 'embed', 'start': 641.707, 'weight': 1, 'content': [{'end': 647.01, 'text': 'Now what we see is that the table is created and all the columns are there, but there are no values.', 'start': 641.707, 'duration': 5.303}, {'end': 650.192, 'text': 'So we will insert the values and then see the table.', 'start': 647.551, 'duration': 2.641}, {'end': 664.481, 'text': 'So. to do that, we will run the commands that would be insert into table, that is, persons, then values.', 'start': 651.633, 'duration': 12.848}, {'end': 672.947, 'text': "Then we'll start the round bracket and write the values according to the column names.", 'start': 667.523, 'duration': 5.424}], 'summary': 'Table created with columns, now inserting values.', 'duration': 31.24, 'max_score': 641.707, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YSOY_NyOg40/pics/YSOY_NyOg40641707.jpg'}, {'end': 970.386, 'src': 'embed', 'start': 882.236, 'weight': 2, 'content': [{'end': 896.44, 'text': 'Select star from persons and what condition we should put would be we would obtain the two rows with the persons living in the city Delhi.', 'start': 882.236, 'duration': 14.204}, {'end': 920.338, 'text': "So we'll write the command select star from persons where city equal to delhi semicolon,", 'start': 897.04, 'duration': 23.298}, {'end': 931.324, 'text': 'and we will run this command and what we will get is the two rows with the persons living in the city delhi, that is, gotham and virat.', 'start': 920.338, 'duration': 10.986}, {'end': 938.65, 'text': 'Now we will see a command to obtain only a column from the table.', 'start': 933.027, 'duration': 5.623}, {'end': 956.338, 'text': 'that would be select column name, that we will select first name, first name from table name, that is persons semicolon,', 'start': 938.65, 'duration': 17.688}, {'end': 957.459, 'text': 'and now we will run this command.', 'start': 956.338, 'duration': 1.121}, {'end': 964.261, 'text': 'So what we have got is that is the column, first name from the TV persons.', 'start': 959.437, 'duration': 4.824}, {'end': 967.844, 'text': 'With that, we have come to the end of this session.', 'start': 965.682, 'duration': 2.162}, {'end': 970.386, 'text': 'I hope it was interesting and informative.', 'start': 967.864, 'duration': 2.522}], 'summary': "Selecting data from table 'persons' in sql to retrieve specific rows and columns.", 'duration': 88.15, 'max_score': 882.236, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YSOY_NyOg40/pics/YSOY_NyOg40882236.jpg'}], 'start': 502.099, 'title': 'Mysql database operations', 'summary': "Covers creating a 'persons' table in mysql database, inserting 4 rows of data, and basic sql queries, with specific examples and a call-to-action for feedback and subscription to the channel.", 'chapters': [{'end': 672.947, 'start': 502.099, 'title': 'Creating table in mysql database', 'summary': "Covers the process of creating a table in mysql database, including defining columns and inserting values, with a focus on creating a 'persons' table with specific column names and types.", 'duration': 170.848, 'highlights': ["The syntax for creating a table in MySQL database involves using the 'create table' command followed by the table name and column definitions, such as 'persons' table with columns like 'person id', 'first name', 'last name', and 'city'.", "The process includes executing commands like 'create table' to define the table structure and 'insert into' to add values, as well as using 'select star from persons' to view the table contents.", "The chapter emphasizes the creation of a 'persons' table in the MySQL database, detailing the definition of columns such as 'person id' as integer, 'first name' and 'last name' as where care, and 'city' as where care."]}, {'end': 881.756, 'start': 674.088, 'title': 'Inserting data into database table', 'summary': 'Covers inserting multiple rows of data into a database table using sql commands, with specific examples of inserting 4 rows and verifying the insertion.', 'duration': 207.668, 'highlights': ['The speaker demonstrates inserting multiple rows of data into a database table using SQL commands, specifically inserting 4 rows.', "The example includes inserting rows with specific values, such as 'Kotham Kambhir' from Delhi and 'Virat Coli' from Delhi.", "The process of verifying the insertion is shown through executing SQL commands, such as 'select star from persons;' to check the inserted rows.", "Details about executing additional commands, such as inserting rows with 'Mumbai' as the city and verifying the insertion of 4 rows, are also covered."]}, {'end': 990.268, 'start': 882.236, 'title': 'Sql query basics', 'summary': 'Covers basic sql queries including selecting all columns and filtering by a specific condition, obtaining a single column from a table, with examples of the actual commands and their results, ultimately ending with a call-to-action for feedback and subscription to the channel.', 'duration': 108.032, 'highlights': ["The command to obtain only a column from the table is 'select column name, that we will select first name, first name from table name, that is persons semicolon', resulting in the column 'first name' from the table 'persons'.", "The command to obtain rows with persons living in the city Delhi is 'select star from persons where city equal to delhi semicolon', which retrieves two rows with the persons living in the city Delhi, namely gotham and virat."]}], 'duration': 488.169, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YSOY_NyOg40/pics/YSOY_NyOg40502099.jpg', 'highlights': ["The syntax for creating a table in MySQL involves using the 'create table' command with specific column definitions.", 'Demonstrates inserting 4 rows of data into a database table using SQL commands.', "Executing 'select star from persons' to view the table contents is emphasized.", 'The command to obtain only a column from the table is demonstrated.', 'The command to obtain rows with persons living in the city Delhi is shown.']}], 'highlights': ['The chapter explains how to install MySQL on Windows 10 by SimplyLearn, including downloading the MySQL installer, selecting and installing MySQL Server, MySQL Shell, and MySQL Workbench, configuring the SQL server instance, and running commands to show databases, tables, and components.', "The default user 'root' will have access to everything in the MySQL server.", 'The chapter demonstrates running commands in MySQL Workbench to show databases, tables, and components, providing a practical understanding of the installed system.', 'The download and installation process may take a while, depending on the internet speed.', "The syntax for creating a table in MySQL involves using the 'create table' command with specific column definitions.", 'Demonstrates inserting 4 rows of data into a database table using SQL commands.', "Executing 'select star from persons' to view the table contents is emphasized.", 'The command to obtain only a column from the table is demonstrated.', 'The command to obtain rows with persons living in the city Delhi is shown.']}