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
install problem & data base mysql error
re:
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
----> 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
- zoneminder
- Site Admin
- Posts: 5215
- Joined: Wed Jul 09, 2003 2:07 pm
- Location: Bristol, UK
- Contact: