Setting up a root user in MySQL/MariaDB
CREATE USER 'admin'@'%' IDENTIFIED BY 'mysecretpassword'; GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION; FLUSH PRIVILEGES;
Golden nuggets where no entry is longer than my expected attention span
CREATE USER 'admin'@'%' IDENTIFIED BY 'mysecretpassword'; GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION; FLUSH PRIVILEGES;