A strange behavior is noticed MySQL is that a user without create privileges can create a Database. This post discusses about the same whether it is a bug or feature.
As a developer of any (web based) application which uses MySQL/MariaDB, you should know that the admin account i.e. 'root' should not be used for every purpose.
mysql
Many of us might have come across this issues of not being able to login as the MySQL 'root' user either from the command line or via the phpMyAdmin interface.
The reason to here is that the authentication for the MySQL 'root' user is set to "auth_socket" which basically means that MySQL will let the user login via the same (local)host it the user is already authenticated or logged in as the Linux/Unix user.