Python and MySQL - Creating our Database and Table

Thank you! You are awesome.

thank you, helped me alot

Subscribe🎉

Hi, I have a question. I have plans to do some apps to practice or show what I can do, this apps is about to inventory control, warehouse management and/or point of sale. Before I did some similar but in small scale with excel or in FileMaker, but now I want to do it something more seriously and if is posible multiplatform, i'm working on Mac same as you, but I'm not sure if do it this as a webapp with Java and sql or do it with python or any other programing language as native app in the different platforms.

What did you recommend to me? work as webapp or native apps and in what programing language?

DatabaseError: 1007 (HY000): Can't create database 'mydata'; database exists. What does that mean, how to solve

Nice way to teach

It didn't work for me 😢

Good job 👍

Perfect explanation 👌

Thanks brother ❤️

You teach Java

WHY IT DOESN'T WORKS WITH IDLE

Very nice! Mysql community version is free, right? Do you know how much space can I use?

Another question, I saw that youre importing your connection from a local server, is it really on the cloud, how do I do to store my data/retrieve it through a cloud connection without being "local" in python through mysql?

The tutorial was good but you had some terminology issues which might be confusing to beginners.

I dont have the color scheme for mysql, how did u install the color scheme? How did u manage to get the language injection for mysql?

This was going wrogn for me because the mysql dialect was not selected. I just had to change that on "Settings" and everything worked fine. Thanks for the video!!

Wonderful this ;)

Excellent

mysql.connector.errors.DatabaseError: 3680 (HY000): Failed to create schema directory 'NEWBANK' (errno: 2 - No such file or directory)
PLEASE HELP !!!!

Hi There, first off great help! Thx! Secondly, I'm new to this and when I type the double quotations like ("CREATE DATABASE testdb") your Pycharm turns the line back into functions, but mine stays a string. It works, but a little help from the program would be awesome. How can i fix this? Anyone?

Thanks! It helped a lot! :)

DatabaseError: Can't create database 'testdb'; database exists ... HELP

hi, im getting this error when trying to print mydb:
"Authentication plugin '{0}' is not supported".format(plugin_name))
mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
can you help?

Does anyone know how he gets the text between double quotes to change colour, when he types CREATE for example. I'm using pycharm on Windows and everything between double quotes is the same colour for me.

This is exactly what I was looking for. Thank you so much.

Ohh this guy is good, this guy is very good

This working perfectly!!!!! Can't thank you enough for this......🥰🤗

this video and previous one also helpful.... looking for the next one
thanks

how can you have just 38k views with such and amazing course?... i'm going to tell my friends to come!. Thank you for sharing your knowledge, btw.

Super helpful video thank you! (only thing I would say is please stop saying GUYS so much lol)

what if someone is using your program and they don't have mysql on their computer?

does it work python idle

wth how is this guy so so so so so much better than any other sql tutorial on internet could have saved 3 hours if i found him first

How to display table?? Using select ??

Exactly what i needed, and it's on point.

Thanks so much

Perfect explanation and execution. Many thanks.

mysql.connector.errors.ProgrammingError: 1044 (42000): Access denied for user ''@'localhost' to database 'testdb'


i got this error

already subscribed, man ^ ^

can you explain a few benefits of using mysql via python? thx!

Does your course on python cover the mysql data also? Also trying to connect to mysql database on my hosting service is there a special connector to do this with. I need to add the port and this to the connection string SslMode="none".

You should be having more subscribes, good presentation!

Great so far, a little tricky at first - which is ok - a bit of a jiggle in workbench and pycharm but brill to get something like this actually working.

good job man. I am following you in all sites. It's really great series. Please continue.

I'am enjoying this series. :)