FIXME Эта страница пока что не переведена полностью. Пожалуйста, помогите завершить перевод.
(Сотрите это сообщение по окончании перевода.)

Login page

To access the Web-based management interface SEPMYSQL write in browser's address bar:

http://[server IP]:4111/

and choose menu item "Login". In form you must enter the login and password for access. If the program is just installed, the use next credentials:

User name: admin
Password: admin

change admin password after entering.

User types of SepMySQL

SepMySQL users are divided to:

  1. superuser
  2. MySQL operations allowed - user, who can manage MySQL services: create, remove and etc.
  3. Rules operation allowed - user, who can manage access to MySQL services: create rule, remove rule and etc.
  4. MySQL users manipulations allowed - user, who can manipulate with data of MySQL services: move database users, add database users, remove mysql data and etc.

User right can be combined:

  • user1 - MySQL operations allowed + Rules operation allowed
  • user2 - Rules operation allowed + MySQL users manipulations allowed
  • user3 - MySQL operations allowed + Rules operation allowed + MySQL users manipulations allowed

superuser allowed for - admin - only

Allowed operations

Menu structure for SepMySQL.

  • Information
    • About
    • Install
    • Command line
  • Status
    • Services
    • MySQL
  • History
  • Users
    • Users list
    • User add
    • User del
    • Reset password
  • MySQL
    • List
    • Add
    • Del
    • Run command
    • Make backup (all)
    • Make backup (one server)
    • Make backup (one database)
    • Restore from backup
    • MySQL services management
    • Add startup MySQL parameter
    • Del startup MySQL parameter
    • CRON tasks list
    • MySQL force stop
    • Add LVE(CloudLinux) limits
    • Add limits CPU & MEM
    • Del limits
    • Limits list
    • Add startup script service
    • Del startup script service
    • List startup script service
    • Add network access
    • Del network access
    • List network access items
  • Operations
    • Move user
    • Copy database
    • Create DB user
    • Delete DB user
    • List DB users
    • Remove MySQL data
  • Rules
    • Rules list
    • Add rule
    • Del rule
    • Add smart rule
  • Configuration
    • Regenerate config file
    • Stop SEPMYSQL
    • Add licesne
    • Show license info
  • Change password
  • Logout

Superuser can access to any menu group.

For users MySQL operations allowed available next menu groups:

  • Information
  • Status
  • MySQL
  • Change password
  • Logout

For users Rules operation allowed available next menu groups:

  • Information
  • Status
  • Rules
  • Change password
  • Logout

For users MySQL users manipulations allowed available next menu groups:

  • Information
  • Status
  • Operations
  • Change password
  • Logout

SepMySQL description

Display information about services sepmysql and sepmysql-watcher. This is two main services, the first is responsible for the rules and engaged in dispatching requests, the second is responsible for launching and tracking services MySQL.

Display information about started MySQL services, controlled by SepMySQL.

Display history of all last operations in SepMySQL.

Show available users list of SepMySQL and rights for them.

Add new user for SepMySQL. Allowed fields:

  • User name(login) - new user's name
  • Password - new user's password
  • User's type flags (described earlier):
  • MySQL operations allowed?
  • Rules operations allowed?
  • MySQL users manipulations allowed?

The example below shows an example of a user with rights to manipulate MySQL services and rules

Remove SepMySQL user. When selecting the specified menu item opens a list of available users. To delete a user name must be flag the column "Del" (in the figure below - a circle with the number 1) to complete the installation set the flag and press "Del" (in the figure below - a circle with the number 2).

Reset password for SepMySQL user to standard - "password".