MariaDB / MySQL

Discover our Public Cloud offer

Shared Hosting for Everyone, imagined by developers, for developers.

Discovering the Public Cloud

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.

Restore a database from its daily backup

Several options :

  • use our backup recovery feature,

  • use the following command :

    $ xzcat $HOME/admin/backup/[date]/mysql/[database].sql.xz | mysql -h mysql-[account].alwaysdata.net -u [user] -p [database]
    
  • get the tarbal and use the client of your choice.

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.

To check the MariaDB configuration use the SQL query show variables.

MySQL events are not supported on alwaysdata’s servers.

In shared servers, you can change sql_mode by connection (SET SESSION).

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