NavigationContentFooter
Jump toSuggest an edit

How to create a MySQL database

Reviewed on 12 February 2024Published on 05 August 2021
Important

This documentation describes the usage of a previous web hosting offer proposed by Online.net.
Refer to the Scaleway Web Hosting documentation for information about the current web hosting product.

Before you start

To complete the actions presented below, you must have:

  • A Dedibox account logged into the console
  • Created a Webhosting Classic
  1. From your Dedibox console, click Hosting. A list of your webhosting accounts displays.
  2. Click Manage next to the hosting you want to configure. The webhosting overview page displays.
  3. Click MySQL databases in the side menu. The list of your databases displays.
  4. Click Add database. A pop-up displays.
  5. Enter the database name, the database password, and its confirmation. Then click Create MySQL database.
    Tip

    For a strong password, combine lowercase, uppercase, numbers, and special characters.

Your database is created and displays in the list of your MySQL databases.

Limitations

Databases are not hosted in the local storage of Webhosting services.

However, to ensure the best performance of the SQL servers, we have defined limits for the sizes of the databases:

  • Maximum size of a table: 1 GB for all offers.
  • Maximum number of tables in a database: 2,000 for all offers.
  • Number of simultaneous requests: 3 requests for the Personal offer, 50 requests for the Pro offer, 75 requests for the Business offer.
Important

Databases that exceed these quotas are automatically blocked. You will not be able to add additional data or update them. Only the options to view and delete data remain active.

If you reach these limits and are unable to use your database, you can connect to the MySQL shell in the administration interface to check the size of your databases and manage your data to reduce usage.

See also
How to configure PHPHow to change the password of a MySQL database
Docs APIScaleway consoleDedibox consoleScaleway LearningScaleway.comPricingBlogCarreer
© 2023-2024 – Scaleway