# Step 5: Setup Ninanolte using phpMyAdmin

## Prerequisites

**On NEW server (vps2.scala4.com):**

1. **Extract WordPress files first:**
```bash
DATE=$(date +%Y%m%d)
mkdir -p /var/www/html/ninanolte
cd /backup/applications
tar -xzf ninanolte-${DATE}.tar.gz -C /var/www/html/
chown -R www-data:www-data /var/www/html/ninanolte
chmod -R 755 /var/www/html/ninanolte
```

2. **Check if phpMyAdmin is installed:**
```bash
# Check if phpMyAdmin exists
ls -la /var/www/html/phpmyadmin 2>/dev/null || echo "phpMyAdmin not found"

# Or check if it's accessible
curl -I http://localhost/phpmyadmin 2>/dev/null | head -1
```

## Option A: phpMyAdmin is Already Installed

### Step 1: Access phpMyAdmin

1. Open browser and go to: `http://YOUR_SERVER_IP/phpmyadmin`
   - Or if you have a domain: `http://vps2.scala4.com/phpmyadmin`
   
2. Login with:
   - **Username:** `root`
   - **Password:** (try empty first, or check `/root/.my.cnf`)

### Step 2: Create Database

1. Click **"New"** in the left sidebar
2. Enter database name: `nina`
3. Choose collation: `utf8mb4_unicode_ci`
4. Click **"Create"**

### Step 3: Create Database User

1. Click on **"User accounts"** tab (top menu)
2. Click **"Add user account"**
3. Fill in:
   - **User name:** `nina`
   - **Host name:** `localhost`
   - **Password:** `SunnySummer2022!` (or click "Generate" for new one)
4. Under **"Database for user account"**, select:
   - **Grant all privileges on database `nina`**
5. Click **"Go"** at bottom

### Step 4: Import Database

1. Click on **`nina`** database in left sidebar
2. Click **"Import"** tab (top menu)
3. Click **"Choose File"**
4. Select: `/backup/databases/nina-20260119.sql`
5. Click **"Go"** at bottom
6. Wait for import to complete

### Step 5: Verify

1. Click on **`nina`** database
2. You should see all the WordPress tables (wp_posts, wp_users, etc.)

---

## Option B: Install phpMyAdmin (if not installed)

**On NEW server:**

```bash
# Install phpMyAdmin
apt-get update
apt-get install -y phpmyadmin

# During installation:
# - Choose apache2 (press space to select, then Enter)
# - Choose "Yes" to configure database
# - Set a password for phpmyadmin user (or leave blank)
```

**Then follow Option A above.**

---

## Option C: Quick phpMyAdmin Setup Script

**On NEW server, run:**

```bash
# Install phpMyAdmin (if needed)
apt-get update
apt-get install -y phpmyadmin

# Create symlink if needed
ln -s /usr/share/phpmyadmin /var/www/html/phpmyadmin

# Set permissions
chown -R www-data:www-data /var/www/html/phpmyadmin
```

**Then access:** `http://YOUR_SERVER_IP/phpmyadmin`

---

## After Database Setup

Once database is created and imported via phpMyAdmin:

1. **Update wp-config.php** (if needed):
```bash
nano /var/www/html/ninanolte/wordpress/wp-config.php
```

Check these lines:
```php
define( 'DB_NAME', 'nina' );
define( 'DB_USER', 'nina' );
define( 'DB_PASSWORD', 'SunnySummer2022!' );
define( 'DB_HOST', 'localhost' );
```

2. **Create Apache virtual host** (Step 6)

---

## Troubleshooting

**Can't access phpMyAdmin?**
- Check if Apache is running: `systemctl status apache2`
- Check if phpMyAdmin is installed: `dpkg -l | grep phpmyadmin`
- Check Apache error log: `tail -f /var/log/apache2/error.log`

**Import fails?**
- Check file size limit in phpMyAdmin settings
- Try importing via command line instead
- Check file permissions: `ls -la /backup/databases/nina-*.sql`

**Login fails?**
- Try empty password
- Check `/root/.my.cnf` for password
- Reset MySQL root password if needed