UnixMen Blog

MariaDB is a binary drop in replacement for MySQL database server. This means that for most cases, you can just uninstall MySQL and install MariaDB and you are good to go. Why MariaDB? MariaDB is totally open source version of MySQL It works just like MySQL and is compatible with MySQL setups Fedora and Red Hat/CentOS is moving to use MariaDB from Fedora 19/RHEL 7/CentOS 7 versions This is guide,  howto install or upgrade MariaDB 10.1.20 [stable] (10.0.28 [stable] or 10.2.2 [beta] or 5.5.53 [stable]) on Fedora 25/24/23, CentOS 7.3/6.8/5.11 and Red Hat (RHEL) 7.3/6.8/5.11 . Installing MariaDB is almost same process than install MySQL. Note: If you are moving from MySQL, then make sure that you backup (dump and copy) your database and configs. And if upgrading from earlier versions, then remember run mysql_upgrade command. And if you uninstall MySQL, then remember restore /etc/my.cnf after installation, like: Bash mv -vi /etc/my.cnf.rpmsave /etc/my.cnf ...

To build a dynamic web application, you need what has been coined a “stack” - which is developer lingo for an integrated set of software that has all of the components your application needs. Most stacks have the same types of components and differ mainly in which pieces of software they use for those components. For example, we’ll look at LAMP (which this article covers): LAMP Software: Linux (e.g. CentOS), Apache, MySQL, PHP If you're astute, maybe you noticed that LAMP is just an acronym for the software the stack uses. In this guide, we'll walk you through installing all of these components (except for Linux, which is already installed as your OS when you create the server). Install Apache Before you begin any installation, make sure that your software is up to date: # sudo yum update Install Apache: # sudo yum install httpd Start Apache: # sudo systemctl start httpd.service Set Apache to start on server b...

MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This is guide,  howto install or upgrade MySQL Community Server latest version 5.7 (5.7.17) on CentOS 7.3/6.8/5.11 and Red Hat (RHEL) 7.3/6.8/5.11 . This guide works of course with  Oracle Linux  and  Scientific Linux  too and MySQL 5.6/5.5 installation is possible too. Note: If you are upgrading MySQL (from earlier version), then make sure that you backup (dump and copy) your database and configs. And remember run  mysql_upgrade  command. 1. Install MySQL Database 5.7.17 on Fedora 25/24/23, CentOS 7.3/6.8/5.11, Red Hat (RHEL)7.3/6.8/5.111. Change root user su - ## OR ## sudo su - 2. Install MySQL YUM repository. # CentOS 7 and Red Hat (RHEL) 7 # # yum localinstall https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm  # CentOS 6 and Red Hat (RHEL) 6 # # yum localinstall https...