Local permissive permissions (for running an sql server on your linux laptop, most definitely //not// for production servers).
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.