MySQL

MySQL Database Server

If you want to customize your database there is an optional pbase-preconfig-mysql rpm. Either the platform default version is installed with the pbase-mysql. Or you may select version from the pbase-mysql80community repository. Also provided is the the pbase-adminer rpm to install the Adminer database tool.

Shown first below is installing MYSQL using the default repo.

yum -y install https://pbase-foundation.com/pbase-repo.rpm
yum -y install pbase-preconfig-mysql
yum -y install pbase-mysql

MYSQL 8.0 - using the MySQL Community repo

yum -y install https://pbase-foundation.com/pbase-repo.rpm
yum -y install pbase-preconfig-mysql80community
yum -y install pbase-mysql80community

MYSQL 8.0 - using the MySQL Community repo - on CentOS 8 only

yum -y install pbase-preconfig-mysql80community
yum -y --disablerepo=appstream install mysql-community-server
yum -y install pbase-mysql80community

The Adminer database Web UI

yum -y install pbase-adminer

Configuration Options

The pbase-preconfig-mysql rpm creates a sample configuration file that can be customized:

{
  "pbase_mysql": [
    {
      "default": {
        "hostName": "localhost",
        "rootPassword": "SHOmeddata",
        "port": "3306",
        "characterSet": "utf8mb4",
        "startService": true,
        "install": true,
        "database": [
          {
            "name": "app_db",
            "user": "appuser",
            "password": "shomeddata"
          }
        ]
      }
    }
  ]
}

The pbase-preconfig-mysql80community rpm creates a sample configuration file that can be customized:

{
  "pbase_mysql80community": [
    {
      "default": {
        "hostName": "localhost",
        "rootPassword": "SHOmeddata",
        "port": "3306",
        "characterSet": "utf8mb4",
        "startService": true,
        "install": true,
        "database": [
          {
            "name": "app_db",
            "user": "appuser",
            "password": "shomeddata"
          }
        ]
      }
    }
  ]
}

More about MySQL

Read more about the MySQL database server at:
https://www.mysql.com/