New One-click installs: WordPress, WooCommerce, Mage-OS and PrestaShop on any server

See the plans
Databases1 min readUpdated

Remote MySQL access

Open MariaDB to your office, an ERP or a reporting tool, only from the addresses you allow, user by user.

MariaDB only listens on the server itself by default. When a tool on your computer or another server needs the database, open it here: to specific addresses (recommended) and only for the users that need it.

  1. Open MariaDB

    Databases tab, Remote MySQL access: enter the addresses or ranges that may connect (for example 203.0.113.7 198.51.100.0/24) and press Open MariaDB.

  2. Allow the user

    On the database user, press Allow remote. A twin of the user that may connect from outside is created with the same password.

  3. Connect

    Host: the server's IPv4 address. Port 3306. The user and its password.

Remote MySQL access below the databases, Local only until you open it.
Remote MySQL access below the databases, Local only until you open it.

Leaving the address list empty opens port 3306 to the whole internet. Database servers are scanned constantly; always list your addresses.

To close it again press Local only, and remove remote access per user with the same button.

Did this solve it? If not, tell us what you see and we look at your server.

Open a ticket

Keep reading

All 4 guides
Databases and database usersCreate a database, add users with access to exactly the databases they need, reset a password.1 min read

Still stuck? Ask a person.

Tickets go straight to the engineers who run ShopWhizzy servers. Tell us the store, what you see and when it started, and we take it from there.

Open a ticket Help center