Creating a MySQL server

Warning

Please note that the MySQL server caching_sha2_password plugin isn’t supported by Fudo PAM. Supportable MySQL plugins by Fudo PAM 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. Select Management > Servers.
2. Click Add and select Static server.

3. Enter server’s unique name.
4. Enter optional description, which will help identifying this server object.

5. Select Blocked option to disable access to server after it’s created.

6. Select MySQL from the Protocol drop-down list.
7. From the Bind address drop-down list, select Fudo PAM 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.

8. In the Permissions section, add users allowed to manage this object.

9. Click an Add host button in order to add address(es) into the Server adresses section.

• Enter server’s IP address and port number.

10. Click Save.

Related topics:

• Data model
• System initiation
• Users
• Listeners
• Safes
• Accounts