Home Pricing Archive About Privacy

Connecting Heidi SQL to MariaDB in Debian

📑 5 slides 👁 9 views 📅 2/20/2026 📄 PDF
0.0 (0 ratings)

Introduction to MariaDB Setup

Update and install MariaDB server using sudo apt commands.

Introduction to MariaDB Setup
2

Connecting Heidi SQL to MariaDB

  • Open firewall on Debian to allow MariaDB port 3306.
  • Use LAN IP to connect Heidi SQL from Windows to Debian server.
  • Enter user credentials and host details in Heidi SQL for successful connection.
Connecting Heidi SQL to MariaDB
3

Configuring Laravel Project

  • Edit .env file in Laravel project to connect to MariaDB.
  • Clear cache and migrate with seed data for initial setup.
  • Seed people data in chunks for efficient database population.
Configuring Laravel Project
4

Managing Data in MariaDB

  • Login to MariaDB and count records in users, people, and edit_histories tables.
  • Test insert operations to verify database functionality.
  • View and manage data directly through Heidi SQL interface.
Managing Data in MariaDB
5

Conclusion and Next Steps

  • Successfully connected Heidi SQL to MariaDB and configured Laravel.
  • Verified data insertion and counting operations in MariaDB.
  • Next: Implement user permissions and search functionalities.
Conclusion and Next Steps
1 / 5