Creating a MySQL server

Warning

Please note that the MySQL server caching_sha2_password plugin isn’t supported by Fudo Enterprise. Supportable MySQL plugins by Fudo Enterprise are mysql_native_password and mysql_old_password. Server plugin should be set to mysql_native_password in /etc/mysql/mysql.conf.d/mysqld.cnf and a User object is created with mysql_native_password plugin.

Note

  • A server object can be linked to only one anonymous account.
  • A server object can be linked to only one forward account.
  1. Click + icon in the main menu next to the Servers tab, or

Select Management > Servers and then click + Add server.

  1. Enter server’s unique name.
  1. Select Blocked option to disable access to server after it’s created.
  2. Optionally, click the Description checkbox and provide a text that will help identifying this server object.
  1. In the Permissions section, add users allowed to manage this object.
  2. In the Settings section on the list of available protocols select MySQL .

Warning

After server’s definition is saved, protocol’s field is uneditable.

  1. From the Bind address drop-down list, select Fudo Enterprise IP address used for communicating with this server.

Note

  • The Bind address drop-down list elements are IP address defined in the Network configuration menu (Network interfaces configuration) or labeled IP addresses (Labeled IP addresses).
  • In case of cluster configuration, select a labeled IP address from the Bind address drop-down list and make sure that other nodes have IP addresses assigned to this label. For more information refer to the Labeled IP addresses topic.
  1. In the Destination section select Host, IPv4 or IPv6. Enter server’s IP address.

Note

Depending on selected option, default values for the Mask and Port fields are filled out automatically. This way the Fudo Enterprise system detects server as one with unique address. In order to set up address for entire subnet, provide a dedicated value for the Address and the Mask fields.

../../_images/5-3-servers-mysql-def.png
  1. Click Save or Save and close.

Related topics: