SQL Tutorial 2: Installing MySQL, Working with SQL Workbench & Command Line Clients

Рет қаралды 233,878

5 жыл бұрын

Topic : Installing MySQL, Working with SQL Workbench & Command Line Clients
#########################
Udemy Courses:
#########################
Manual Testing+Agile with Jira Tool
************************************
► shorturl.at/xNXZ4
Selenium with Java+Cucumber
********************************
► shorturl.at/aIKMW
Selenium with Python & PyTest
********************************
► shorturl.at/ELW09
Selenium with python using Robot framework
****************************************
► shorturl.at/bcDPZ
API Testing(Postman, RestAssured & SoapUI)
*****************************************
► shorturl.at/uAWY7
Web & API Automation using Cypress with Javascript
********************************************
► rb.gy/4uum2n
Playwright with Javascript
**************************
► shorturl.at/gALZ1
Jmeter-Performance Testing
************************
► rb.gy/ocj7r2
SDET Essencials(Full Stack QA)
*************************
► rb.gy/hlnf2v
Appium-Mobile Automation Testing
************************************
► rb.gy/wmzv64
Java Collections
*****************
► bit.ly/3S66ezE
Python Programming
*********************
► urlis.net/gdsfpb0s
Cucumber BDD Framework
***************************
► bit.ly/3F7d69r
Protractor with Javascript
***************************
► urlis.net/4uddm1qb
####################################
KZfaq Playlists:
####################################
Manual Testing & Agile
***********************
► bit.ly/3ujvaYa
► bit.ly/3OYzxQj
SQL
*************************
► bit.ly/3R6XjeG
► bit.ly/3nE0a1s
► bit.ly/3IeKuuJ
linux & Shell Scripting
**********************
► bit.ly/3up1Z6a
► bit.ly/3nzvGxx
Java
**********************
► bit.ly/3R9QfOs
► bit.ly/3AoRMKM
► bit.ly/3IbTTDn
► bit.ly/3ybXInv
► bit.ly/3yCoHdw
Selenium With Java+Cucumber
********************************
► bit.ly/3P2FMm4
► bit.ly/3yhiIt4
► bit.ly/3uokzet
► bit.ly/3a7XIND
► bit.ly/3umN2S9
► bit.ly/3aar7GW
► bit.ly/3y9kD2S
► bit.ly/3uhLskn
Python
********************************
► bit.ly/3agNgU0
► bit.ly/3NJNnoy
► bit.ly/2CTQ4mR
► bit.ly/3OIYWh1
Selenium With Python,Pytest&Behave
***************************************
► bit.ly/3OHHoC9
► bit.ly/3IeNLdv
► bit.ly/2J4tPeT
► bit.ly/3ydSkAq
Selenium With Python Using Robert Framework
(Web&API Testing)
*************************************************
► bit.ly/3nUvlpr
► bit.ly/3nUvE3z
API Testing (Postman,SoapUi,&Rest Assured)
**********************************************
► bit.ly/3OXacWY
► bit.ly/3yh0UhE
► bit.ly/3nC9DWQ
► bit.ly/3yGfhNS
► bit.ly/3OJa11H
► bit.ly/3P2slCC
Mobile App Testing Appium
****************************
► bit.ly/3Al49HG
Performance Testing Jmeter
*******************************
► bit.ly/3nz4fE7
Maven,Jenkins,Git,Github,CI/CD
*******************************
► bit.ly/3P16HPj
► bit.ly/3yhlUVA
► bit.ly/3afYfwT
► bit.ly/3yGzweG
► bit.ly/3yF73Ws
► bit.ly/3NCOmH7
SQL,DB Testing&ETL,Bigdata
*******************************
► bit.ly/3NKOcNY
► bit.ly/3OVpDyI
► bit.ly/3NEvUy0
► bit.ly/3IryxlT
► bit.ly/3RkWBLh
JavaScript Based Automation Tools
********************************
► bit.ly/3nUx51X
► bit.ly/3AqI6Q0
► bit.ly/3yeurbT
► bit.ly/3ujzpTK
Selector Hub Tools
********************
►rb.gy/h3h424
GraphQL
******************
► rb.gy/sj3gys
Cypress API Testing
********************
► shorturl.at/fjKPX
Cypress Web Testing
**********************
► shorturl.at/agjlK
Playwright with Javascipt
**************************
► shorturl.at/adSTY
#SQLTutorial
#MySQLInstallation
#WorkbenchSetup
#DatabaseManagement
#SQLforBeginners
#LearnSQL
#MySQLBasics
#WorkbenchTutorial
#DatabaseInstallation
#SQLDatabase
#MySQLServer
#SQLWorkbench
#MySQLTutorial
#SQLInstallationGuide
#DatabaseAdmin
#SQLServerSetup
#DatabaseDevelopment
#SQLTraining
#MySQLAdmin
#WorkbenchInstallation
#SQLTips
#DatabaseDesign
#MySQLQueries
#SQLForDataAnalysis
#WorkbenchBasics
#DatabaseSetup
#SQLProgramming
#MySQLDeveloper
#SQLBeginner
#WorkbenchTips
#DatabaseTutorial
#SQLLearning
#MySQLManagement
#WorkbenchDevelopment
#SQLMastery
#DatabaseEngine
#MySQLSkills
#SQLHowTo
#WorkbenchTricks
#DatabaseInstallationGuide
#SQLForNewbies
#MySQLQueries101
#WorkbenchEssentials
#DatabaseAdminSkills
#SQLExplained
#MySQLWorkshop
#WorkbenchPro
#DatabaseSetupGuide
#SQLFundamentals
#MySQL101

