🔥Data Scientist Masters Program (Discount Code - YTBE15) - www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training?NHkRgWzTI&Comments&TH-cam 🔥IITK - Professional Certificate Course in Data Science (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-science?NHkRgWzTI&Comments&TH-cam 🔥Caltech Post Graduate Program in Data Science - www.simplilearn.com/post-graduate-program-data-science?NHkRgWzTI&Comments&TH-cam 🔥Brown University - Applied AI & Data Science - www.simplilearn.com/applied-ai-data-science-course?NHkRgWzTI&Comments&TH-cam
You could explain behind the scene mechanisms rather than reading everything you type like wat is not null, why were the arguments passed inside the connectors etc... still gave u a thumbs up for some of the new info I got from the video
If I know how to use SAS SQL to manipulate dataset, is there a way to run the SAS code through Python? (so that I can save some time by not learning Python data manipulation code)?
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
I fixed it. The problem was simple. I put all these functions that are meant to be run seperately in one .py file, and when I run it, All functions are run. When that happens, it goes over "connection=None" And that messes up the functions after it. Hence the Error NoneType attribute. Here's how I wrote the code for it to work in 1 .py file: import mysql.connector from mysql.connector import Error import pandas as pd ##################### SQL ####################### # MAKE SURE PASSWORD IS CORRECT ON LINE "connection = mysql.connector..... connection = None try: connection = mysql.connector.connect(host="localhost", user="root", passwd="root") except Error as err: print(f"Error: '{err}'") # Create 'studentdb.db' def create_database(connection, query): cursor = connection.cursor() try: cursor.execute(query) print("Database created successfully") except Error as err: print(f"Error: '{err}'") create_database_query = "Create database studentdb" create_database(connection, create_database_query) #=========================AFTER CONNECTION HAS BEEN MADE AND studentdb.db IS CREATED, The database can be used======================== #Connect to studentdb.db try: connection = mysql.connector.connect(host="localhost", user="root", passwd="852122", database="studentdb") print("MySQL database connection established") except Error as err: print(f"Error: '{err}'") cursor = connection.cursor() sql_queries = """ # PUT SQL QUERY HERE '"" cursor.execute(sql_queries)
"Hi, Please check this link to resolve the issue stackoverflow.com/questions/21944936/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y"
ITS NOT BLOODY WORKING -- "Authentication plugin '{0}' is not supported".format(plugin_name)) mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
🔥Data Scientist Masters Program (Discount Code - YTBE15) - www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training?NHkRgWzTI&Comments&TH-cam
🔥IITK - Professional Certificate Course in Data Science (India Only) - www.simplilearn.com/iitk-professional-certificate-course-data-science?NHkRgWzTI&Comments&TH-cam
🔥Caltech Post Graduate Program in Data Science - www.simplilearn.com/post-graduate-program-data-science?NHkRgWzTI&Comments&TH-cam
🔥Brown University - Applied AI & Data Science - www.simplilearn.com/applied-ai-data-science-course?NHkRgWzTI&Comments&TH-cam
You could explain behind the scene mechanisms rather than reading everything you type like wat is not null, why were the arguments passed inside the connectors etc... still gave u a thumbs up for some of the new info I got from the video
Thank you so much for giving fulfilled information about MySQL Using Python
Thanks Again....
Happy to help
how to connect the sql workbench and jupyter note book
Thanks for the information
Hope you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!
If I know how to use SAS SQL to manipulate dataset, is there a way to run the SAS code through Python? (so that I can save some time by not learning Python data manipulation code)?
how to write a connection for SQL and i have fixed my sql on window Authentication . Please guide me to write a code to connect my SQL with Jupyter
Error: 'Authentication plugin 'caching_sha2_password' is not supported '
I'm getting this error at @7:54
Hello there
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
first again? also i like python
Yes you are!
No way...
I'm the one yeah...
Not you...
can u provide source code page?
12:45 when I run it I get this:
cursor = connection.cursor()
AttributeError: 'NoneType' object has no attribute 'cursor'
I fixed it. The problem was simple. I put all these functions that are meant to be run seperately in one .py file, and when I run it, All functions are run. When that happens, it goes over "connection=None" And that messes up the functions after it. Hence the Error NoneType attribute.
Here's how I wrote the code for it to work in 1 .py file:
import mysql.connector
from mysql.connector import Error
import pandas as pd
##################### SQL #######################
# MAKE SURE PASSWORD IS CORRECT ON LINE "connection = mysql.connector.....
connection = None
try:
connection = mysql.connector.connect(host="localhost", user="root", passwd="root")
except Error as err:
print(f"Error: '{err}'")
# Create 'studentdb.db'
def create_database(connection, query):
cursor = connection.cursor()
try:
cursor.execute(query)
print("Database created successfully")
except Error as err:
print(f"Error: '{err}'")
create_database_query = "Create database studentdb"
create_database(connection, create_database_query)
#=========================AFTER CONNECTION HAS BEEN MADE AND studentdb.db IS CREATED, The database can be used========================
#Connect to studentdb.db
try:
connection = mysql.connector.connect(host="localhost", user="root", passwd="852122", database="studentdb")
print("MySQL database connection established")
except Error as err:
print(f"Error: '{err}'")
cursor = connection.cursor()
sql_queries = """
# PUT SQL QUERY HERE
'""
cursor.execute(sql_queries)
On minutes 7:57 i got this error message ~ Error: '1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)' ~
"Hi,
Please check this link to resolve the issue stackoverflow.com/questions/21944936/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-y"
With all due respect, your typing is really irritating to follow, almost no word is written in one chance . But the video is good.
Thank you for bringing this to our attention. We’re sorry you had a bad experience. We’ll strive to do better
ITS NOT BLOODY WORKING -- "Authentication plugin '{0}' is not supported".format(plugin_name))
mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported