> For the complete documentation index, see [llms.txt](https://cleberjamaral.gitbook.io/mind/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://cleberjamaral.gitbook.io/mind/knowledge/programming/mysql.md).

# mysql

### Check if the server is running 

```
# service mysql status
```

Instead of `status:` `stop`, `start` and `restart` can be used according to the need)

### Connect to server using terminal client

```
# mysql -u root -p
```

Digitar a senha escolhida para o usuário root

### List existing databases

```
mysql> SHOW databases;
```

### Create a database 

```
mysql> CREATE DATABASE database_name;
```

### Creating and granting rights to an user

```
mysql> CREATE USER "user_name"@"localhost" IDENTIFIED BY "password";

mysql> GRANT ALL PRIVILEGES ON database_name.* to "user_name"@"localhost";

mysql> FLUSH PRIVILEGES;
```

###