Пікірлер: 116

@user-ci5ys9tl7u 4 ай бұрын

Hi sir my writing this comments from my bottom of the heart, my company lay offed me after one month of period i have watched all the videos start from manual testing to SQL you are one of the most talented person with no return from your student , i have got placed in good company with best package in the market, today i am there because of you only thank you for your knowledge sharing sir.

@SurprisedDriftwood-cq1ec 3 ай бұрын

Hlo can we connect I need help coz I m.a fresher

@revathysathishkumar8035 4 ай бұрын

No one can explain in very simple way like this other than you. Thank you so much. You are helping so many people for career change.

@sdetpavan 4 ай бұрын

Welcome

@nikeshkumar-gl1fv 3 жыл бұрын

One of the best instructor i have ever seen. Thanks alot sir for providing such a meaningful information.

@sdetpavan 3 жыл бұрын

Thanks and welcome

@123afgh Жыл бұрын

Thank you, sir, I have seen a lot of videos from different tutors they got M watched but they cannot explain it like you, Im so happy to see your all courses

@Sliceoflife.Farhaz 8 ай бұрын

I'm working as Manual tester is only because of u sir. Thanks alot. U r the best instructor Sir. Now thinking to learn Automation testing, so I tried a lot to reach you Sir, but ur old number is not working, no replies for my mails. I really wanted to join the Automation classes. Please let me know further details Sir.

@AnjaliGupta-ig5jy Жыл бұрын

I am not from IT Backgroud but I can understand everything easily.thank you very much

@bhavanamtiwari9540 2 жыл бұрын

Level of knowledge 🙏🏻🙏🏻🙏🏻🙇🙇🙇🙇Sir u r angel sent on Earth 🙏🏻🙏🏻 Thanku for the unbelievable way of explanation u provide us

@sdetpavan Жыл бұрын

It's my pleasure

@aditirathore7421 2 жыл бұрын

Best Channel on KZfaq!!!! Thank you sir.

@sdetpavan 2 жыл бұрын

Most welcome!

@sarheenpamidi7061 Жыл бұрын

Best teaching. May God give whatever you want. Thank you for providing good Content.

@sdetpavan Жыл бұрын

Welcome

@Imana23 2 жыл бұрын

I installed an older version of mysql on my mac 2013. Do I need to download workbench separately or it should be in the package. Also do I need workbench as a sql beginner? Thank you.

@Upsaracollections 8 ай бұрын

Sir one should have a good heart to share knowledge for free!!! i feel blessed to have such a talented educator thankyou thanks a lot

@sdetpavan 8 ай бұрын

It's my pleasure

@shrevardhniumesh1170 3 жыл бұрын

Thank you very much sir....for the detailed explanation of the installation procedure...

@sdetpavan Жыл бұрын

Welcome

@jignashasakhiya Жыл бұрын

@@sdetpavan Hello sir, I followed all the steps in the installation. but I don't see tables "jobs" and "location" under the "world" database. what could be the reason. please help. otherwise, I won't be able to practice along with your tutorial. thank you.

@dillibabuvarthala1909 2 жыл бұрын

Sir thanks for your videos. Concepts explained clearly. Sir, I need "hr" database for practice. Please provide the same

@muhammadjunaidmajeed1211 3 жыл бұрын

Excellent!

@sdetpavan Жыл бұрын

Thanks

@basanagoudabiradar8669 2 ай бұрын

Thank you so much sir 👍

@sdetpavan 2 ай бұрын

Welcome

@bjaggu 3 жыл бұрын

Where can i get Hr DataBase? to practice

@elladatofigli8120 3 жыл бұрын

This installation is only for Windows OP? I have Mac and I already have installed MySQL, but I don’t have access to those schemas.

@mayurivmulje1407 Жыл бұрын

You made it very easy :)

@sdetpavan Жыл бұрын

Glad to hear that!

@venkatsaierram8079 3 жыл бұрын

Hi sir ,while installing it is displaying only 1 product and in Status it's displaying like Configuration Cancelled

@saisurya2213 4 жыл бұрын

hi sir , really your videos helping me a lot , but when i follow the same procedure which you told me but i am getting other product configuration in this point i am not able to proceed future kindly help me to come out of this issue

@tejastoley6714 2 жыл бұрын

which credentials should enter for connecting the server?

@eshwar1510 Жыл бұрын

sir i previously installed MYSQL in my machine, and uninstalled it, now i am trying to install it again, but while installing only MYSQL connector upgrand option is avaliable . How to resolve it

@Eng-Mohamed-Ahmed 2 жыл бұрын

good explanations thanks.

@sdetpavan Жыл бұрын

welcome

@moondust8053 11 ай бұрын

Thank you sir.

@sdetpavan 11 ай бұрын

Welcome

@satrunball4454 Жыл бұрын

Hi Pavan Sir These videos are useful for manual testing ?

@chittelikarrthika5166 Жыл бұрын

Sir you are best ......Saviour

@sdetpavan Жыл бұрын

Thanks

@KrishanKumar-jo7ss 11 ай бұрын

Excellent lecture ❤

@sdetpavan 11 ай бұрын

Thank you

@cherrybloom5162 4 жыл бұрын

Hi sir. These 16 videos are enough for software testers or am I missing any more videos on Mysql.

@bhavanithadi1072 3 жыл бұрын

Sir is this sql knowledge enough for automation testing???

@saranyachandrabos3541 2 жыл бұрын

Thank you....

@sdetpavan Жыл бұрын

Welcome

@ramyabts74 2 жыл бұрын

Sir..Can you please how to download & install Mysql in current version...

@Indu2ber 2 жыл бұрын

Show Database command is not working in MySQL CLI. Getting error as unexpected identifier Installed the s/w as per the process shown.

@vivekvicky748 2 жыл бұрын

Sir please help me in MySQL i don't have jobs and locations in world options how do I solve this. Please reply sir 🙏

@omkarmanjare385 10 ай бұрын

can you share link of freely available database(classicmodels) from your channel ,because practice sql queries

@buzz5minute217 Жыл бұрын

There is no MSI downloading it is downloading only one archive file of latest version 8.0.30 around 220MB. In that there is no setup file, please help how to install. Ihve searched all folders for setup file.

@andreipascu741 3 жыл бұрын

For anyone who encountered the server error, at 5:31 if you have more options other than the ones displayed on his screen, press "execute" . He already has those installed, you don't.

@akabarijaimin1129 Жыл бұрын

I am facing same error, Can you please guide me?

@meenakshi3799 2 жыл бұрын

I installed sql new version but not installing please guide me , send recent link

@Ashish-kn9xb 2 жыл бұрын

Didn't get workbench what to do??? Anyone help plw

@examtakbypankajkushwaha953 2 жыл бұрын

Plz latest software mysql ka installation ka vedio banaeye sir...

@zayb007 2 жыл бұрын

Sir. I hv followed ur all s/w instalation but it didn't installed completely. Reconfiguration is showing i kindly requesting sir please help me to install this sw.. I must need it please sir help me

@eachoneteachone2181 Жыл бұрын

I'm unable to install my SQL software sir... while installing getting error message as net.framerun error

@asharaju4169 9 ай бұрын

I am not working in any company right now then how do i install this as it is asking company details

@aninditasamanta2748 6 ай бұрын

In my system not having option mysql command line client what to do

@shubhampandey559 6 ай бұрын

Sir, I'm unable to find or launch the Workbench. Only client option I'm getting please help me out. Anyone please help

@bindumadala7517 4 жыл бұрын

Hi sir. By following your instructions i have downloaded MYSQL & Installed but i am not getting as your screen. What i have to do. Please guide me

@appireddysowjanya5718 3 жыл бұрын

for me also same thing getting different screen

@shameedboom6139 2 жыл бұрын

how can i get this on a mac

@DMK96180 3 ай бұрын

Sir MySQL command line client installed successfully,but MySQL bench is not installed

@oc7834 2 жыл бұрын

it would have been nice if you tried showing Mac way also but its all good now. Terminal show database; don't work on Mac. Any one know how to run it?

@Jayu1122 2 жыл бұрын

At 11.23 I am not able to go ahead, username and password are not accepted .

@kanakarajubairy2187 Жыл бұрын

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near This what I am getting can anyone how to resolve this issue please help me 🙏

