Logo       PBase-Foundation

MySQL

MySQL Database Server

If you want to customize you 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-preconfig.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-preconfig.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"
}
]
}
}
]
}