Create a ticket
Follow

Q100551: Installing MySQL 5.7 on Red Hat/CentOS 6/7

SUMMARY

This article describes the setup process for the MySQL 5.7 database backend to be used with Flix 6.

MORE INFORMATION

Flix 6 uses a MySQL database to store information about your shows and sequences.

This article will explain the steps for a successful MySQL 5.7 installation on a Red Hat/CentOS 6/7 server, which is a prerequisite for your Flix 6 setup.

The default MySQL version in Red Hat/CentOS 7 is MySQL 8. As this version of MySQL is not currently supported, you will need to change it to 5.7.

To do this, use the following command in the terminal prompt.

 

On Red Hat/CentOS 7:

 

sudo yum localinstall https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm

  

On Red Hat/CentOS 6:

sudo yum localinstall https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm

 

Once this has been installed, you can install MySQL 5.7 with the following command in a terminal:

 

sudo yum install mysql-community-server

 

Once the installation is done, the server can be started by entering the following command in a terminal:

 

sudo service mysqld start

 

The status of the service can then be checked with the following command in a terminal:

 

sudo service mysqld status

 

You can configure the mysqld service to start on bootup, so if your server is restarted you don’t have to manually start it each time:

 

sudo chkconfig mysqld on

 

Once MySQL 5.7 has been installed, a root account is automatically created to access the database. A temporary password is set, which can be revealed by running the following command in a terminal:

 

sudo grep password /var/log/mysqld.log

 

Make a note of this password, you will need it to log into MySQL. To create your own custom password for the database, you will need to connect to the MySQL terminal from the server shell using the following command:

 

mysql -u root -p 

 

You will get a prompt asking you for the root password. The temporary password which you got in the previous step should be used. Once logged into MySQL successfully, the shell prompt will change to the MySQL terminal prompt which looks like this:

 

 

From here you can run MySQL commands. To create a permanent password for the root user you should type:

 

ALTER USER 'root'@'localhost' IDENTIFIED BY '[NEW PASSWORD]';

 

Note: [NEW PASSWORD] should be the password you want to set for the MySQL root user.

Make a note of the new password, as you will need it when configuring Flix Server later on.

 

By default, MySQL denies login as root from remote machines. If you have more than one Flix server or the MySQL server is not running on your Flix server, you will either need to create another account for Flix to use, or allow the root user to connect from a remote system. To allow the root user to connect from a remote system you need to run the following in the MySQL terminal prompt:

 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY ‘[NEW PASSWORD]’ WITH GRANT OPTION; FLUSH PRIVILEGES;

 

Where [NEW PASSWORD] is the new password you set for the root user in MySQL. You can leave the MySQL terminal by typing:

 

exit

 

You can try to log in again to MySQL to make sure your new password has been updated by typing again:

 

mysql -u root -p

 

You will get a prompt asking you for the password, you should type your new password. Your MySQL 5.7 database install should now be ready to integrate into your Flix 6 environment.

All you will need to configure Flix Server to work with your new MySQL database is the username (‘root’, in our example), the password for that user, and the hostname or IP address of the server on which the MySQL database is running. You will also need to make sure there is no firewall blocking the connection between the Flix 6 server and the MySQL database.

 

FURTHER READING

You can find out how to open your firewall ports by reading this KB article Q100474-Opening-ports-on-your-firewall-for-Flix-communication 

 

Was this article helpful?

We're sorry to hear that

Please tell us why
1 out of 1 found this helpful