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

0 vote367 views1 answer
Current month transactions in mysql
SQL
12 votes315 views6 answers
How to install sqlite3 in python
SQL
0 vote288 views1 answer
Select in select sql
SQL
2 votes288 views1 answer
Add new column not null sql server
SQL
0 vote300 views1 answer
Rename constraint postgresql
SQL
0 vote233 views1 answer
Sqlalchemy filter relationship
SQL
2 votes308 views1 answer
Q operator in plsql
SQL
0 vote258 views1 answer
Mysql earlier than date
SQL
1 vote292 views1 answer
Pl sql ptint
SQL
27 votes296 views3 answers
Mysql show tables in database
SQL