Overview:
- In MySQL, the SQL statement DROP USER deletes an user from the database management system.
- The DROP USER will not delete other database objects like databases, tables, stored procedures that were created by the deleted user.
- The example Python program, prints the list of users present in the MySQL server. It deletes one of the users and prints the list again. The list does not include the deleted user.
Example:
|
# ----- Example Python program to delete an user from MySQL server ----- import pymysql
# Connection parameters and access credentials ip = "127.0.0.1" usr = "root" passwd = "" charset = "utf8mb4" curtype = pymysql.cursors.DictCursor
# Print the list of users def PrintUserList(sqlCursor): sql_GetUser = "select host, user from mysql.user;" sqlCursor.execute(sql_GetUser)
users= sqlCursor.fetchall()
print("User List:") for userName in users: print(userName)
# Delete an User def DeleteUser(sqlCursor, userName): sql_DeleteUser = "DROP USER %s;"%userName sqlCursor.execute(sql_DeleteUser)
# Connect to MySQLServer sqlCon = pymysql.connect(host=ip, user=usr, password=passwd, charset=charset, cursorclass=curtype) cursor = sqlCon.cursor()
# Print the list of MySQL users - Before deleting print("List of users - Before deletion of an user:") PrintUserList(cursor)
# Delete an User userName = "'analytics'@'localhost'" print("Deleting an User…") DeleteUser(cursor, userName)
print("List of users - After deletion of an user:") # Print the list of MySQL users - After deleting PrintUserList(cursor) |
Output:
|
List of users - Before deletion of an user: User List: … …
{'host': 'localhost', 'user': 'analytics'} {'host': 'localhost', 'user': 'testbed'} … … Deleting an User… List of users - After deletion of an user: User List: … … {'host': 'localhost', 'user': 'testbed'} … … |