One thing this is needed for is stored procedures (creating, dropping, etc…)
Take a look at privileges:
desc mysql.user;
Add Super-Admin to a user:
update mysql.user set Super_Priv='Y' where user='yourlogin' and host='%'; flush privileges;
On systems with systemd
, and the server fails to start, logging error:
[Warning] Can't create test file /home/johndoe/UserDatabases/mypcname.lower-test
The solution is to change in file /lib/systemd/system/mariadb.service
:
ProtectHome=true
… to …
ProtectHome=false