Python mysql show databases

import mysql.connector
conn = mysql.connector.connect (user='user', password='password',
                               host='server_address',buffered=True)
cursor = conn.cursor()
databases = ("show databases")
cursor.execute(databases)
for (databases) in cursor:
     print databases[0]

Source: stackoverflow.com

Similar codes

9 votes321 views4 answers
Add primary key to existing table sql
SQL
2 votes348 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote337 views1 answer
Dump db only triggers mysql
SQL
1 vote343 views1 answer
Get all db sizes in mysql server
SQL
0 vote356 views1 answer
Savepoint mysql script
SQL
1 vote317 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
10 votes315 views1 answer
How to import database in mysql by cmd
SQL
3 votes315 views3 answers
Mysql select table names
SQL
0 vote352 views1 answer
Postgresql create table many-to-many
SQL
3 votes316 views1 answer
Difference sql vs mysql
SQL