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

2 votes181 views1 answer
Mysql change data type of column
SQL
0 vote123 views1 answer
Sql select rows with simlar names
SQL
0 vote179 views1 answer
Python sql last insertend
SQL
24 votes173 views4 answers
Postgres remove database
SQL
2 votes191 views1 answer
Install postgresql centos 5
SQL
0 vote136 views1 answer
Oracle list all stored procedures
SQL
0 vote166 views1 answer
Drop specific row postgresql
SQL
1 vote169 views1 answer
Pgsql sum switch case
SQL
0 vote177 views1 answer
Varchar format not case sensitive sql
SQL
0 vote190 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL