xxxxxxxxxx
# Step 1: Install Homebrew (if not already installed)
/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)"
# Step 2: Install MySQL (or any other SQL database you prefer)
brew install mysql
# Step 3: Start MySQL service
brew services start mysql
# Step 4: Install MySQL Workbench (optional GUI client for MySQL)
brew install --cask mysqlworkbench
# Step 5: Connect to MySQL
mysql -u root -p
# Upon successful connection, you can start running SQL queries in the MySQL command-line interface.
# Note: The above instructions assume the user has Homebrew installed. If not, they can visit https://brew.sh/ and follow the instructions for installation.
xxxxxxxxxx
docker pull mcr.microsoft.com/mssql/server:2022-latest
docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=<YourStrong@Passw0rd>" \
-p 1433:1433 --name sql2022 --hostname sql2022 \
-d \
mcr.microsoft.com/mssql/server:2022-latest
xxxxxxxxxx
alias mysqlstart='sudo /usr/local/mysql/support-files/mysql.server start'
alias mysqlstop='sudo /usr/local/mysql/support-files/mysql.server stop'
xxxxxxxxxx
sudo docker run --cap-add SYS_PTRACE -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=Strong.Pwd-123' -p 1433:1433 --name sqledge -d mcr.microsoft.com/azure-sql-edge
xxxxxxxxxx
1. Pull MSSQL Server from Dockerdocker pull microsoft/msssql-server-linux2. Create an Instance and Serverdocker run -d — name MSSQL_Server -e ‘ACCEPT_EULA=Y’ -e ‘SA_PASSWORD= mypassword’ -p 1433:1433 microsoft/mssql- server-linux3. Download node and install SQL CLI as Adminnpm install -g sql-cli4. Check the containerdocker ps -a5. Run the Servermssql -u sa -p <mypassword>