Mysql Setup on Antix Linux

This guide will walk you through setting up MySql on Antix linux runinit system. Reference

Installation

1. Adding the MySQL Apt Repository

   download the MySQL APT Repo. Then install the package with dpkg

   sudo dpkg -i ~/Downloads/mysql-apt-config_0.8.34-1_all.deb

   select OK when it prompts you to go with the default options

2. Install MySQL Toolchain

   sudo apt update
   sudo apt install mysql-server

   then set a password for the root user for MySQL when it asks

3. Create a Service for your Init System

   Runinit

   sudo mkdir -p /etc/sv/mysql
   sudo tee /etc/sv/mysql/run > /dev/null <<'EOF'
   #!/bin/sh
   exec chpst -u mysql /usr/sbin/mysqld
   EOF
   sudo chmod +x /etc/sv/mysql/run
   sudo ln -s /etc/sv/mysql /var/service/

   Now runit will detect and manage MySQL service

   SystemV

   // TODO: Need to complete this code snippet

   Now runit will detect and manage MySQL service

4. Test if Eveything worked

   mysql -u root -p

Change Root Password (Optional)

1. Open mysql shell

   sudo mysql

2. run command to change Password

   ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourPasswordHere';
   FLUSH PRIVILEGES;
   EXIT;

Common Problem

when running $: mysql -u root -p if you get ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

sudo mkdir -p /var/run/mysqld
sudo chown mysql:mysql /var/run/mysqld