User Tools
tech:mariadb:start
Differences
This shows you the differences between two versions of the page.
|
tech:mariadb:start [2017/10/13 04:40] rk4n3 created |
tech:mariadb:start [2019/01/22 19:47] (current) rk4n3 |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== MariaDB & MySQL ====== | ====== MariaDB & MySQL ====== | ||
| + | ==== Super-Admin Privileges ==== | ||
| + | One thing this is needed for is stored procedures (creating, dropping, etc...) \\ | ||
| + | Take a look at privileges:<code>desc mysql.user;</code> | ||
| + | Add Super-Admin to a user:<code>update mysql.user set Super_Priv='Y' where user='yourlogin' and host='%'; | ||
| + | flush privileges;</code> | ||
| + | |||
| + | ==== Missing directory issue(s) ==== | ||
| On systems with ''systemd'', and the server fails to start, logging error: | On systems with ''systemd'', and the server fails to start, logging error: | ||
| - | |||
| <code>[Warning] Can't create test file /home/johndoe/UserDatabases/mypcname.lower-test</code> | <code>[Warning] Can't create test file /home/johndoe/UserDatabases/mypcname.lower-test</code> | ||
| The solution is to change in file ''/lib/systemd/system/mariadb.service'': | The solution is to change in file ''/lib/systemd/system/mariadb.service'': | ||
| - | |||
| <code>ProtectHome=true</code> | <code>ProtectHome=true</code> | ||
| - | |||
| ... to ... | ... to ... | ||
| - | |||
| <code>ProtectHome=false</code> | <code>ProtectHome=false</code> | ||
tech/mariadb/start.1507887635.txt.gz ยท Last modified: 2017/10/13 04:40 by rk4n3
Page Tools
