Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import mysql.connector
- from mysql.connector import Error
- def create_connection(host_name, user_name, user_password):
- connection = None
- try:
- connection = mysql.connector.connect(
- host=host_name,
- user=user_name,
- passwd=user_password
- )
- print("Connection to MySQL DB successful")
- except Error as e:
- print(f"The error '{e}' occurred")
- return connection
- connection = create_connection("localhost", "root", "")
- def execute_read_query(connection, query):
- cursor = connection.cursor()
- result = None
- try:
- cursor.execute(query)
- result = cursor.fetchall()
- return result
- except Error as e:
- print(f"The error '{e}' occurred")
- select_users = "SELECT * FROM users"
- users = execute_read_query(connection, select_users)
- for user in users:
- print(user)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement