DELIMITER $$
CREATE PROCEDURE showHostAndUser()
BEGIN 
    SELECT host,user FROM mysql.user;
END $$

DELIMITER ;

from mysql.connector import (connection)
cnx = connection.MySQLConnection(user='root',host='localhost',password='',database='')            
cur = cnx.cursor(True)


result = cur.callproc('showHostAndUser',[])

for result in cur.stored_results():
    rst = result.fetchall()
    print rst

print result.description

result = cur.callproc('showHostAndUser',[])

for result in cur.stored_results():
    rstData = result.fetchall()
    rstHead = result.description
    dictHead = {}
    for a in range (len(rstHead)):
        dictHead[rstHead[a][0]] = a
       
print rstData[0][dictHead['user']]