grant CREATE DATABASE permission PHP my admin

✅ CORRECT FIX (DO THIS EXACTLY)

🔹 Step 1: Stay logged in as root (you already are)

You should see:

🔹 Step 2: FIRST create the user

⚠️ This step is mandatory

✅ If successful, you’ll see:

🔹 Step 3: NOW grant CREATE DATABASE permission

🔹 Step 4: (Optional but useful) Allow full DB control

🔹 Step 5: Verify

You MUST see:

🔹 Step 6: Exit MySQL

✅ FINAL STEP: phpMyAdmin

1. Logout from phpMyAdmin

2. Login again using:

   Username: user1
Password: StrongPassword@123


3. Open Databases

🎉 “No Privileges” WILL BE GONE
🎉 Create database option ENABLED

🔐 BEST PRACTICE (IMPORTANT)

For production servers:

• ❌ Do NOT give ALL PRIVILEGES ON *.*

• ✅ Give access only to required DB

Example (secure):

If you want, I can:

• 🔐 Secure MySQL properly

• 🟢 Create WordPress-ready DB & user

• 🧹 Remove phpMyAdmin warnings

• 🔒 Enable HTTPS (remove “Not Secure”)