Anthony IT SolutionsAnthony IT SolutionsHigh quality hosting service
My Account|| [email protected]
Beginner 15 min

Create a MySQL database

Create MySQL database and user for WordPress, PrestaShop or PHP application on web hosting.

#MySQL#Database#WordPress#Panel

Ready to start your service? Check offers and order online.

View offers and order

Create a MySQL database

WordPress, PrestaShop and most PHP CMS require a base MySQL or MariaDB. On theweb hosting Anthony IT Solutions, create databases and users from the panel in a few clicks.

Each base is isolated with a dedicated user, good practice of security on shared hosting.

In summary Panel → MySQL databases → create base + user → associate privileges → note logins for wp-config.php.

What you need

  • Offer web hosting with MySQL
  • Panel
  • Quota bases available
  • Desired base name (auto prefix possible)

Create the database

  1. Panel

    My Services → Manage → MySQL Databases.

  2. New base

    Name ex. wp_prod, prefix account added.

  3. Charset

    utf8mb4_unicode_ci for emojis WordPress.

  4. Limit

    Max number according to formula.

Create User

  1. User

    Unique name, strong password (20+ car.)

  2. Host

    localhost Almost always on mutualized.

  3. One user per base

    Avoid reusing even use anywhere.

  4. Note

    Copy IDs to mdp manager.

Assigning Privileges

  1. Link user to base

    Any privileges on this basis only.

  2. No global GRANT

    Forbidden on mutualized.

  3. Test phpMyAdmin

    phpMyAdmin connection.

  4. Revoke

    Remove user if base deleted.

Configure CMS

  1. WordPress

    DB_NAME, DB_USER, DB_PASSWORD, DB_HOST in wp-config.

  2. PrestaShop

    Assistant install or parameters.php.

  3. Existing import

    import dump SQL.

  4. Prefix tables

    wp_ custom to install.

Maintenance

  • Regular backups, safeguards
  • Optimize monthly tables
  • Watch size, quotas
  • Do not publicly expose phpMyAdmin
  • **Security**, see detailed procedures.

Troubleshooting

  • Access denied, Unbound user or bad mdp.
  • Too many connections, Scripts without connection closure.
  • Base already exists, Choose another name.
  • Quota bases, Upgrade or delete test base.

Frequently Asked Questions

MariaDB or MySQL?
MariaDB compatible MySQL, same procedure.

Several WordPress bases?
One database per site recommended.

Remote MySQL ?
Non standard shared, API/local application.

Max base size ?
Includes global disk quota.

Related guides

See also our web hosting offer and all the procedures on wiki web hosting.