Hi,
> > 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)
According to your privileges tables, you have only access to database
midgard, so you would need to do:
mysql -umidgard midgard
At least the table you sent makes me believe you set the password for
user midgard to be empty. I could not advise to set and empty password,
and if you insist, you should change this also in the apache
configuration.
My suggestion:
$ mysql -uroot -p mysql
password: ******* (whatever is the case for you
% update user set Password=('YourPassOfChoice') where User='midgard';
% FLUSH PRIVILEGES;
% quit
And in your httpd.conf change:
MidgardDatabase midgard midgard midgard
into:
MidgardDatabase midgard midgard YourPassOfChoice
> 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 | midgard | | Y | Y |
> Y | Y | Y | Y | Y |
> Y | Y | Y | Y | Y
> | Y | Y |
> | d.tracker | midgard | | Y | Y |
> 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)
Good luck,
Armand.
--
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]
