# Se connecter dans MYSQL

Se connecter dans MYSQL

```bash
# Se connecter sans sélectionner de database
mysql -u <user> -p <password>

# Se connecter a une database sans préciser l'utilisateur
mysql -U <database> -p <password>

# Se connecter a une database avec un utilisateur en particulier
mysql -u <user> -U <database> -p
```

##### MySQL show database

```sql
SHOW DATABASES;
```

MySQL show user

```sql
SELECT user, host FROM mysql.user;
```

MySQL user privilège

```sql
SELECT * FROM information_schema.user_privileges;
```

MySQL add user privilège

```sql
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON <db_name>.* TO '<user>'@'<host>';
```

Exemple

```sql
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON bookstack.* TO 'userbook'@'localhost';
```

Mariadb