MySQL was design for people with small projects and small databases. It is nearly ideal for such situations.
For large projects, databases, heavy SELECTs, complicated stored procedures - there is PostgreSQL.
Using MySQL or MariaDB in that case is possible, but painful.
Also, two MySQL forks are drifting apart as we speak.