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

-1 vote128 views1 answer
How to format tables in sqlplus
SQL
6 votes172 views2 answers
Subtr Oracle ?
SQL
2 votes204 views2 answers
How to DROP a table in mysql
SQL
9 votes160 views1 answer
Alter table column change data type to text mysql
SQL
0 vote153 views1 answer
Running percentage of total postgres
SQL
24 votes132 views4 answers
How to add column sql
SQL
1 vote146 views2 answers
Backup table mssql
SQL
21 votes106 views7 answers
Table drop if exist sql server
SQL
0 vote136 views1 answer
Foreign key type uniqu mysql
SQL
0 vote154 views1 answer
Get enginge db mysql
SQL