You can set your password in MySQL without any special privileges.

See the MySQL manual

SET PASSWORD = PASSWORD('some password')

Set the password for the current user. Any non-anonymous user can change his own password!

No need to call flush privileges either