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 vote172 views1 answer
Lpad function in sql oracle
SQL
0 vote152 views2 answers
Sql select inside select
SQL
2 votes151 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote207 views1 answer
Tsql find procedure with name
SQL
0 vote184 views1 answer
Postgres row expiration
SQL
7 votes146 views1 answer
Sql server convert string to date
SQL
0 vote195 views1 answer
CONVERT time string into 12 hours in sql
SQL
1 vote148 views1 answer
Pv mysql import
SQL
0 vote169 views3 answers
How to modify alter user root@localhost identified with mysql_native_password by properly
SQL
2 votes167 views1 answer
Datetrunc
SQL