[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