MySQL Setup

VideoCache requires MySQL to store information about cached videos, maintain a queue of videos to be cached in background and other activity. We need to install and setup MySQL before we can proceed with VideoCache installation.

If you are Ubuntu, Debian, LinuxMint or on a Debian derivative OS, you can run the following command to install MySQL

[user@white-magnet ~]# apt-get install mysql-server mysql-client libmysqlclient-dev

If you are on Fedora, RHEL, CentOS or any other distro which uses Yum as package manager, you can use the following command to install MySQL

[root@white-magnet ~]# yum install mysql mysql-server mysql-devel

Once we are done with installing MySQL, we to setup a database for VideoCache. We need to use database name, user name and password for this. You can set them as per your convenience. Here are we using,

  • Database Name : videocache
  • Database Username : videocache
  • Database Password : videocache

Now, we need to use the above details to setup database for VideoCache as shown below

[root@white-magnet ~]# mysql -u root -p
Enter password:

mysql> create database videocache;

mysql> grant all on videocache.* to 'videocache'@'localhost' identified by 'videocache';

mysql> flush privileges;

Remeber the username, password and database name you used above as it’ll be required when you run install script