marknre/alpine_devel repository overview

⁠Install mysql server

apk add mariadb mariadb-client

DB_DATA_PATH="/var/lib/mysql"

DB_ROOT_PASS="markn123"

DB_USER="markn"

DB_PASS="markn123"

MAX_ALLOWED_PACKET="200M"

⁠Configure db server

mysql_install_db --user=mysql --datadir=${DB_DATA_PATH}

⁠Starting the mysql server

/usr/bin/mysqld_safe --datadir=/var/lib/mysql &

⁠Add DB_USER

echo "GRANT ALL ON . TO ${DB_USER}@'127.0.0.1' IDENTIFIED BY '${DB_PASS}' WITH GRANT OPTION;" > /tmp/sql

echo "GRANT ALL ON . TO ${DB_USER}@'localhost' IDENTIFIED BY '${DB_PASS}' WITH GRANT OPTION;" >> /tmp/sql

echo "GRANT ALL ON . TO ${DB_USER}@'::1' IDENTIFIED BY '${DB_PASS}' WITH GRANT OPTION;" >> /tmp/sql

echo "DELETE FROM mysql.user WHERE User='';" >> /tmp/sql

echo "DROP DATABASE test;" >> /tmp/sql

echo "FLUSH PRIVILEGES;" >> /tmp/sql

cat /tmp/sql | mysql -u root --password="${DB_ROOT_PASS}"

rm /tmp/sql

⁠Set root password

/usr/bin/mysqladmin -u root password 'markn123'

mysql -e "GRANT ALL ON . TO clevermonitor@'172.17.0.2' IDENTIFIED BY 'cleverview7070' WITH GRANT OPTION;

GRANT ALL ON . TO clevermonitor@'localhost' IDENTIFIED BY 'cleverview7070' WITH GRANT OPTION;

GRANT ALL ON . TO cleverreport@'localhost' IDENTIFIED BY 'cleverview3306' WITH GRANT OPTION;

GRANT ALL ON . TO cleverreport@'172.17.0.2' IDENTIFIED BY 'cleverview3306' WITH GRANT OPTION;

GRANT ALL ON . TO cleverreport@'%' IDENTIFIED BY 'cleverview3306' WITH GRANT OPTION;

flush privileges;" -uroot -pmarkn123

⁠Login

mysql -uroot -pmarkn123

⁠Checking

ps aux | grep mysql