Try this:
grant all on events.* to 'zenoss'@'localhost' identified by
'$MYSQLPASS';
grant super, file on *.* to 'zenoss'@'localhost';
flush privileges;
-Eric
Joel Mandapat wrote:
is it possible to use another mysql user aside from root for
installing zenoss?
i've tried creating a different user in mysql for zenoss and gave it
the following grants.
---------------------+
| Grants for
[EMAIL PROTECTED]
|
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD,
SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES,
SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION
SLAVE, REPLICATION CLIENT ON *.* TO 'zenoss'@'localhost' IDENTIFIED BY
PASSWORD '*1C8E2E08E341AA11A95733D25851CEBD97AA6D1C' WITH GRANT OPTION |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES,
INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON `events`.* TO
'zenoss'@'localhost' WITH GRANT
OPTION
|
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
found this at zenbuild.log
-----
ERROR 1044 (42000) at line 4: Access denied for user
'zenoss'@'localhost' to database 'events'
-------
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
_______________________________________________
zenoss-users mailing list
[email protected]
http://lists.zenoss.org/mailman/listinfo/zenoss-users
