Very simple actually.
GRANT ALL PRIVILEGES ON *.* to root@127.0.0.1 identified by 'secretpassw0rd'
Δ