SCRIPT D’INSTALLATION COMPLET

#!/bin/bash
# Script d'installation pour environnement MySQL complet sur Linux Mint

# 1. MySQL Server 8.x
echo "📊 Installation de MySQL Server 8.x..."
wget https://dev.mysql.com/get/mysql-apt-config_0.8.29-1_all.deb
sudo dpkg -i mysql-apt-config_0.8.29-1_all.deb
sudo apt update
sudo apt install -y mysql-server mysql-client

# 2. phpMyAdmin (avec Apache et PHP)
echo "🌐 Installation de phpMyAdmin..."
sudo apt install -y apache2 php php-mysql libapache2-mod-php phpmyadmin
sudo systemctl enable apache2
sudo systemctl start apache2

# 3. DBeaver CE
echo "🗄️ Installation de DBeaver CE..."
sudo snap install dbeaver-ce

# 4. MySQL Workbench
echo "🔧 Installation de MySQL Workbench..."
wget https://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community_8.0.36-1ubuntu22.04_amd64.deb
sudo dpkg -i mysql-workbench-community*.deb
sudo apt -f install -y

# 5. Percona XtraBackup
echo "💾 Installation de Percona XtraBackup..."
wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb
sudo dpkg -i percona-release_latest.generic_all.deb
sudo apt update
sudo apt install -y percona-xtrabackup-80

# 6. MySQL Tuner
echo "⚙️ Installation de MySQL Tuner..."
wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl
chmod +x mysqltuner.pl
sudo mv mysqltuner.pl /usr/local/bin/

# Configuration post-installation
echo "🔒 Configuration sécurisée de MySQL..."
sudo mysql_secure_installation

echo "✅ Installation terminée!"

💡 INSTALLATION RAPIDE (copier-coller)

Installation en une seule commande :

# Tout installer d'un coup
sudo apt update && \
sudo apt install -y wget curl && \
wget https://dev.mysql.com/get/mysql-apt-config_0.8.29-1_all.deb && \
sudo dpkg -i mysql-apt-config_0.8.29-1_all.deb && \
sudo apt update && \
sudo apt install -y mysql-server mysql-client apache2 php php-mysql libapache2-mod-php phpmyadmin && \
sudo snap install dbeaver-ce && \
wget https://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community_8.0.36-1ubuntu22.04_amd64.deb && \
sudo dpkg -i mysql-workbench-community*.deb && \
sudo apt -f install -y && \
wget https://repo.percona.com/apt/percona-release_latest.generic_all.deb && \
sudo dpkg -i percona-release_latest.generic_all.deb && \
sudo apt update && \
sudo apt install -y percona-xtrabackup-80 && \
wget https://raw.githubusercontent.com/major/MySQLTuner-perl/master/mysqltuner.pl && \
chmod +x mysqltuner.pl && \
sudo mv mysqltuner.pl /usr/local/bin/

🚀 COMMANDES DE VÉRIFICATION

# Vérifier les installations
mysql --version                    # MySQL Server
php -v                             # PHP pour phpMyAdmin
apache2 -v                         # Apache pour phpMyAdmin
dbeaver --version                  # DBeaver
mysql-workbench --version          # MySQL Workbench
xtrabackup --version              # Percona XtraBackup
perl /usr/local/bin/mysqltuner.pl --help  # MySQL Tuner

# Statut des services
sudo systemctl status mysql
sudo systemctl status apache2

🔗 ACCÈS AUX OUTILS

# phpMyAdmin
firefox http://localhost/phpmyadmin

# MySQL en ligne de commande
mysql -u root -p

# DBeaver
dbeaver-ce &

# MySQL Workbench
mysql-workbench &

# MySQL Tuner (analyse)
sudo perl /usr/local/bin/mysqltuner.pl

# Sauvegarde avec XtraBackup
sudo xtrabackup --backup --target-dir=/var/backups/mysql/

📌 NOTES IMPORTANTES

• phpMyAdmin : Lors de l’installation, choisir apache2 et configurer avec dbconfig-common
• MySQL : Noter le mot de passe root défini pendant mysql_secure_installation
• Percona XtraBackup : Nécessite les privilèges appropriés pour les sauvegardes
• MySQL Tuner : Attendre au moins 24h d’utilisation pour des recommandations pertinentes

💾 Sauvegardez ce script dans un fichier install-mysql-tools.sh et exécutez avec :

chmod +x install-mysql-tools.sh
./install-mysql-tools.sh