Local permissive permissions (for running an sql server on your linux laptop, most definitely //not// for production servers).

```plaintext
GRANT ALL ON *.* TO username IDENTIFIED BY 'password';
```

Note that on Ubuntu (and presumably other modern Linux's, though I haven't checked), you access the root user on the MariaDb server via `sudo mysql`, rather than the root user having a password.