# DB's and Users

##### Create a DB

```
CREATE DATABASE new_database;
```

##### Drop a DB

```
DROP DATABASE new_database;
```

##### Create a new user with all prems

```
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
```

<p class="callout info">GRANT \[type of permission\] ON \[database name\].\[table name\] TO ‘\[username\]’@'localhost’;</p>

<p class="callout info">REVOKE \[type of permission\] ON \[database name\].\[table name\] FROM ‘\[username\]’@‘localhost’;</p>

```
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
```

```
FLUSH PRIVILEGES;
```

##### Check Grants

```
SHOW GRANTS FOR 'user'@'localhost';
```

```
SHOW GRANTS FOR CURRENT_USER();
```

##### Add user to 1 DB

```
GRANT ALL PRIVILEGES ON new_database . * TO 'newuser'@'localhost';
```

##### To drop a user:

```
DROP USER ‘newuser’@‘localhost’;
```