How to display list of databases present on your localhost server

Question

mysqli_query("SHOW DATABASES"); – Bilal Ahmed Feb 02 '18 at 06:14 — Bilal Ahmed, Feb 02 '18 at 06:14

score 0 · Answer 1 · answered Feb 02 '18 at 06:21

0

Try following query:

SELECT schema_name FROM information_schema.schemata

answered Feb 02 '18 at 06:21

Gajjar Parth

score 0 · Accepted Answer · answered Feb 02 '18 at 06:26

0

I hope it can help you

answered Feb 02 '18 at 06:26

ThangLe

score 0 · Answer 3 · answered Feb 02 '18 at 07:18

0

show all database just use SHOW DATABASES

answered Feb 02 '18 at 07:18

pythonic

3 Answers3