RoE | Wiki

User Tools

Site Tools

Trace: • mariadb • joomla
servers:linux:mysql

Differences

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

Link to this comparison view

Next revision		Previous revision
servers:linux:mysql [2024/08/13 16:33] – created Sean Rhoneservers:linux:mysql [2024/09/22 02:05] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ====== Information ====== ====== Information ======
  
-  * MySQL Community Edition ((https://www.mysql.com/products/community/)) +  * MySQL
-  * [[Information:Realm of Espionage]]+
  
 ===== Prerequisites ===== ===== Prerequisites =====
  
-  * [[distros:fedora_server | Fedora Server]] +  * [[linux;distros;fedora_workstation_gnome|Fedora Workstation (GNOME)]] 
- +  * [[distros:fedora_server|Fedora Server]] (TODO)
-====== Repository ====== +
- +
-  * https://dev.mysql.com/downloads/repo/yum/ +
- +
-  sudo dnf install 'https://dev.mysql.com/get/mysql80-community-release-fc29-2.noarch.rpm' +
- +
-====== 5.7 ====== +
- +
-  * Disables the latest GA repo and enables the 5.7 repo +
-  * This is necessary for TrinityCore +
- +
-  sudo dnf repolist all | grep 'mysql' +
- +
-  sudo dnf config-manager --disable 'mysql80-community' +
- +
-  sudo dnf config-manager --enable 'mysql57-community' && sudo dnf repolist enabled | grep 'mysql'+
  
 ====== Dependencies ====== ====== Dependencies ======
Line 29: Line 12:
 **** ****
  
-  sudo dnf install 'mysql-community-server'+  sudo dnf install 'mysql-server'
  
-====== Settings ====== +====== Service ======
- +
-===== Initial ===== +
- +
-**** +
- +
-  echo '!includedir /etc/my.cnf.d' | sudo tee --append '/etc/my.cnf' > '/dev/null' +
- +
-===== Settings ===== +
- +
-  * :!: The empty ''sql-mode'' setting is intentional ((this disables strict mode)) +
- +
-  sudo mkdir -p '/etc/my.cnf.d' && sudo -e '/etc/my.cnf.d/custom.cnf' +
- +
-<code> +
-[mysqld] +
-character-set-client-handshake = FALSE +
-character-set-server = utf8mb4 +
-collation-server = utf8mb4_unicode_ci +
-expire_logs_days = 7 +
-max_binlog_size = 100M +
-skip-networking = On +
-sql-mode = </code> +
- +
-===== Verify ===== +
- +
-**** +
- +
-  mysqladmin variables -u 'root' -p | egrep 'utf8|networking|socket' +
- +
-====== Initial Setup ====== +
- +
-===== Service =====+
  
 **** ****
Line 69: Line 20:
   sudo systemctl enable 'mysqld' --now   sudo systemctl enable 'mysqld' --now
  
-===== Get Temporary Password =====+====== Settings ======
  
 **** ****
  
-  cat '/var/log/mysqld.log' | grep 'temporary password'+  sudo mysql_secure_installation
  
-===== Setup =====+===== Verify =====
  
 **** ****
  
-  mysql_secure_installation +  mysqladmin -u 'root' -p variables | egrep 'utf8|networking|socket'
- +
  
 ====== Database Repair and Optimization ====== ====== Database Repair and Optimization ======
  
-===== Create MySQL User ===== +===== One-shot =====
- +
-  mysql -u 'root' -p +
- +
-  GRANT SELECT, INSERT ON *.* to 'maintenance'@'localhost' IDENTIFIED BY 'x'; +
- +
-  FLUSH PRIVILEGES; +
- +
-===== Authentication File ===== +
- +
-  sudo -u 'mysql' mkdir -p '/var/lib/mysql/auth' && sudo -u 'mysql' -e '/var/lib/mysql/auth/maintenance' && sudo chmod '600' '/var/lib/mysql/auth/maintenance' +
- +
-<code> +
-[mysqlcheck] +
-user=maintenance +
-password=x</code> +
- +
-===== Service ===== +
- +
-  sudo -e '/etc/systemd/system/db-m.service' +
- +
-<code> +
-[Service] +
-User=mysql +
-Group=mysql +
-Type=oneshot +
-ExecStart='/usr/bin/mysqlcheck' --defaults-extra-file='/var/lib/mysql/auth/maintenance' --auto-repair --optimize --all-databases --force +
-ExecStartPost='/usr/bin/sync'</code> +
- +
-===== Timer ===== +
- +
-  sudo -e '/etc/systemd/system/db-m.timer' && sudo systemctl daemon-reload && sudo systemctl enable 'db-m.timer' --now && sudo systemctl start 'db-m' && sudo systemctl status 'db-m' -l +
- +
-<code> +
-[Unit] +
-Description=MySQL Database Check, Repair, and Optimization +
-After=mysqld.service +
- +
-[Timer] +
-OnCalendar=weekly +
-Persistent=true +
- +
-[Install] +
-WantedBy=timers.target</code> +
- +
-====== Notable Commands ====== +
- +
-===== Show Users on Server =====+
  
 **** ****
  
-  select User,Host from mysql.user; +  mysqlcheck --user='root' --password --all-databases --auto-repair --extended --force --optimize
- +
-===== Show Data Folder Location ===== +
- +
-**** +
- +
-  select @@datadir; +
- +
-===== Socket File ===== +
- +
-**** +
- +
-  /var/lib/mysql/mysql.sock +
- +
-===== Log ===== +
- +
-**** +
- +
-  /var/log/mysqld.log +
- +
-===== Reset ===== +
- +
-  sudo systemctl stop 'mysqld' +
- +
-  sudo rm -Rf '/etc/my.cnf'* '/var/lib/mysql'* '/var/log/mysqld.log' && sync +
- +
-  sudo dnf reinstall 'mysql-community-server' +
- +
-===== Password Validation ===== +
- +
-==== cnf ==== +
- +
-**** +
- +
-  validate_password_policy=LOW +
- +
-==== Query ==== +
- +
-  mysql -u 'root' -p +
- +
-  SHOW VARIABLES LIKE 'validate_password%'; +
- +
-==== Configure ==== +
- +
-  * Default policy is ''MEDIUM'' +
- +
-  mysql -u 'root' -p +
- +
-  SET GLOBAL validate_password_policy=LOW; +
- +
-==== Disable ==== +
- +
-  mysql -u 'root' -p +
- +
-  UNINSTALL PLUGIN validate_password; +
- +
-==== Enable ==== +
- +
-  mysql -u 'root' -p +
- +
-  INSTALL PLUGIN validate_password SONAME 'validate_password.so';+
  
/srv/www/wiki/data/attic/servers/linux/mysql.1723581197.txt.gz · Last modified: (external edit)