Step 2: Configure MySQL

Run the MySQL secure installation script:


mysql_secure_installation

Create Database and User

Create a database and user for the application:


mysql -u root -p

In the MySQL prompt, run:


CREATE DATABASE ai_education_studio CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER 'ai_edu_user'@'localhost' IDENTIFIED BY 'your_strong_password_here';
GRANT ALL PRIVILEGES ON ai_education_studio.* TO 'ai_edu_user'@'localhost';
FLUSH PRIVILEGES;
EXIT;

Warning: Replace your_strong_password_here with a secure password. Save this password — you will need it in the .env file.