MySQL: دليل متعدد المنصات لتثبيت وتهيئة MySQL

# One-line command, ready in 30 seconds
docker run -d --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=Root123! mysql:8.0

# 1. Pull an image
docker pull mysql:8.0

# 2. Start the container (Set root password to Root123!)
docker run -d \
  --name mysql-tutorial \
  -p 3306:3306 \
  -e MYSQL_ROOT_PASSWORD=Root123! \
  -v mysql_data:/var/lib/mysql \
  mysql:8.0

# 3. View Container Status
docker ps

# 4. Enter MySQL Command Line
docker exec -it mysql-tutorial mysql -u root -pRoot123!

mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.
mysql>

# Start a Stopped Container
docker start mysql-tutorial

# Stop the container
docker stop mysql-tutorial

# Restart the container
docker restart mysql-tutorial

# View Logs
docker logs mysql-tutorial

# Delete Container (Must stop first)
docker stop mysql-tutorial && docker rm mysql-tutorial

# Delete Data Volume (Permanently Delete Data)
docker volume rm mysql_data

mysql-tutorial

1. Run mysql-installer-community-8.0.x.msi
2. Select "Custom" Installation Type
3. Select MySQL Server 8.0 + MySQL Workbench
4. Layout：
   - Config Type: Development Computer
   - Port: 3306（Default）
   - Authentication Method: Use Strong Password Encryption
   - Root Password: Set a Password (Remember it!)
5. Click Execute Installation Complete

# Open CMD or PowerShell
mysql --version

# Connect MySQL
mysql -u root -p

mysql  Ver 8.0.36 for Win64 on x86_64 (MySQL Community Server - GPL)

# 1. Update Homebrew
brew update

# 2. Installation MySQL
brew install mysql

# 3. Start MySQL Services
brew services start mysql

# 4. Secure Initialization
mysql_secure_installation

# 5. Connection Test
mysql -u root -p

==> Downloading https://homebrew.bintray.com/bottles/mysql-8.0.36.arm64_sonoma.bottle.tar.gz
==> Pouring mysql-8.0.36.arm64_sonoma.bottle.tar.gz
==> Starting `mysql`...
==> Successfully started `mysql` (label: homebrew.mxcl.mysql)

# 1. Update Package Index
sudo apt update

# 2. Installation MySQL Server
sudo apt install mysql-server

# 3. Start the service
sudo systemctl start mysql

# 4. Secure Initialization
sudo mysql_secure_installation

# 5. Connection Test
sudo mysql -u root -p

# 1. Add MySQL Yum Warehouse
sudo rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el8-9.noarch.rpm

# 2. Installation MySQL Server
sudo dnf install mysql-server

# 3. Start the service
sudo systemctl start mysqld

# 4. Get a temporary password
sudo grep 'temporary password' /var/log/mysqld.log

# 5. Secure Initialization（Use a temporary password）
mysql_secure_installation

1. Open MySQL Workbench
2. Click "+" Create a New Connection
3. Layout：
   - Connection Name: Local MySQL
   - Hostname: 127.0.0.1
   - Port: 3306
   - Username: root
   - Password: Click "Store in Vault" Save Password
4. Click "Test Connection" Test
5. Click "OK" Save

-- Log in to MySQL and execute
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewStrongPass123!';

-- Refresh Permissions
FLUSH PRIVILEGES;

-- Create a developer account, allow only local connections
CREATE USER 'dev_user'@'localhost' IDENTIFIED BY 'DevPass123!';

-- Grant permissions on all databases
GRANT ALL PRIVILEGES ON *.* TO 'dev_user'@'localhost';

-- Refresh Permissions
FLUSH PRIVILEGES;

Query OK, 0 rows affected (0.01 sec)