User Tools

Site Tools


tech:mariadb:start

MariaDB & MySQL

Super-Admin Privileges

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;

Missing directory issue(s)

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
tech/mariadb/start.txt · Last modified: 2019/01/22 19:47 by rk4n3