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

Avtividad #18

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 4

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> use veterinaria;

Database changed

mysql> select*from clientes1;

+------------+-----------------+----------------------+----------+--------------+

| NCliente | nombreCliente    | direccion            | tel         | oficio       |

+------------+-----------------+----------------------+----------+--------------+

|          1 | Deivan Herrera | colombia #012         | 6893494  | Estudiante    |

|          2 | Ricardo Garcia      | aeropuerto #2109       | 6100023  | Estudiante |

|          3 | Melissa Aguilar    | geranios #5321 | 6192828 | Estudiante  |

+------------+-----------------+----------------------+----------+--------------+

3 rows in set (0.21 sec)

mysql> insert into clientes1 values(04,'jessica Barrios','consumidor #5690','6734234','Estudiante');

Query OK, 1 row affected (0.01 sec)

mysql> insert into clientes1 values(05,'Luis Armenta','bromo #9840','6934929'Estudiante');

Query OK, 1 row affected (0.01 sec)

mysql> select*from clientes1;

+------------+-----------------+----------------------+----------+--------------+

| NCliente | nombreCliente    | direccion            | tel         | oficio       |

+------------+-----------------+----------------------+----------+--------------+

|          1 | Deivan Herrera | colombia #012         | 6893494  | Estudiante    |

|          2 | Ricardo Garcia      | aeropuerto #2109       | 6100023  | Estudiante |

|          3 | Melissa Aguilar    | geranios #5321 | 6192828 | Estudiante  |

|          4 | Jessica Barrios  | consumidor #5690 | 6734234 | Estudiante |

|          5 | Luis Armenta | bromo #9840      | 6934929  | Estudiante    |

+------------+-----------------+----------------------+----------+--------------+

5 rows in set (0.01 sec)

mysql> select*from mascotas;

+------+--------+------+------+--------------+-------------+

| NumP | nombre | peso | sexo | raza         | FNacimiento |

+------+--------+------+------+--------------+-------------+

|    1 | gomita |  0.9 | M  | Chihuahua      | 03-05-2011  |

|    2 | burbuja | 0.6 | M  | Chihuahua | 28-06-2012  |

+------+--------+------+------+--------------+-------------+

2 rows in set (0.15 sec)

mysql> insert into mascotas values(3,'bigotes',7,'H','frezhpool','15-02-2009');

Query OK, 1 row affected (0.00 sec)

mysql> insert into mascotas values(4,'wera',5,'M','shorpey','13-11-2004');

Query OK, 1 row affected (0.00 sec)

mysql> insert into mascotas values(5,'popy',10,'H','kocker ','05-06-2000');

Query OK, 1 row affected (0.00 sec)

mysql> select*from mascotas;

+------+--------+------+------+--------------+-------------+

| NumP | nombre | peso | sexo | raza         | FNacimiento |

+------+--------+------+------+--------------+-------------+

|    1 | gomita  |  0.9 | M | Chihuahua      | 03-05-2011  |

|    2 | burbuja | 0.6 | M | Chihuahua | 28-06-2012  |

|    3 | bigotes  | 7 | H | frezhpool | 15-02-2009  |

|    4 | wera | 5 | M | shorpey | 13-11-2004  |

|    5 | popy | 10 | H | kocker | 05-06-2000  |

+------+--------+------+------+----------------+-------------+

5 rows in set (0.00 sec)

mysql> show tables;

+-------------------+

| Tables_in_veterinaria |

+-------------------+

| antenfermedades   |

| clientes1          |

| direccion         |

| hmedica           |

| info              |

| mascotas           |

| mconsulta         |

| servicios         |

| veterinaria       |

+-------------------+

10 rows in set (0.71 sec)

mysql> exit