![]() ![]() The default setting for each Flix server is 70 connections to the MySQL database. The default setting in MySQL is to allow 150 total connections from all Flix servers combined. If you use more than 2 Flix servers, you should configure the MySQL server (recommended) or the Flix servers to allow for all configured connections to take place. GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY 'password' WITH GRANT OPTION If you are still having problems connecting from remote servers, you can open access manually with the following commands: mysql -uroot -p If have more than a single Flix server running on the same system, do not disallow root login remotely. The test database is not used by Flix so you can remove it.įor the new changes to take effect you should reload the privilege table. MySQL requires the password to be at least 8 characters long, and have an upper and lower case letter, a number, and a special character.įor security reasons it is advised to remove anonymous users, Flix doesn't make use of anonymous users. You can change the password to something that fits your studio password security guidelines. To create your own custom password for the database and update the security settings for MySQL you will need to run: mysql_secure_installation ![]() Make a note of this password, you will need it to log into MySQL. A temporary password is set, which can be revealed by running the following command in a terminal: sudo grep password /var/log/mysqld.log Once MySQL 5.7 has been installed, a root account is automatically created to access the database. 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 The status of the service can then be checked with the following command in a terminal: sudo service mysqld status Once the installation is done, the server can be started by entering the following command in a terminal: sudo service mysqld start Once this has been installed, you can install MySQL 5.7 with the following command in a terminal: sudo yum install mysql-community-server -nogpgcheck To do this, use the following command in the terminal prompt. ![]() As this version of MySQL is not currently supported, you will need to install MySQL 5.7 repo first and then the MySQL 5.7 server. The default MySQL version in Red Hat/CentOS 7 is MySQL 8. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |