viernes, 22 de marzo de 2013

Actividad#19


Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.27 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create user Admin identified by 'Admin1';
Query OK, 0 rows affected (0.02 sec)

mysql> create user Med identified by 'Med1';
Query OK, 0 rows affected (0.01 sec)

mysql> create user Asist identified by 'Asist1';
Query OK, 0 rows affected (0.00 sec)

mysql> select  user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.04 sec)

mysql> grant all privileges on veterin.* to 'Admin'with grant option;
Query OK, 0 rows affected (0.10 sec)

mysql> grant insert,update,delete,select  on veterinaria.* to 'Med'@'localhost';
Query OK, 0 rows affected (1.35 sec)

mysql> grant all privileges on veterin.* to 'Admin'with grant option;
Query OK, 0 rows affected (0.00 sec)

mysql> grant insert,update,delete,select  on veterinaria.* to 'Med'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> grant select  on veterin.* to 'Asist'@'localhost';
Query OK, 0 rows affected (0.01 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| cdcol              |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
| veterinaria            |
| webauth            |
+--------------------+
8 rows in set (0.01 sec)

mysql> use veterinaria;
Database changed

mysql> select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.11 sec)

mysql> exit

No hay comentarios:

Publicar un comentario