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

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024
  • 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/gdsf...
    Cucumber BDD Framework
    ***************************
    ► bit.ly/3F7d69r
    Protractor with Javascript
    ***************************
    ► urlis.net/4udd...
    ####################################
    RUclips 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

Комментарии • 117

  • @user-ci5ys9tl7u
    @user-ci5ys9tl7u 5 месяцев назад +13

    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.

  • @revathysathishkumar8035
    @revathysathishkumar8035 6 месяцев назад +5

    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.

  • @nikeshkumar-gl1fv
    @nikeshkumar-gl1fv 3 года назад +30

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

    • @sdetpavan
      @sdetpavan  3 года назад +1

      Thanks and welcome

  • @bhavanamtiwari9540
    @bhavanamtiwari9540 2 года назад +8

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

  • @Sliceoflife.Farhaz
    @Sliceoflife.Farhaz 9 месяцев назад +1

    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.

  • @123afgh
    @123afgh Год назад +1

    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

  • @sarheenpamidi7061
    @sarheenpamidi7061 Год назад +2

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

  • @Upsaracollections
    @Upsaracollections 9 месяцев назад +3

    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
      @sdetpavan  9 месяцев назад

      It's my pleasure

  • @aditirathore7421
    @aditirathore7421 2 года назад +2

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

  • @AnjaliGupta-ig5jy
    @AnjaliGupta-ig5jy Год назад

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

  • @andreipascu741
    @andreipascu741 3 года назад +5

    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.

  • @shrevardhniumesh1170
    @shrevardhniumesh1170 3 года назад +2

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

    • @sdetpavan
      @sdetpavan  Год назад

      Welcome

    • @jignashasakhiya
      @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.

  • @bindumadala7517
    @bindumadala7517 4 года назад +5

    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

  • @chittelikarrthika5166
    @chittelikarrthika5166 Год назад +1

    Sir you are best ......Saviour

  • @KrishanKumar-jo7ss
    @KrishanKumar-jo7ss Год назад +1

    Excellent lecture ❤

  • @basanagoudabiradar8669
    @basanagoudabiradar8669 3 месяца назад +1

    Thank you so much sir 👍

  • @shivarajkenganur5372
    @shivarajkenganur5372 3 года назад +2

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

  • @bjaggu
    @bjaggu 3 года назад +5

    Where can i get Hr DataBase? to practice

  • @moondust8053
    @moondust8053 Год назад +1

    Thank you sir.

  • @eshwar1510
    @eshwar1510 Год назад +1

    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

  • @mayurivmulje1407
    @mayurivmulje1407 Год назад +1

    You made it very easy :)

  • @Eng-Mohamed-Ahmed
    @Eng-Mohamed-Ahmed 2 года назад +1

    good explanations thanks.

  • @user-gz2nt8rz4w
    @user-gz2nt8rz4w Год назад +2

    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
      @astuteacerbic 3 месяца назад

      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

  • @ramyabts74
    @ramyabts74 3 года назад +2

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

  • @muhammadjunaidmajeed1211
    @muhammadjunaidmajeed1211 3 года назад +1

    Excellent!

  • @dillibabuvarthala1909
    @dillibabuvarthala1909 2 года назад

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

  • @venkatsaierram8079
    @venkatsaierram8079 3 года назад +1

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

  • @kaspasudarshan2211
    @kaspasudarshan2211 19 дней назад

    Sir
    Your video is available on udemy ?

  • @saranyachandrabos3541
    @saranyachandrabos3541 2 года назад +1

    Thank you....

  • @vishwaspathak3635
    @vishwaspathak3635 4 года назад +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
      @Ammu5207 2 года назад +1

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

  • @satrunball4454
    @satrunball4454 Год назад

    Hi Pavan Sir
    These videos are useful for manual testing ?

  • @vivekvicky748
    @vivekvicky748 2 года назад +1

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

  • @saisurya2213
    @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

  • @Indu2ber
    @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.

  • @bhavanithadi1072
    @bhavanithadi1072 3 года назад +1

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

  • @Arvindkumar-zm7gc
    @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
      @ShivamSingh-iz5gj 3 года назад

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

  • @Imana23
    @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.

  • @Ashish-kn9xb
    @Ashish-kn9xb 2 года назад +1

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

  • @examtakbypankajkushwaha953
    @examtakbypankajkushwaha953 2 года назад

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

  • @elladatofigli8120
    @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.

  • @nishantsharma6435
    @nishantsharma6435 2 года назад +1

    It's almost take 30 minutes in my laptop 😅

  • @DMK96180
    @DMK96180 4 месяца назад

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

  • @cherrybloom5162
    @cherrybloom5162 4 года назад

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

  • @gundamfan777
    @gundamfan777 11 месяцев назад

    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.

  • @shubhampandey559
    @shubhampandey559 7 месяцев назад

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

  • @omkarmanjare385
    @omkarmanjare385 11 месяцев назад

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

  • @eachoneteachone2181
    @eachoneteachone2181 Год назад

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

  • @aninditasamanta2748
    @aninditasamanta2748 8 месяцев назад

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

  • @buzz5minute217
    @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.

  • @asharaju4169
    @asharaju4169 10 месяцев назад

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

  • @tejastoley6714
    @tejastoley6714 2 года назад

    which credentials should enter for connecting the server?

  • @HanjiMeinSwapnil
    @HanjiMeinSwapnil 9 месяцев назад

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

  • @sreejx
    @sreejx 4 года назад +1

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

  • @zayb007
    @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

  • @roopapatil2815
    @roopapatil2815 5 лет назад +1

    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
      @sdetpavan  5 лет назад

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

    • @eachoneteachone2181
      @eachoneteachone2181 Год назад

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

  • @harishk8266
    @harishk8266 4 месяца назад

    i cannot download mysql workbench but downloaded mysql commandline

  • @prithvinandan
    @prithvinandan Год назад

    Sir mere me ye result grid kyu nahi aata pls

  • @meenakshi3799
    @meenakshi3799 2 года назад

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

  • @kanakarajubairy2187
    @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 🙏

  • @catalinalexandruschiopu2738
    @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
      @gmanochithra6409 6 месяцев назад

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

    • @gmanochithra6409
      @gmanochithra6409 6 месяцев назад

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

  • @gollaakhila1246
    @gollaakhila1246 2 месяца назад

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

  • @oc7834
    @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
    @Jayu1122 2 года назад

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

  • @srikanthkore8694
    @srikanthkore8694 Год назад

    sql software is not able to configure

  • @rahulwadaskar4548
    @rahulwadaskar4548 7 месяцев назад +1

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

  • @harishchittari9498
    @harishchittari9498 3 месяца назад

    How to install My SQL server in MAC BOOK AIR

  • @proudindo383
    @proudindo383 8 месяцев назад

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

  • @shameedboom6139
    @shameedboom6139 2 года назад

    how can i get this on a mac

  • @nababshaikh175
    @nababshaikh175 Год назад

    Sir I'm facing error 1064 how to solve?

  • @cqajagsaw
    @cqajagsaw 5 лет назад +1

    how do I import HR schema?

    • @wudaliabhinavprasad
      @wudaliabhinavprasad 4 года назад

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

    • @wudaliabhinavprasad
      @wudaliabhinavprasad 4 года назад +2

      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
      @samshah4767 2 года назад

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

    • @dillibabuvarthala1909
      @dillibabuvarthala1909 2 года назад

      @@samshah4767 sir please share hr schema if you have

    • @dillibabuvarthala1909
      @dillibabuvarthala1909 2 года назад

      @@wudaliabhinavprasad sir please share the hr schema

  • @umamaheshreddy743
    @umamaheshreddy743 Год назад

    hai i forgetten password how to recover it please tell

  • @madeshg587
    @madeshg587 2 года назад +1

    Sir plz help me.i m getting no compatible serevers were found

    • @ashikiqbal7359
      @ashikiqbal7359 2 года назад

      Please Select 'Full' instead of "Developer Default" on the "Choosing a setup type" window

    • @efeehianuoka7435
      @efeehianuoka7435 2 года назад

      @@ashikiqbal7359 did not work

  • @anup4009
    @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
      @jignashasakhiya Год назад +1

      me too. have you found any solution for this?

    • @anup4009
      @anup4009 Год назад

      @@jignashasakhiya no, I didn't find any

  • @jyothireddykonduru
    @jyothireddykonduru 3 года назад

    I forgot MySQL 8.0 Command Line Client password? how can reset pavan sir? any one can help?

  • @reshmapatil7667
    @reshmapatil7667 Год назад +1

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

  • @muhammadanees7687
    @muhammadanees7687 Год назад

    I am installing mysql but mysql workbecnh option appear whil what should I do?

    • @sandeepsahu8743
      @sandeepsahu8743 10 месяцев назад

      Same issue! Still trying to find out why? once get it, will update you.