Sunday, November 30, 2014

Installing MySql on Pìdora 2014

Pidora 2014
Apache HTTPD
MySQL 5.5.28


Status:

  • 20141130 Working on it.
  • 20141207 It's working.
ToDo:
  • Import robot database in to this server.
Installing:
  • Install MySql from old repository (fc18):
  • Downloads:
  • cd ~/Downloads
  • wget http://pidora.ca/pidora/releases/18/packages/armv6hl/os/Packages/m/mysql-server-5.5.28-1.fc18.armv6hl.rpm
  • wget http://pidora.ca/pidora/releases/18/packages/armv6hl/os/Packages/m/mysql-5.5.28-1.fc18.armv6hl.rpm
  • wget http://pidora.ca/pidora/releases/18/packages/armv6hl/os/Packages/m/mysql-libs-5.5.28-1.fc18.armv6hl.rpm
  • Login as root:
  • cd ~/Downloads
  • yum install perl-DBD-MySQL.armv6hl (mariadb and mariadb-server does not work)
  • rpm -i mysql-libs-5.5.28-1.fc18.armv6hl.rpm
  • rpm -i mysql-5.5.28-1.fc18.armv6hl.rpm
  • rpm -i mysql-server-5.5.28-1.fc18.armv6hl.rpm
  • Activate service and start mysql:
  • chkconfig mysqld on
  • service mysqld start

Testing:

  • Change mysql root password:
  • mysql
  • UPDATE mysql.user SET Password=PASSWORD('123456') WHERE User='root';


References:
MariaDB vs. MySQL