RoE | Wiki

User Tools

Site Tools

Trace:
servers:mariadb

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
servers:mariadb [2019/10/24 01:54] – Sean Rhoneservers:mariadb [2019/10/24 13:07] – Sean Rhone
Line 6: Line 6:
 ===== Prerequisites ===== ===== Prerequisites =====
  
-  * [[distros:fedora_server|Fedora Server]]+  * [[distros:ubuntu_server|Ubuntu Server]]
  
 ====== Settings ====== ====== Settings ======
Line 34: Line 34:
 **** ****
  
-  mysqladmin --user='root' --password variables | egrep 'utf8|networking|socket'+  sudo mysqladmin variables | egrep 'utf8|networking|socket'
  
 ====== Dependencies ====== ====== Dependencies ======
Line 52: Line 52:
 ===== Create MySQL User ===== ===== Create MySQL User =====
  
-  mysql --user='root' --password+  sudo mysql
  
   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost' IDENTIFIED BY 'x';   GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost' IDENTIFIED BY 'x';
  
   FLUSH PRIVILEGES;   FLUSH PRIVILEGES;
 +
 +  EXIT
  
 ===== Authentication File ===== ===== Authentication File =====
Line 77: Line 79:
 Type=oneshot Type=oneshot
 ExecStart='/usr/bin/mysqlcheck' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --auto-repair --optimize --all-databases --force ExecStart='/usr/bin/mysqlcheck' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --auto-repair --optimize --all-databases --force
-ExecStartPost='/usr/bin/sync'</code>+ExecStartPost='/bin/sync'</code>
  
 ===== Timer ===== ===== Timer =====
Line 107: Line 109:
 **** ****
  
-  /var/lib/mysql/mysql.sock+  /var/run/mysqld/mysqld.sock
/var/www/wiki/data/pages/servers/mariadb.txt · Last modified: 2024/03/06 21:01 by Sean Rhone