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.
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
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.