The easiest way to a database
Databases are the "memory" of your website. Whether it's blog posts, customer passwords, or shop orders – everything is stored here efficiently. The MySQL Database Wizard guides you safely through the process so that you don't forget any important settings (such as user privileges).
Instructions: Setup in 4 steps
Step 1: Name the database
Enter a name for your database.
Note: The full name is always username_databasename. Make sure to remember this prefix!
Enter a name for your database.
Note: The full name is always username_databasename. Make sure to remember this prefix!
Step 2: Create a user
Specify a database user and assign a strong password.
Specify a database user and assign a strong password.
Pro Tip: Use the Password Generator. You don't need to memorize database passwords, as they are only entered once into your website's configuration file (e.g., wp-config.php).
Step 3: Assign privileges
Choose what the user is allowed to do. For standard applications (WordPress, Joomla, etc.), simply check the box "ALL PRIVILEGES".
Choose what the user is allowed to do. For standard applications (WordPress, Joomla, etc.), simply check the box "ALL PRIVILEGES".
Step 4: Completion
The system confirms the successful connection. You can now use the data in your web application.
The system confirms the successful connection. You can now use the data in your web application.
Useful facts about names & limits
Depending on the system, there are different limits for the length of usernames (including prefix):
| System | Limit | Example |
|---|---|---|
| MySQL 5.7 | 32 characters | user_mysuperdb |
| MariaDB | 47 characters | user_anextremelylongname |
Avoid special characters: Use only letters, numbers, and underscores for database and usernames. Characters like
/ " ' ` are not allowed.Already have a database and just want to manage it?
Use phpMyAdmin or the standard MySQL Databases interface for that.
