GigaGlobe

Categories

Managing MySQL Databases

0 Was this answer helpful?

MySQL databases store the dynamic content for your websites and applications (posts, users, products, etc.).

Creating a Database

  1. Log in to DirectAdmin.
  2. Navigate to Account Manager > MySQL Management.
  3. Enter a name for your new database.
  4. Create a database user with a strong password.
  5. Assign the user to the database with appropriate privileges.
  6. Click Create.

Managing via phpMyAdmin

  1. Click phpMyAdmin from the MySQL Management page.
  2. Select your database from the left sidebar.
  3. Use the tabs to browse tables, run SQL queries, import, or export data.
Connection Details: When configuring your application, use localhost as the database host. The database name and user will be prefixed with your DirectAdmin username (e.g., username_dbname).

Regular database backups are recommended. See our guide on exporting databases for instructions on creating manual backups.


Was this answer helpful?
« Back
Hi there! How can we help?
Chat with us