Shared Hosting for Everyone, imagined by developers, for developers.Discovering the Public Cloud
|Port||3306 (MySQL port by default)|
The connection data depends on the relevant account. You can find the precise values in the administration interface section under Databases > MySQL.
In our example, we use the SSH access and consider the following information:
foofor the foo account).
foo@ssh:~$ mysql -h mysql-foo.alwaysdata.net -u foo -p foo_base
When you create your MySQL databases and users, you have the option of assigning the following permissions:
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.
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.
The maximum number of simultaneous connections per user is 40. On request, it is possible to change this for VPS and dedicated servers.
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.
An ANALYZE TABLE is carried out daily on all your tables to guarantee good performance, but don’t hesitate to do it yourself when your data changes drastically, for example after importing a database.
To check the MariaDB configuration use the SQL query
MySQL events are not supported on alwaysdata’s servers.
In the public Cloud, 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.