create user dbuser@localhost identified by 'dbpassword';
create database IF NOT EXISTS dbname;
grant all privileges on dbname.* to dbuser@localhost;

User read only

CREATE USER 'metabase'@'metabase.infra.leolagrange.org' IDENTIFIED BY 'mafkeufEt^swylsyibHiBloptepBypunJohavEifwuKninfiOpsocwakpoidPods';
GRANT SELECT ON *.* TO 'metabase'@'metabase.infra.leolagrange.org'