MySQL Databases and Users

Create, clone and remove databases and MySQL users

Databases and users on your server

The Database tab lists the MySQL databases and users on your server, and creates, copies and removes them.

Where: Servers › My Servers › your server › Database tab

01 · Databases

The Databases card lists each database with its size and number of tables. The buttons on a row:

Info

Total size, tables, total rows, the users with access, and the list of tables.

Export / Import

Download a copy, or load an SQL file. See Import and export.

Clone

Copies this database into another database that already exists. Pick the Destination Database: all its tables are dropped and replaced. A window follows the copy.

Delete

Deletes the database for good. Export it first if you may need it.

To make a new one, click + Create Database, type the Database Name (letters, numbers and underscores, starting with a letter), keep utf8mb4 (Recommended) or pick another Character Set, and click Create Database.

Want a copy under a new name? Create the empty database first, then Clone into it.

02 · MySQL Users

  1. Click + Add User.
  2. Type the Username and a strong Password.
  3. In Grant Access to Database, pick a database, or none for now.
  4. In Host, pick localhost only or Any host (%).
  5. Click Create User.

On a user's row, the grant button opens Grant Database Access: pick the database and the privileges, ALL PRIVILEGES (full access), Read/Write (SELECT, INSERT, UPDATE, DELETE) or Read Only (SELECT). The remove button deletes the user.

A user for Any host (%) can connect from outside only if the firewall lets the MySQL port through.

03 · Protected

The system databases mysql, information_schema, performance_schema and sys, and the root user, cannot be changed from this tab.

Database tab

Need more help? Check the error logs or contact support.

Opensolr Server Management Documentation