MariaDB
This tool will install and start a MariaDB server which can be used with the MySQL Community Server database plugin in Xojo. Selecting MariaDB / MySQL from the Tools list will check the version the package manager will install. Click "Install MariaDB" to install the version available.
Once installed, Lifeboat can create superusers. To add a superuser click the [ + ] button below the user list. To allow a user to connect remotely set the Host to "%" (the default value for the field). To remove a user, select the username and click the [ - ] button below the user list.
Click the "Options" button to configure whether or not the MariaDB server can be accessed externally. Enabling external access will open the MariaDB port with the firewall that Lifeboat installed. Be sure any external firewalls allow port 3306 as well.
Connecting with Xojo
To connect to the MariaDB server in Xojo, use a Host of 127.0.0.1. This will force connection through TCP/IP rather than a socket or pipe. This is how the default configuration for MariaDB is installed. To change these kinds of details, you will need to connect and configure MariaDB manually.
var db as new MySQLCommunityServer
db.Host = "127.0.0.1"
db.DatabaseName = "Database"
db.UserName = "Username"
db.Password = "Password"
try
db.Connect
Print("Connected")
catch ex as DatabaseException
Print("Failed")
Print(ex.Message)
end try
Why this version of MariaDB?
The version of MariaDB that Lifeboat will offer to install is dictated by the package manager for the Linux system. The MariaDB version will vary from flavor to flavor.
| Linux Flavor | MariaDB |
|---|---|
| CentOS 7 | 5.5 |
| Debian 9 | 10.1 |
| Debian 10 | 10.3 |
| Debian 11 | 10.5 |
| Debian 12 | 10.11 |
| Ubuntu 18.04 | 10.1 |
| Ubuntu 20.04 | 10.3 |
| Ubuntu 22.04 | 10.6 |