MariaDB / MySQL

Connection

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.

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 documentation
• MySQL documentation