> If you specify no password, and no MidgardPassword directive comes
> before it, any missing parameters will default to the built-in
> defaults (all 'midgard'). So
> MidgardDatabase midgard root
> is actually the same as
> MidgardDatabase midgard root midgard
> If you want to test without at password, do
> MidgardDatabase midgard root ""
>
> See if you can access the midgard database as
> $ mysql -u midgard -pmidgard midgard
> If that's OK, set
> MidgardDatabase midgard midgard midgard
Got it, but
I am stuck here and it must be a simple mysql permission thing.
even though
$ mysql -unobody
$ mysql -uroot
work fine,
$ mysql -umidgard
will not work, and gives me:
ERROR 1045: Access denied for user: 'midgard@localhost' (Using password:
NO)
select * of mysql.user shows;
+-----------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| Host | User | Password | Select_priv | Insert_priv |
Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv |
Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv
| Index_priv | Alter_priv |
+-----------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
| localhost | root | | Y | Y |
Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y |
| d.tracker | root | | Y | Y |
Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y |
| d.tracker | nobody | | N | N |
N | N | N | N | N |
N | N | N | N | N
| N | N |
| d.tracker | | | N | N |
N | N | N | N | N |
N | N | N | N | N
| N | N |
| localhost | web | 686029a02981ef9c | Y | Y |
Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y |
| localhost | midgard | | Y | Y |
Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y |
| d.tracker | midgard | | Y | Y |
Y | Y | Y | Y | Y |
Y | Y | Y | Y | Y
| Y | Y |
| localhost | nobody | | N | N |
N | N | N | N | N |
N | N | N | N | N
| N | N |
+-----------+---------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+
8 rows in set (0.18 sec)
and select * from host shows;
+-----------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| Host | Db | Select_priv | Insert_priv | Update_priv |
Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv |
Index_priv | Alter_priv |
+-----------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
| localhost | midgard | Y | Y | Y |
Y | Y | Y | Y | Y |
Y | Y |
| d.tracker | midgard | Y | Y | Y |
Y | Y | Y | Y | Y |
Y | Y |
+-----------+---------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+
2 rows in set (0.03 sec)
what could I be missing?
--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org
To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]
