Skip to content

Commit 718eef1

Browse files
authored
added about access controls
1 parent d096344 commit 718eef1

File tree

1 file changed

+10
-1
lines changed

1 file changed

+10
-1
lines changed

README.md

Lines changed: 10 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -366,6 +366,15 @@ create table emp_dup like employee;
366366
create table emp_dup select * from employee;
367367
```
368368

369+
## Access Controls
370+
371+
#### Set new password to a user
372+
```sql
373+
use mysql;
374+
update user set authentication_string=PASSWORD("<new2-password>") where User='<user>';
375+
flush privileges;
376+
```
377+
369378
## Programming
370379

371380
#### Declare variables
@@ -420,4 +429,4 @@ select month("1998-12-30");
420429
#### Extract Year
421430
```sql
422431
select year("1998-12-30");
423-
```
432+
```

0 commit comments

Comments
 (0)