mysql> SELECT Host, User FROM mysql.user WHERE user='redmine'; +-----------+---------+ | Host | User | +-----------+---------+ | localhost | redmine | +-----------+---------+ 1 row in set (0.00 sec) mysql> show grants for redmine@localhost; +----------------------------------------------------------------------------------------------------------------+ | Grants for redmine@localhost | +----------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'redmine'@'localhost' IDENTIFIED BY PASSWORD '*F1932B6BFE93D66B43F9A3EB5ECF8A5C90C32053' | | GRANT ALL PRIVILEGES ON `redmine`.* TO 'redmine'@'localhost' | +----------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec)