RE: Just installed Redmine - only thing showing is a inde... ยป output-mysql.txt
| 1 |
|
|---|---|
| 2 |
mysql> SELECT Host, User FROM mysql.user WHERE user='redmine'; |
| 3 |
+-----------+---------+ |
| 4 |
| Host | User | |
| 5 |
+-----------+---------+ |
| 6 |
| localhost | redmine | |
| 7 |
+-----------+---------+ |
| 8 |
1 row in set (0.00 sec) |
| 9 |
|
| 10 |
mysql> show grants for redmine@localhost; |
| 11 |
+----------------------------------------------------------------------------------------------------------------+ |
| 12 |
| Grants for redmine@localhost | |
| 13 |
+----------------------------------------------------------------------------------------------------------------+ |
| 14 |
| GRANT USAGE ON *.* TO 'redmine'@'localhost' IDENTIFIED BY PASSWORD '*F1932B6BFE93D66B43F9A3EB5ECF8A5C90C32053' | |
| 15 |
| GRANT ALL PRIVILEGES ON `redmine`.* TO 'redmine'@'localhost' | |
| 16 |
+----------------------------------------------------------------------------------------------------------------+ |
| 17 |
2 rows in set (0.00 sec) |
| 18 |
|