MySQL Databases
We run Percona for MySQL 8.4 on our web servers (shared hosting and limeDEDICATED Managed Webservers). This is the standard MySQL version (with enterprise features from Percona), not the also quite popular MariaDB.
Databases
This is where you manage your MySQL databases. You can create an unlimited number of databases. The server creates a user with the same name for each database, to which an automatically generated password is assigned, unless you define a password yourself.
You are given a prefix for the database name, which is usually made up of your user name and an underscore web999_. The name may contain the characters a-z0-9_- and is limited to a maximum length of 26 characters.
Password
When creating a database, it's optional to provide a password. If you do not enter a password, our system will automatically generate a 12-character password. The password is then displayed here immediately (but only once!) after the database is created.
Our password requirements:
- Minimum length: 10 characters
- The password must contain at least 1 number (0-9)
- The password must contain at least 1 lower case letter (a-z)
- The password must contain at least 1 upper case letter (A-Z) or a special character
- The password must have a minimum complexity according to the Zxcvbn algorithm and must not be compromised.
Comment/Usage
The comment or intended use has no influence on your database. This information is only used as additional information and is only displayed in the list of your configured databases.
Users/Permissions
When a new database is created, a MySQL user of the same name is created, which by default is granted the full ALL PRIVILEGES to the database. However, you can click on «Edit Permissions» and restrict the rights per database/user.
You can find an explanation of the respective authorizations under Privileges Provided by MySQL.
Common use cases:
| Privileges | Description |
|---|---|
| ALL | ALL PRIVILEGES allows all changes to the database. |
| SELECT, INSERT, UPDATE, DELETE | Allows all DML (Data Manipulation Language) statements, i.e. changing the actual data, but not the table structure or indices. |
| SELECT | A maximal restricted "read-only" user who should only have read access to the database. |
If you add one or more additional users to an existing database, you can immediately select whether the user should gain ALL (all permissions) or only a restricted set of permissions.
Allocation
The current allocation of a database is calculated from the size of the data and indices it contains. There is currently no size limit per database. However, be aware that the sizes of all databases are deducted from your available web space.
The calculation of the database sizes only takes place once an hour, so the values listed may not be up to date and the available web space will only be adjusted after such a delay.
phpMyAdmin
You can manage your databases in the browser via phpMyAdmin. You can log in under https://db.onlime.ch/. The user name and password correspond to the name of the database and the associated password.
However, for a more comfortable administration of your databases, we recommend using our favorite client TablePlus, where you can access your database directly via SSH tunnel (to the web server) under localhost.
hostname
The MySQL server is always located on the same web server where your data (PHP applications) are located, i.e. you should always access your database via localhost (or 127.0.0.1).
limeDEDICATED
If you have your own limeDEDICATED server, please use pma-<your_server> for phpMyAdmin access, e.g. pma-s003.onlime.ch