Installation & Setup
MySQL, LOCALLY, INSTALL, kiya, ja, sakta hai (Windows/Mac/Linux) — mysqld, PROCESS, DATABASE, SERVER, RUN, karta hai. MySQL Workbench, EK, POPULAR, GUI, TOOL, hai, VISUAL, INTERFACE, ke, saath, database, MANAGE, karne, ke, liye.
Cloud, PROVIDERS, (jaise, AWS RDS, PlanetScale) MANAGED, MySQL, SERVICES, OFFER, karte, HAIN — SETUP, BACKUPS, SCALING, AUTOMATICALLY, HANDLE, hote, HAIN, PRODUCTION, deployments, ke, liye.
# Local installation (Mac, Homebrew se):
brew install mysql
brew services start mysql
# Connect via CLI:
mysql -u root -p
# Cloud (PlanetScale example):
mysql -h aws.connect.psdb.cloud -u username -p mydb- mysqld = MySQL database server process
- MySQL Workbench = popular GUI tool, database management ke liye
- Cloud providers, managed, MySQL, services, offer, karte, HAIN, production, ke, liye
Docker, se, MySQL, run, karna, EK, POPULAR, alternative, hai — install, ki, JHANJHAT, se, BACHATA, hai, aur, EASILY, DIFFERENT, VERSIONS, ke, BEECH, SWITCH, kiya, ja, sakta hai.
docker run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=secret --name mysql-db mysql:8.0
docker exec -it mysql-db mysql -u root -pmy.cnf, (ya, my.ini, Windows, PAR) MySQL, ki, MAIN, configuration, file, hai — max_connections, buffer, sizes, aur, MULTIPLE, aur, settings, YAHA, se, configure, ki, ja, sakti, HAIN.