MySQL

How To Use MySQL with Your Ruby on Rails Application on CentOS 7 — step-by-step Linux tutorial on Progressive Robot

How To Use MySQL with Your Ruby on Rails Application on CentOS 7

Ruby on Rails uses sqlite3 as its default database, which works great in many cases, but may not be sufficient for your application. If your application requires the scalability, centralization, and control (or any other feature) that a client/server SQL database, this tutorial will show you how to do just that, with MySQL, on CentOS 7 or RHEL.

Read more
Создание нового пользователя и предоставление прав в MySQL — step-by-step Databases tutorial on Progressive Robot

Создание нового пользователя и предоставление прав в MySQL

MySQL — это мощная система управления базами данных, используемая для организации и поиска данных. В этом руководстве мы поговорим о том, как создавать новых пользователей MySQL и предоставлять им соответствующие права.

Read more
Como Gerenciar um Banco de Dados SQL — step-by-step Databases tutorial on Progressive Robot

Como Gerenciar um Banco de Dados SQL

Os bancos de dados SQL vêm instalados com todos os comandos necessários para adicionar, modificar, excluir e consultar seus dados. Este guia de consulta rápida fornece uma referência para alguns dos comandos SQL mais usados. **Como…

Read more
How To Create An Off-Site Backup Of Your Site With Rsync On Centos 6 — step-by-step Linux tutorial on Progressive Robot

How To Create An Off-Site Backup Of Your Site With Rsync On Centos 6

This article provides a quick way to backup the most common things in a typical web hosting scenario: website files and database data. We will setup a full daily backup of a website folder and a copying of this data to a remote server (this can also work for another VPS). We will also set up a rsync example to just copy the incremental changes. Finally, we’ll set up backup of a MySQL database.

Read more
How To Install an Apache, MySQL, and PHP (FAMP) Stack on FreeBSD 10.1 — step-by-step Linux tutorial on Progressive Robot

How To Install an Apache, MySQL, and PHP (FAMP) Stack on FreeBSD 10.1

A FAMP stack, which is similar to a LAMP stack on Linux, is a group of open source software that is typically installed together to enable a FreeBSD server to host dynamic websites and web apps. FAMP is an acronym that stands for FreeBSD (operating system), Apache (web server), MySQL (database server), and PHP (to process dynamic PHP content).

Read more
CHAT