Webmin not allowing database creation, user creation

Q: Inside webmin I cannot create new databases or users, I get the error:

DBI connect failed : Access denied for user ‘my_user_nam_here’@’%’ to database ‘mysql’

How can I fix this?

A: You need to login to mysql as the mysql admin user (usually called root). Normally if you login to webmin as root it will login you into MySQL as root too. If this does not work, fix it with:

Inside webmin:

Click “servers”
Click “MySQL Databaseservers”
Click “Module Config” on the MySQL screen (top left)
Change “Administration login” to either automatic (should work) or “root”