38
edits
Line 77: | Line 77: | ||
6. Create Database and User with access rights to this database. | 6. Create Database and User with access rights to this database. | ||
Example for MySQL: | |||
<code> | |||
mysql -u root -p mysql | |||
mysql> CREATE DATABASE netxms; | mysql> CREATE DATABASE netxms; | ||
mysql> GRANT ALL ON netxms.* TO netxms@localhost IDENTIFIED BY 'PaSsWd'; | mysql> GRANT ALL ON netxms.* TO netxms@localhost IDENTIFIED BY 'PaSsWd'; | ||
mysql> \q | mysql> \q | ||
</code> | |||
Example for Oracle 11g: | |||
<code> | |||
-- USER SQL | |||
CREATE USER netxms IDENTIFIED BY PaSsWd | |||
DEFAULT TABLESPACE USERS | |||
TEMPORARY TABLESPACE TEMP; | |||
-- QUOTAS | |||
ALTER USER netxms QUOTA UNLIMITED ON USERS; | |||
-- ROLES | |||
GRANT RESOURCE TO netxms ; | |||
GRANT CONNECT TO netxms ; | |||
</code> | |||
Please note that database that user you have created should have rights to create new tables. | Please note that database that user you have created should have rights to create new tables. |
edits