MySQL Database Management: Users, Permissions, Tables
Classified in Computers
Written on in English with a size of 3.76 KB
Users
Creation
From the Partner's Computer
- Create user `Professor` @ '192.168.5.25' identified by 'Professor';
Local Access
- Administrative user `Create` @ 'localhost' identified by 'Administrative';
Access from Any Computer
- Create user `` @ '%' student identified by 'student';
Deletion
- DROP
Permissions
To Grant Permissions
- GRANT SELECT ON clase.cuidadores TO 'student'@'localhost';
SELECT * FROM carers;
- GRANT SELECT (name, currency) ON clase.cuidadores TO 'student'@'localhost';
SELECT name FROM currency carers;
- GRANT INSERT, SELECT, UPDATE ON IES.Curso TO 'Administrative'@'localhost';
- GRANT INSERT (IdCurso, DNI), SELECT (IdCurso, DNI), UPDATE (IdCurso, ID) ON IES.Matrícula TO 'Administrative'@'localhost';
With Update
- GRANT SELECT (name, currency), UPDATE (currency)