<yambe:breadcrumb self="Setup Mariadb server">CentOS 8.x Cloudstack 4.15|Cloudstack 4.15</yambe:breadcrumb>

CentOS 8.x Cloudstack 4.15 Setup Mariadb server

To setup Mariadb server for using with Cloudstack 4.15 use following steps:

Initialize server using CentOS 8.x Cloudstack 4.15 Initialize infrastructure server (except optional java 11 installation)
Install mariadb server:
```
dnf -y install mariadb-server
```

Edit '/etc/my.cnf.d/mariadb-server.cnf' and under '[mysqld]' section paste:

innodb_rollback_on_timeout=1
innodb_lock_wait_timeout=600
max_connections=350
log-bin=mysql-bin
binlog-format = 'ROW'

Start and enable database using:

systemctl start mariadb
systemctl enable mariadb

Run mysql_secure_installation and set root password
```
mysql_secure_installation
```
Give grant permission to root user on all databases from any remote machine:
```
# mysql -u root -p
> grant all privileges on  *.* to 'root'@'%' identified by '<secret-root-password>' WITH GRANT OPTION;
> flush privileges;
```
Better option is to give this privilege only from cloudstack management server instead of using '%' (everywhere)

<yambe:breadcrumb self="Setup Mariadb server">CentOS 8.x Cloudstack 4.15|Cloudstack 4.15</yambe:breadcrumb>

Anonymous