World's Best AI Learning Platform with profoundly Demanding Certification Programs
Designed by IITians, only for AI Learners.
Designed by IITians, only for AI Learners.
New to InsideAIML? Create an account
Employer? Create an account
Download our e-book of Introduction To Python
4.5 (1,292 Ratings)
559 Learners
Vijay Parekh
a year ago
import mysql.connector as mysql
test= mysql.connect(
host="localhost",
user="username",
password="password"
)
print(test)
>python demo_mysql_connection.py
<mysql.connector.connection.MySQLConnection object ar 0x016645F0>
import mysql.connector as mysql
test= mysql.connect(
host="localhost",
user="username",
password="password"
)
mycursor = test.cursor()
mycursor.execute("CREATE DATABASE mydatabase")
import mysql.connector as mysql
test= mysql.connect(
host="localhost",
user="yourusername",
password="yourpassword"
)
mycursor = test.cursor()
mycursor.execute("SHOW DATABASES")
for x in mycursor:
print(x)
('information_scheme',)
('mydatabase',)
('performance_schema',)
('sys',)