[horde] Set Privileges between Horde and MySQL

Vilius Sumskas/LNK vilius at lnk.lt
Thu Aug 21 13:30:07 UTC 2014


> That's clear. But I can't find any documentation how to do so.
> All I can find is:
> CREATE DATABASE horde;
> GRANT ALL PRIVILEGES ON horde.* TO 'horde'@'localhost' IDENTIFIED BY
> 'horde';
> FLUSH PRIVILEGES;
> I do so as mysql root-user.
> 
> In the mysql table "db" there is now the following:
> | Host      | Db      | User  | Select_priv | Insert_priv | Update_priv
> | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv |
> Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv |
> Create_view_priv | Show_view_priv | Create_routine_priv |
> Alter_routine_priv | Execute_priv | Event_priv | Trigger_priv |
> | localhost | horde   | horde | Y           | Y           | Y 
> | Y           | Y           | Y         | N          | Y               |
> Y          | Y          | Y                     | Y                |
> Y                | Y              | Y                   |
> Y                  | Y            | Y          | Y            |
> 
> In the table "user" there is set as host "localhost", as user "horde"
> and the password.

If your Horde lives under the same server as MySQL then "localhost" should 
be enough. If not, then you have specify Horde's hostname or IP address 
from which you are connecting to MySQL server.

-- 
   Vilius


More information about the horde mailing list