Is there any way to set privileges on my root mysql account to be able to create and drop procedures, functions, and views? I am unable to maintain my user account on the server using phpmyadmin.
I get the error “alter routine command denied to user” executing DROP FUNCTION if exists functionname
I also can’t execute SELECT sql_grants FROM common_schema.sql_show_grants to view permissions.
Changing permissions on databases is not possible from your main SQL login, you need the actual, server wide root user to do that. Which, since there are databases from many different accounts on a server, is not accessible for you.
Restricting permissions (or creating additional users) is not possible on InfinityFree. You need to upgrade your account to get that level of control.