Knowledge Base
Authentication is disabled (development mode).

Fix grant permission for mysql root user

Edit

grant mariadb mysql permission permissions root user

sudo mysqld_safe --skip-grant-tables &

mysql --user=root --password=password <<"EOF"
USE `mysql`;
UPDATE `user` SET `Grant_priv` = 'Y' WHERE `User` = 'root';
EOF

sudo kill $!

# check:
SHOW GRANTS FOR 'root'@'localhost';