Databases
Each website has its own MySQL-compatible database, and you can add more. Open the website and go to Hosting › Databases. Two tabs at the top switch between Databases and Users.
The website’s main database
Section titled “The website’s main database”The card at the top, WordPress database, shows the login the website itself uses: Database name, Database user, Host (localhost) and Password. Click the eye to reveal the password, or the copy buttons to copy any value.
Click Open Adminer to manage the database in your browser. Adminer opens in a new tab, already signed in.
The main database and its user can’t be deleted, and the user’s access to it is fixed.
Add a database
Section titled “Add a database”- On the Databases tab, click Add database.
- Type a Database name using letters, numbers,
$and_(up to 64 characters). - Click Add database.
Add a database user
Section titled “Add a database user”- On the Users tab, click Add user. You need at least one database first.
- Fill in Username, choose the Database it gets access to, and type a Password of at least 10 characters, or click Generate.
- Click Add user.
Change who can use a database
Section titled “Change who can use a database”Click an added database to manage it. Under User access, choose each user’s level:
- None
- Read Only
- Read & Write Only
- Full
- Custom, to pick the exact permissions.
Import or export an added database
Section titled “Import or export an added database”On the same page:
- Import SQL file: click Choose file, pick a
.sqlfile up to 500 MB, then click Import. Netkeel takes a safety backup first and imports in the background. Follow it in the activity panel. - Export SQL file: click Download to get the database as a
.sqlfile.
To move the main database’s content in or out, use backups or Hosting › Import & export.
Reset a user’s password
Section titled “Reset a user’s password”On the Users tab, click a user, type a New password or generate one, and click Update password. For the website’s own database user, Netkeel writes the new password into the website’s configuration in the same step, so the website keeps working.
Delete a database or user
Section titled “Delete a database or user”Open the menu on an added database or user and choose Delete database or Delete user.