ZoneMinder Forums

i'm installing zm and a few error gets to me... can someone tell me what's wrong ?

grant select,insert,update,delete on <zm>.*to'<zm>'@localhost identified by '<mypass>'; grant select on <zm>* to '<zm>'@localhost identified by '<dummy>'@localhost indentified by '<mypass>'
<fax0> what is wrong in this line ?
<fax0> it s says ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near


Thanks

grant select,insert,update,delete on zm.* to user1@localhost identified by 'password1';

----> where zm is the name of your database, user1 is the privileged user that you have specified in zmconfig.pl query, and password1 is the password


grant select on zm.* to user2@localhost identified by 'password2';

----> where zm is the name of your database, user2 is the unprivileged user that you have specified in zmconfig.pl query, and password2 is the password

.... another problem can be that you must :

use mysql;

so that you use mysql database.
bye

Bascially the <> just mean replace with whatever values are correct for you.

Phil,