Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- log]# mysql -u root -p
- Enter password:
- Welcome to the MariaDB monitor. Commands end with ; or \g.
- Your MariaDB connection id is 2252
- Server version: 10.1.22-MariaDB MariaDB Server
- Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others.
- Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
- MariaDB [(none)]> GRANT ALL PRIVILEGES ON nova_api.* TO 'nova'@'localhost' \
- -> IDENTIFIED BY 'passs';
- Query OK, 0 rows affected (0.00 sec)
- MariaDB [(none)]> GRANT ALL PRIVILEGES ON nova_api.* TO 'nova'@'%' \
- -> IDENTIFIED BY 'passs';
- Query OK, 0 rows affected (0.00 sec)
- MariaDB [(none)]> GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'localhost' \
- -> IDENTIFIED BY 'passs';
- Query OK, 0 rows affected (0.00 sec)
- MariaDB [(none)]> GRANT ALL PRIVILEGES ON nova.* TO 'nova'@'%' \
- -> IDENTIFIED BY 'passs';
- Query OK, 0 rows affected (0.00 sec)
- MariaDB [(none)]> flush privileges;
- Query OK, 0 rows affected (0.01 sec)
- MariaDB [(none)]> show grants
- -> ;
- +----------------------------------------------------------------------------------------------------------------------------------------+
- | Grants for root@localhost |
- +----------------------------------------------------------------------------------------------------------------------------------------+
- | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*blabla' WITH GRANT OPTION |
- | GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION |
- +----------------------------------------------------------------------------------------------------------------------------------------+
- 2 rows in set (0.00 sec)
- MariaDB [(none)]> exit
- Bye
- [root@
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement