This article deals with the basic functioning of databases on Webhosting. If you need to export or import data, follow the instructions in Webhosting - Import and Export Database in phpMyAdmin.
In this article you will learn:
- What are the database parameters
- How to set up a database
- How database user accounts work
- How to manage the database
- How to find out the database version
- Common problems
- Frequently Asked Questions
Database parameters
You can use unlimited databases or MariaDB for each web hosting.
The basic parameters of databases on Webhosting are:
- Total database space 1 GB for LowCost ⧉, 2 GB for NoLimit &box;, 5 GB for Extra &box;)
- Creation and deletion via customer administration
- Manage via phpMyAdmin &boxbox interface ;
Creating a database
Follow the instructions below to create a database:
- Log in to the customer administration ⧉.
- In the top menu, select the Hosting Services tab Webhosting or WMS.
- Open the detail of a specific service.
- Click the New Database link in the left menu.
- Name the database (max. 7 characters without accents), select or enter the recipient of the email with a password and click the create button.
Alternatively, you can create a database directly in the Webhosting details by clicking the Create New link in the Database table.
After the database is created, the system sends the login details to the e-mail specified when setting up the service.
Database user accounts
You can only access the databases from the phpMyAdmin[pma] web interface and from VEDOS web hosting servers. The databases are not accessible from outside or from other servers, and we do not allow this access in any way.
After setting up the MariaDB database, you will receive two login credentials:
- The admin user (login name starting with a) has full rights to the database. With this username, only manage databases through the phpMyAdmin[pma] interface - unless necessary, do not connect to it from PHP.
- The web user (login name starts with the letter w) has limited rights: he can work with data, but cannot change the structure of tables. Connect this user to the database from PHP.
Each database has these 2 users fixed. For security reasons, you cannot change the permissions of these users or add new users.
When entering the database data in your PHP application, make sure to enter the following 4 data correctly (you can find them in the database setup email or in the database details in the customer administration):
- name of the database server - in the form wmX.wedos.net or mdX.wedos.net, where X is the number
- database name
- login name
- password (note any spaces before or after the password)
Database management
Changes entered in the customer administration will be reflected within 30 minutes.
You can enter the following steps to manage the database in the customer administration:
- Log in to the customer administration ⧉.
- In the top menu, select the Hosting Services tab Webhosting or WMS.
- Open the detail of a specific service.
- In the service detail, find a specific database and click the magnifying glass icon to open its detail.
You can directly in the customer administration:
To change the password of a database account
If you change the password of the user through which your application logs in to the database, enter the corresponding change in the PHP code that accesses the database through this account using the password! If you leave the old password in the code, the connection to the database will not work.
You can change the password for each database account. In the Change admin password or Change web password table in the database details, make the change and save it.
Deleting the database
Before deleting the database, we recommend backing up the data by exporting it according to this guide. Deleting the database will result in its complete and irreversible deletion, including all the data it contains.
To delete the database, type the word DELETE in uppercase letters in the Delete Database box and confirm with the Delete Database button.
After deletion, you cannot create a new database with the same name.
You can restore the data itself from your own or our backup by importing it into the newly created database. You can then connect the new database to the web application by editing its configuration.
Current version of the database
The highest possible version of MariaDB is currently 10.4.33.
If the database version is not provided by the software that uses the database, you can check the version in:
Database version in customer administration
You can get the database version (and other information about it) in the database details by following these steps:
- Log in to the customer administration ⧉.
- In the top menu, select Hosting Services Webhosting or WMS.
- Select the service whose database you want to scan from the list.
- In the service details in the Databases table, click the name of the selected database.
- In the database details, under Database server, verify the database version.
Database version in phpMyAdmin
In the phpMyAdmin interface, you can get the database version by the following procedure:
- Log in to the phpMyAdmin interface ⧉.
- Locate the database version in the Database Server panel.
Common problems
Common problems with databases include:
- Incompatible database version
- Unavailability of the database from the Internet
- User web does not have sufficient rights
- The website stopped working after modifying the database
- Accidentally deleted database
Incompatible database version
Problem: The application requires a different database type or version.
Solution: Changing the database version is not typically supported by our services.
Webhosting supports only MariaDB database. You can only run any other database system on your own server.
Unavailable database from the Internet
Problem: I can't log in to the database from an application running on another provider or on my computer.
Cause: for security reasons, access to databases on Webhosting is limited to WEDOS Webhosting and WMS services only. We do not provide exceptions to this rule.
Solution: use a Webhosting application (e.g. on a subdomain) to manage databases, or use the phpMyAdmin ⧉ interface.
Insufficient web user rights
Problem: The application does not work properly when I log in to the database as a web user.
Cause: The application needs to use administrator account commands, such as creating tables when installing the editor system.
Solution: Enter the administrator account details for the necessary time.
Broken website after database modification
Problem: After editing the database, the website stopped working.
Cause: The most common source of problems is changing the password in the administration, but not in the site configuration file. It may also be due to corruption or deletion of part of the database necessary for the site to run properly.
Solution: If you just changed the password to the database, update it in the configuration file of your application. You can find community instructions on how to modify it for common content management systems at this link ⧉. If you have changed the contents of the database and the site stopped working, import a backup.
Deleted database
Problem: We accidentally deleted the database.
Solution: there are two types of deleted databases:
- Restore deleted data from a backup.
- A deleted database (according to the instructions in the chapter Deleting the database) cannot be restored as such. Create a new database (with a new name) and restore the data from the backup to this database. Next, correct the access data in the application's configuration file(community instructions for editing in common content management systems can be found at this link ⧉).
Frequently Asked Questions
Where exactly do I set new database credentials in PHP?
It depends on your specific application. For an article on how to connect to the databases of common content management systems, see the CMS content management systems and database connection ⧉ community guide. If you are using a different application, ask your application support or your webmaster.
What is the difference in MySQL / MariaDB?
MariaDB is an offshoot of MySQL. They are compatible with each other and most CMS are fully functional with MariaDB. If your application requires MySQL, it should work reliably with MariaDB and vice versa. We already use only MariaDB on most DB servers with no option to change. If you strictly require MySQL, a VPS server could be the solution ⧉. Alternatively, contact our customer support.
How do I find out the database login details without a service setup email?
You can get them from the configuration file of your PHP application that uses the database. If this is not possible, you will need to change the password for the database. Next to the password change form, you will also find a table with a summary of database accesses.