# 1. Arrêter MySQL
sudo systemctl stop mysql
 
# 2. Redémarrer SANS vérifier les permissions
sudo mysqld_safe --skip-grant-tables &
 
# 3. Se connecter SANS mot de passe
mysql -u root
 
# 4. Dans le client MySQL :
FLUSH PRIVILEGES;
 
# 5. Créer/réinitialiser l'utilisateur fsdgsdf  avec nouveau password
ALTER USER 'fsdgsdf '@'localhost' IDENTIFIED BY 'geghdfhgfdgsdsfg';
FLUSH PRIVILEGES;
EXIT;
 
# 6. Redémarrer MySQL normalement
sudo systemctl restart mysql
 
# 7. Tester la connexion
mysql -u fsdgsdf -p
# Entrer le nouveau password

 
# 1. Arrêter MySQL et tuer tous les processus
sudo systemctl stop mysql
sudo pkill -9 mysqld
sudo pkill -9 mysql
sleep 3
 
# 2. Sauvegarder l'ancienne data (au cas où)
sudo cp -r /var/lib/mysql /var/lib/mysql.backup.$(date +%s)
 
# 3. SUPPRIMER la base de données corrompue
sudo rm -rf /var/lib/mysql
sudo rm -rf /var/lib/mysql-files
sudo rm -rf /var/lib/mysql-keyring
 
# 4. Recréer les répertoires
sudo mkdir -p /var/lib/mysql
sudo mkdir -p /var/lib/mysql-files
sudo mkdir -p /var/lib/mysql-keyring
 
# 5. Fixer les permissions
sudo chown -R mysql:mysql /var/lib/mysql
sudo chown -R mysql:mysql /var/lib/mysql-files
sudo chown -R mysql:mysql /var/lib/mysql-keyring
sudo chmod 750 /var/lib/mysql
 
# 6. Initialiser la base VIERGE (sans password root)
sudo mysqld --initialize-insecure --user=mysql --basedir=/usr --datadir=/var/lib/mysql
 
# 7. Redémarrer normalement
sudo systemctl restart mysql
 
# 8. Attendre que ça démarre
sleep 5
 
# 9. Vérifier le statut
sudo systemctl status mysql

 
sudo tee /etc/mysql/mysql.conf.d/optimized.cnf > /dev/null <<'EOF'
# === MySQL 9.7 - Symfony + Multithreading Optimization ===
 
[mysqld]
 
# ========== MULTITHREADING & PERFORMANCE ==========
default_thread_stack = 262144
thread_stack = 262144
 
# Pool de connexions
thread_cache_size = 100
max_connections = 500
max_allowed_packet = 256M
 
# ========== INNODB BUFFER POOL ==========
innodb_buffer_pool_size = 3G
innodb_buffer_pool_instances = 8
 
# ========== INNODB LOG & DURABILITY ==========
innodb_log_file_size = 512M
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = O_DIRECT
 
# ========== PERFORMANCE & CACHE ==========
query_cache_type = 0
query_cache_size = 0
 
# InnoDB file per table
innodb_file_per_table = 1
 
# ========== SYMFONY SPECIFIC ==========
default_storage_engine = InnoDB
sql_mode = 'STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'
 
# ========== NETWORKING ==========
skip-external-locking
bind-address = 127.0.0.1
port = 3306
 
# ========== LOGGING ==========
slow_query_log = 1
slow_query_log_file = /var/log/mysql/slow-query.log
long_query_time = 2
 
# ========== CHARSET ==========
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
EOF

 
# Vérifier la syntaxe
sudo mysqld --validate-config --datadir=/var/lib/mysql
 
# Redémarrer MySQL
sudo systemctl restart mysql
 
# Vérifier
sudo systemctl status mysql

 
sudo tee /etc/mysql/mysql.conf.d/symfony.cnf > /dev/null << 'EOF'
# === Symfony-specific optimizations ===
 
[mysqld]
 
# Doctrine ORM compatibility
innodb_autoinc_lock_mode = 2
 
# Connection timeout
connect_timeout = 10
interactive_timeout = 28800
wait_timeout = 28800
 
# For large batch operations
max_allowed_packet = 256M
 
# Pool settings for concurrent requests
max_connections = 500
max_user_connections = 100
EOF

CREATE OR REPLACE VIEW edt_cahier_pointages AS 
	SELECT point_id, point_visible, point_date_crea, point_date_mod, point_user_crea, point_user_mod, 
		point_edt_id, point_type_id, point_com_prof, point_etu_id, etu_photo, etu_mode
	FROM pointages,  etudiants  
	WHERE point_etu_id=etu_id AND point_visible=1
	ORDER BY point_date_crea DESC	
	;

SELECT 
groupe, 
(MATCH(groupe) AGAINST('neo')) AS score
FROM groupes_index
WHERE MATCH(groupe) AGAINST('neo')
UNION
SELECT 
groupe,
(MATCH (album) AGAINST ('neo')) AS score
FROM album_index
WHERE MATCH(album) AGAINST('neo')