-
Notifications
You must be signed in to change notification settings - Fork 304
Expand file tree
/
Copy pathpython-connect-mysql.py
More file actions
57 lines (37 loc) · 1.22 KB
/
python-connect-mysql.py
File metadata and controls
57 lines (37 loc) · 1.22 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
#import mysql.connector
#conn = mysql.connector.connect(user='root', password='root', host='127.0.0.1', database='roytuts')
#print (conn)
#conn.close()
#from mysql.connector import (connection)
#conn = connection.MySQLConnection(user='root', password='root', host='127.0.0.1', database='roytuts')
#print (conn)
#conn.close()
#import mysql.connector
#from mysql.connector import errorcode
#try:
# conn = mysql.connector.connect(user='root', password='root', host='127.0.0.1', database='roytuts')
# print (conn)
#except mysql.connector.Error as err:
# if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
# print("Something is wrong with user name
4B1D
or password")
# elif err.errno == errorcode.ER_BAD_DB_ERROR:
# print("Database does not exist")
# else:
# print(err)
#else:
# conn.close()
#import mysql.connector
#config = {
# 'user': 'root',
# 'password': 'root',
# 'host': '127.0.0.1',
# 'database': 'roytuts',
# 'raise_on_warnings': True
#}
#conn = mysql.connector.connect(**config)
#print (conn)
#conn.close()
import mysql.connector
conn = mysql.connector.connect(user='root', password='root', host='127.0.0.1', database='roytuts', use_pure=True)
print (conn)
conn.close()