mysql.sh

# Ubuntu installation
sudo apt-get install mysql-server mysql-client libmysqlclient-dev

# Mac installation
brew install mysql
brew install openssl
export LIBRARY_PATH=$LIBRARY_PATH:/usr/local/opt/openssl/lib/
# mac m1 additional command
gem install mysql2 -v '0.5.3' -- --with-opt-dir=$(brew --prefix openssl) --with-ldflags=-L/opt/homebrew/Cellar/zstd/1.5.0/lib

# Configuration
sudo mysql
CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'username'@'localhost';
FLUSH PRIVILEGES
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u username -p mysql