MariaDB Installation: Difference between revisions
Jump to navigation
Jump to search
(→Mac) |
|||
| Line 43: | Line 43: | ||
==Post-Install Configuration== | ==Post-Install Configuration== | ||
Immediately after installation, start the database as described in [[]]. | Immediately after installation, start the database as described in [[#To_Start_at_Boot|To Start at Boot]] and run <code>mysql_secure_installation</code>. | ||
As configured by the initial installation, the script has to be run by root, which authenticates itself using system credential. In consequence, <code> mysql_secure_installation</code> must be used as <code>sudo</code>: | |||
<syntaxhighlight lang='bash'> | |||
sudo /opt/brew/bin/mysql_secure_installation | |||
</syntaxhighlight> | |||
==To Start When Needed== | ==To Start When Needed== | ||
Revision as of 04:29, 29 December 2023
Internal
Linux
Prerequisites
- The host name should be resolvable with resolveip.
RHEL 7
yum install -y mariadb-server mariadb
⚠️ After installation, makes sure you go through the post install steps, described below.
Post-Install
Uninstallation
Uninstallation with state removal:
systemctl stop mariadb.service
systemctl disable mariadb.service
yum remove mariadb-server mariadb
# remove data
rm -r /var/lib/mysql
# remove logs
rm -r /var/log/mariadb
rm -r /var/run/mariadb
Mac
brew install mariadb
Post-Install Configuration
Immediately after installation, start the database as described in To Start at Boot and run mysql_secure_installation.
As configured by the initial installation, the script has to be run by root, which authenticates itself using system credential. In consequence, mysql_secure_installation must be used as sudo:
sudo /opt/brew/bin/mysql_secure_installation
To Start When Needed
To run on demand:
/opt/brew/opt/mariadb/bin/mysqld_safe --datadir\=/opt/brew/var/mysql
To Start at Boot
brew services start mariadb