@HanjiMeinSwapnil 8 ай бұрын

Where is hr schema ? its not present by default? how to get it?

@shivarajkenganur5372 3 жыл бұрын

Sir now i know Oracle rdbms but now i started learning MySQL by through your videos is it helpful in my interview

@sdetpavan 3 жыл бұрын

good.

@shivarajkenganur5372 3 жыл бұрын

@@sdetpavan Thanks sir

@sreejx 4 жыл бұрын

hi sir we can use ,USE Databasename even in GUI and write query without using "."

@gundamfan777 10 ай бұрын

I couldnt figure out how to set up the server for the life of me and I used Chatgtp to assist. :( I hope I can follow along without setting up a server.

@prithvinandan 11 ай бұрын

Sir mere me ye result grid kyu nahi aata pls

@user-gz2nt8rz4w 11 ай бұрын

hi sir i dont have an option "developer default" it is showing options like sever only , client only ,full and custom. what should i do sir ? thank you in advance

@astuteacerbic 2 ай бұрын

Pavan sir, same problem happening with me, If I go with the full installation I am not getting admin password setting options later,, what needs to be done here. Kindly help me

@nababshaikh175 Жыл бұрын

Sir I'm facing error 1064 how to solve?

@srikanthkore8694 Жыл бұрын

sql software is not able to configure

@proudindo383 6 ай бұрын

Can anyone share the link.. I am getting prblm to install 😢

@gollaakhila1246 Ай бұрын

Hi sir I forget my password can you tell how to change that..

@harishk8266 2 ай бұрын

i cannot download mysql workbench but downloaded mysql commandline

@Arvindkumar-zm7gc 3 жыл бұрын

Those who are getting error for "server" please select MySQL server and execute it , it will install the required modules

@ShivamSingh-iz5gj 2 жыл бұрын

where do we get the option you suggested can you please help

@harishchittari9498 Ай бұрын

How to install My SQL server in MAC BOOK AIR

@vishwaspathak3635 4 жыл бұрын

Hi i am not able to install mysql successfully can anyone help me out i am getting "NO COMPATIBLE SERVERS WERE FOUND" this problem. Help me out so that will be able to go ahead and learn from these beautiful videos. @SDET

@Ammu5207 2 жыл бұрын

I'm also got this error, how u resolved this error

@nishantsharma6435 2 жыл бұрын

It's almost take 30 minutes in my laptop 😅

@roopapatil2815 5 жыл бұрын

Hi sir.. I. Getting This application requires. Net Framework 4.5.2. Please install the. Net framework then run this installer again.. Please help me sir 🙏

@sdetpavan 5 жыл бұрын

Install .net framework as pre-requisite, then start MySQL installer.

@eachoneteachone2181 Жыл бұрын

Net.frame is also not installing sir error getting error message

@umamaheshreddy743 Жыл бұрын

hai i forgetten password how to recover it please tell

@catalinalexandruschiopu2738 Жыл бұрын

Hello, i think i missed something, at 10:21, after I press Execute, the option Creating user accounts dosen't validate, gives a Red Mark and i can not proceed further.

@gmanochithra6409 5 ай бұрын

sir i'm also facing same error r u resolve this issue sir

@gmanochithra6409 5 ай бұрын

sir i'm also facing same error r u resolve this issue sir

@rahulwadaskar4548 6 ай бұрын

can you give me your HR file inside which you created table

@user-cn6ds1se1y Ай бұрын

did you get it bro

@anup4009 2 жыл бұрын

is anyone also facing the "Location" table missing from "world" schemas in MySQL workbench? Please help me, I have only 3 tables "city, country and countrylanguage" that's it...

@jignashasakhiya Жыл бұрын

me too. have you found any solution for this?

@anup4009 Жыл бұрын

@@jignashasakhiya no, I didn't find any

@cqajagsaw 4 жыл бұрын

how do I import HR schema?

@wudaliabhinavprasad 4 жыл бұрын

Did you get it to work ?. I downloaded the HR Schema but can't get to work/open

@wudaliabhinavprasad 4 жыл бұрын

Go to Administration Tab - Select Data Import/Restore - Import from self contained file- select the file- Click new beside default target scheme- Type Hr- Go to import progress-Click import @ right hand corner bottom-go to schema and click refresh button- you will have a new Hr option with the database Thanks,

@samshah4767 2 жыл бұрын

I'm unable to download the hr schema from the link. Can you guide me ?

@dillibabuvarthala1909 2 жыл бұрын

@@samshah4767 sir please share hr schema if you have

@dillibabuvarthala1909 2 жыл бұрын

@@wudaliabhinavprasad sir please share the hr schema