install problem & data base mysql error

Support and queries relating to all previous versions of ZoneMinder
Locked
fax0
Posts: 1
Joined: Thu May 27, 2004 11:53 am

install problem & data base mysql error

Post by fax0 »

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
tolmino
Posts: 5
Joined: Sat May 22, 2004 6:48 pm

re:

Post by tolmino »

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
User avatar
zoneminder
Site Admin
Posts: 5215
Joined: Wed Jul 09, 2003 2:07 pm
Location: Bristol, UK
Contact:

Post by zoneminder »

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

Phil,
Locked