Connect Mysql Database using Python Tutorial | MySQL server and Workbench 2024

Поділитися
Вставка
  • Опубліковано 10 вер 2024
  • How to connect mysql server and workbench database using python is shown
    #mysql #pythontutorial #python

КОМЕНТАРІ • 53

  • @rimachakraborty1458
    @rimachakraborty1458 13 днів тому

    Really Helpful , thank You so much

  • @rishiksahu2007
    @rishiksahu2007 2 місяці тому +1

    It's still showing the error👇🏻
    Traceback (most recent call last):
    File "C:/Users/Rishik/Documents/Python Programs/Python connectivity.py", line 1, in
    import mysql.connector
    ModuleNotFoundError: No module named 'mysql'

  • @Aravinthravi-mc9nh
    @Aravinthravi-mc9nh 3 місяці тому +2

    (Pip is not recognized as an internal or external command ,operable program or batch file.). I got the error how to solve this error in command prompt

    • @unitedtoptech6288
      @unitedtoptech6288  3 місяці тому

      You did not add the python scripts path in environment variable or check the checkbox when installing python

  • @dilansarith2188
    @dilansarith2188 Місяць тому

    super explanation. Thank you very much

  • @user-jb9ed6pv8e
    @user-jb9ed6pv8e Місяць тому

    Sir, I'm using Windows 10 32-bit. I tried to install mySQL 5.7, like the video in 04:06 it only showed MySQL Server and Documentation, I'm not getting Applications. Do you perhaps know why did it happened?

    • @unitedtoptech6288
      @unitedtoptech6288  Місяць тому

      Why do you want to install the older version?

    • @user-jb9ed6pv8e
      @user-jb9ed6pv8e Місяць тому

      @@unitedtoptech6288 because the newer version (MySQL 8. ) is not working on Windows 32-bit, Sir

    • @unitedtoptech6288
      @unitedtoptech6288  Місяць тому

      Got it sir, can you try a bit newer version? 5.7 is too low

  • @anbarasisrihari3088
    @anbarasisrihari3088 20 днів тому

    TQ soo much

  • @Just_A_Tech.._
    @Just_A_Tech.._ 8 місяців тому

    Good work, thanks.🤝👍

  • @Kixishiva
    @Kixishiva 2 місяці тому

    This is not working for me what should I do??
    'mysql' is not recognized as an internal or external command,
    operable program or batch file.

    • @unitedtoptech6288
      @unitedtoptech6288  Місяць тому

      you need to add mysql server bin path in environment variable

  • @MOHAMEDFOWAZMMSEC
    @MOHAMEDFOWAZMMSEC 2 місяці тому +1

    at 17.00 im not getting the dropdown option in tables

    • @unitedtoptech6288
      @unitedtoptech6288  2 місяці тому +1

      To the left in the same tab you will be having schemas, click that your database and table will be visible

    • @MOHAMEDFOWAZMMSEC
      @MOHAMEDFOWAZMMSEC 2 місяці тому

      @@unitedtoptech6288 yes sir I got it, I have a problem with my python connection with my SQL with SQL alchemy error to do hotel food order system, could u help

    • @unitedtoptech6288
      @unitedtoptech6288  2 місяці тому

      Can you paste the whole error?

    • @MOHAMEDFOWAZMMSEC
      @MOHAMEDFOWAZMMSEC 2 місяці тому

      I got it sir, tnx

    • @unitedtoptech6288
      @unitedtoptech6288  2 місяці тому +1

      Cool sir

  • @Harshika__C
    @Harshika__C 2 місяці тому

    Sir when I am visiting environment system variable everything is looking same as your computer but when I am clicking on edit path the same screen or the option of adding a new path is not appearing. Instead there is option for editing just one path,the one I clicked
    Please help sir i need to do a school project

    • @unitedtoptech6288
      @unitedtoptech6288  2 місяці тому

      Can you try in user variable path? if system is not working

  • @mahtha-e3q
    @mahtha-e3q 2 місяці тому

    when I go to service to set it up as automatic, MYSQL80 doesn't show up.

  • @sudhirdutt1
    @sudhirdutt1 2 місяці тому

    sir the command prompt is not showing the database"newname" in it but it is showing all the other things. What should I do?

    • @sudhirdutt1
      @sudhirdutt1 2 місяці тому

      and when I am running it on python it is showing this error:
      ModuleNotFoundError: No module named 'mysql.connector'; 'mysql' is not a package

    • @unitedtoptech6288
      @unitedtoptech6288  2 місяці тому

      Command prompt? at what timestamp do you face this?

    • @sudhirdutt1
      @sudhirdutt1 2 місяці тому

      @@unitedtoptech6288 13:10

    • @sudhirdutt1
      @sudhirdutt1 2 місяці тому

      at 13:10

    • @unitedtoptech6288
      @unitedtoptech6288  2 місяці тому

      Did you pip install the packages?

  • @kennethdarby899
    @kennethdarby899 14 днів тому

    Great video...I typed the mysql query the same way you did but I am getting programming error: 1064 (42000)

    • @unitedtoptech6288
      @unitedtoptech6288  14 днів тому

      it says some issue with syntax, can you pls check?

    • @kennethdarby899
      @kennethdarby899 14 днів тому

      @@unitedtoptech6288 yes, I was missing a comma. Thank you for replying. I will subscribe

    • @unitedtoptech6288
      @unitedtoptech6288  14 днів тому

      Most welcome!!

  • @user-ct4qy6lx4j
    @user-ct4qy6lx4j Місяць тому

    Sir for me there was folder named bin was present help pls

  • @lekhashri3558
    @lekhashri3558 6 місяців тому

    Am doing my mini project using vscodes but i am working with only frontend which is html,js,css.. but i need database for that.. and now with the help of ur video i connected MySQL with python but now how can i connect this with my vscode?

    • @unitedtoptech6288
      @unitedtoptech6288  6 місяців тому

      So you want a way to get data from your frontend which I assume has input boxes in the UI and they need to be then stored in mysql DB with the help of python?

    • @MOHAMEDFOWAZMMSEC
      @MOHAMEDFOWAZMMSEC 2 місяці тому

      @@unitedtoptech6288 yes sir it showed, now i m doing a hotel food order project with python and my SQL in workbench where I'm getting SQL alchemy error where I installed it and tried many ways where it is not working, could you help

    • @unitedtoptech6288
      @unitedtoptech6288  2 місяці тому +1

      Can you please paste the whole error sir?

  • @elitezzeisa1645
    @elitezzeisa1645 Місяць тому

    I LOVE YOUUUU

  • @JSamuel08
    @JSamuel08 2 місяці тому

    thank you SO MUCH!

  • @MuhammadIbrahim-nb7ie
    @MuhammadIbrahim-nb7ie 8 місяців тому

    can you please make a video about activity diagram and sequences diagram for expense tracking app ?