Shared Hosting for Everyone, imagined by developers, for developers.
Discovering the Public CloudServer | mysql-[account].alwaysdata.net |
Port | 3306 (MySQL port by default) |
Web interface | phpMyAdmin |
The connection data depends on the relevant account. You can find the precise values in the administration interface section under Databases > MySQL.
mysql
In our example, we use the SSH access and consider the following information:
foo
foo_base
foo
for 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 show variables
.
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.