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

See the plans
Databases1 min readUpdated

Databases and database users

Create a database, add users with access to exactly the databases they need, reset a password.

Databases belong to an application. Each database user gets access to exactly the databases you choose, nothing else.

Databases tab: host and port, the databases with their size, and the users with their access.
Databases tab: host and port, the databases with their size, and the users with their access.
ActionNotes
Create a databaseUTF8MB4, the right character set for every modern store. Optionally with a user that has full access to it.
Create a userChoose its databases and its access level.
Reset passwordA new password is generated (or set your own) and shown once.
Delete a databaseDrops it. Users keep existing but lose access to it.
Allow remoteLets this user connect from outside the server, once MariaDB is open to the outside (see Remote MySQL).

Applications connect to localhost, port 3306. The connection details of a store are in its configuration file (app/etc/env.php, wp-config.php or .env).

Deleting a database cannot be undone except from a backup. Download it first if you are not sure.

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
Remote MySQL accessOpen MariaDB to your office, an ERP or a reporting tool, only from the addresses you allow, user by user.1 min readImport or export a large databaseCommands for dumps and imports over SSH that work for databases of any size, and the safe way to replace a store's database.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