Differences

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

--- useful:mysql-mariadb [2024/01/29 11:59] – admin
+++ useful:mysql-mariadb [2024/12/02 16:49] (current) – admin
@@ Line 2: / Line 2: @@
 ====== MySQL / MariaDB ======
+===== Set up replication =====
+This is the command to set everything:
+     CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000673', MASTER_LOG_POS=4, MASTER_USER='replicator',
+     MASTER_PASSWORD='*******', MASTER_HOST='127.0.0.1', MASTER_PORT=4002;
+where the numbers 000673 and 4 will need to be changed.
 ===== Resync replication =====
@@ Line 48: / Line 57: @@
 Edit /etc/systemd/system/mariadb.service and change ProtectHome to be false (ProtectHome=false). Save the file, then:
-    sudo systemd daemon-reload # refresh the systemd services so it sees your override file
+    sudo systemctl daemon-reload # refresh the systemd services so it sees your override file
     sudo systemctl start mysql # and it should finally start
@@ Line 60: / Line 69: @@
 The solution I have now used is well described at [[https://gist.github.com/drmalex07/c0f9304deea566842490|this Github article]].
+Except that I had a big problem with one connection, and it seems the fix is to change "LOCAL_ADDR=localhost" to "LOCAL_ADDR=127.0.0.1".
 ===== Data files under /home directory =====
@@ Line 93: / Line 105: @@
      mysql myremos_j41 < /tmp/convert.csv
+===== Get basename or dirname from a file path or similar =====
+     SUBSTRING_INDEX(file_path, '/', -1) AS basename
+     LEFT(file_path, LENGTH(file_path) - LENGTH(SUBSTRING_INDEX(file_path, '/', -1)) - 1) AS dirname
+===== Create a new root user =====
+     CREATE USER 'username'@'localhost' IDENTIFIED BY 'the_password';
+     GRANT ALL PRIVILEGES ON *.* TO 'user_name'@'localhost' WITH GRANT OPTION;