MariaDB / MySQL

Connection

Servermysql-[account].alwaysdata.net
Port3306 (MySQL port by default)
Web interfacephpMyAdmin

The connection data depends on the relevant account. You can find the precise values in the administration interface section under Databases > MySQL.

Example with mysql

In our example, we use the SSH access and consider the following information:

  • Account name: foo
  • Database name: foo_base
  • We will use the default SSH users and databases, i.e. the ones created when the accounts are opened (e.g. foo for the foo account).
foo@ssh:~$ mysql -h mysql-foo.alwaysdata.net -u foo -p foo_base

Permissions

When you create your MySQL databases and users, you have the option of assigning the following permissions:

  • GRANT ALL PRIVILEGES,
  • GRANT READONLY,
  • No privileges.

If you change your user’s permissions via a third party application, any validation via the administration interface (or via the API) will reset the permissions in line with the directives above.

Other informations

MySQL blocks the size of the user name; if your account’s name is too long, an ID will be assigned to it. You will find this in Databases > MySQL > Users.

MariaDB is offered by default on our servers but the VPS and dedicated client may request to use MySQL.