Installing MySQL Database Server¶
Install and set up the database for use by the Mattermost server. You can install either MySQL or PostgreSQL.
To install MySQL on RHEL 8:
- Log in to the server that will host the database, and open a terminal window.
- Install MySQL.
sudo yum install mysql-community-release
- Start the MySQL server.
sudo systemctl start mysqld.service
- The first time that you start MySQL, the superuser account
'root'@'localhost'is created without a password.
- Also the first time that you start MySQL, the
validate_passwordplugin is installed. The plugin forces passwords to contain at least one upper case letter, one lower case letter, one digit, and one special character, and that the total password length is at least 8 characters.
- Change the root password. Login with the the command below. Since the password is blank by default just press ENTER when prompted for a password.
mysql -u root -p
- Change the password. At the prompt, type the following command. Be sure to replace
Password42!with the password that you want to use:
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'Password42!';
- Set MySQL to start automatically when the machine starts.
sudo systemctl enable mysqld
- Create the Mattermost user mmuser.
mysql> create user 'mmuser'@'%' identified by 'mmuser-password';
- Use a password that is more secure than ‘mmuser-password’.
- The ‘%’ means that mmuser can connect from any machine on the network. However, it’s more secure to use the IP address of the machine that hosts Mattermost. For example, if you install Mattermost on the machine with IP address 10.10.10.2, then use the following command:
mysql> create user 'mmuser'@'10.10.10.2' identified by 'mmuser-password';
- Create the Mattermost database.
mysql> create database mattermost;
- Grant access privileges to the user mmuser.
mysql> grant all privileges on mattermost.* to 'mmuser'@'%';
With the database installed and the initial setup complete, you can now install the Mattermost server.