mysql> select Host,User from user; +-----------+----------+ | Host | User | +-----------+----------+ | localhost | lightbox | | localhost | root | +-----------+----------+