Using REVOKE in Python

As with GRANT, revoking privileges in Python just depends on forming the statement. As seen in this code, a revision of the earlier example, the REVOKE statement uses similar context to and all the same information as the GRANT statement:

#!/usr/bin/env python

import MySQLdb

host = 'localhost'
user = 'skipper'
passwd = 'secret'

mydb = MySQLdb.connect(host, user, passwd)
cursor = mydb.cursor()

try:
    mkuser = 'symphony'
    creation = "CREATE USER '%s'@'%s'" %(mkuser, host)
    results = cursor.execute(creation)
    print "User creation returned", results

    mkpass = 'n0n3wp4ss'
    setpass = "SET PASSWORD FOR '%s'@'%s' = PASSWORD('%s')" %(mkuser, host, mkpass)
    results = cursor.execute(setpass)
    print "Setting of password returned", results

    granting = "GRANT ALL ON *.* TO '%s'@'%s'" %(mkuser, host)
    results = cursor.execute(granting)
    print "Granting of privileges returned", results

    granting = "REVOKE ALL PRIVILEGES ON *.* FROM '%s'@'%s...