Advertisement
Guest User

grant galera

a guest
Mar 29th, 2017
490
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.87 KB | None | 0 0
  1. log]# mysql -u root -p
  2. Enter password:
  3. Welcome to the MariaDB monitor.  Commands end with ; or \g.
  4. Your MariaDB connection id is 2252
  5. Server version: 10.1.22-MariaDB MariaDB Server
  6.  
  7. Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
  8.  
  9. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
  10.  
  11. MariaDB [(none)]> GRANT ALL PRIVILEGES ON nova_api.* TO 'nova'@'localhost' \
  12.     ->   IDENTIFIED BY 'passs';
  13. Query OK, 0 rows affected (0.00 sec)
  14.  
  15. MariaDB [(none)]> GRANT ALL PRIVILEGES ON nova_api.* TO 'nova'@'%' \
  16.     ->   IDENTIFIED BY 'passs';
  17. Query OK, 0 rows affected (0.00 sec)
  18.  
  19. MariaDB [(none)]> GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'localhost' \
  20.     ->   IDENTIFIED BY 'passs';
  21. Query OK, 0 rows affected (0.00 sec)
  22.  
  23. MariaDB [(none)]> GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'%' \
  24.     ->   IDENTIFIED BY 'passs';
  25. Query OK, 0 rows affected (0.00 sec)
  26.  
  27. MariaDB [(none)]> flush privileges;
  28. Query OK, 0 rows affected (0.01 sec)
  29.  
  30. MariaDB [(none)]> show grants
  31.     -> ;
  32. +----------------------------------------------------------------------------------------------------------------------------------------+
  33. | Grants for root@localhost                                                                                                              |
  34. +----------------------------------------------------------------------------------------------------------------------------------------+
  35. | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*blabla' WITH GRANT OPTION |
  36. | GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION                                                                          |
  37. +----------------------------------------------------------------------------------------------------------------------------------------+
  38. 2 rows in set (0.00 sec)
  39.  
  40. MariaDB [(none)]> exit
  41. Bye
  42. [root@
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement