Advertisement
Guest User

Untitled

a guest
Feb 21st, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. and create database and user for osticket:
  2. MariaDB [(none)]> create database `osticket`;
  3. MariaDB [(none)]> default character set utf8 collate utf8_general_ci;
  4. MariaDB [(none)]> create user 'osticket-owner'@'localhost';
  5. MariaDB [(none)]> create user 'osticket-owner'@'127.0.0.1';
  6. MariaDB [(none)]> create user 'osticket-owner'@'::1';
  7. MariaDB [(none)]> set password for 'osticket-owner'@'localhost' = password('Passw0rd');
  8. MariaDB [(none)]> set password for 'osticket-owner'@'127.0.0.1' = password('Passw0rd');
  9. MariaDB [(none)]> set password for 'osticket-owner'@'::1' = password('Passw0rd');
  10. MariaDB [(none)]> grant all privileges on `osticket`.* to 'osticket-owner'@'localhost' with grant option;
  11. MariaDB [(none)]> grant all privileges on `osticket`.* to 'osticket-owner'@'127.0.0.1' with grant option;
  12. MariaDB [(none)]> grant all privileges on `osticket`.* to 'osticket-owner'@'::1' with grant option;
  13. MariaDB [(none)]> flush privileges;
  14. MariaDB [(none)]> quit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement