aldibier’s gists

aldibier / MySQL Root Password Recover

Last active August 17, 2017 18:03

MySQL Root Password Recover

	MySQL - Resetting a lost MySQL root password

	Article ID: 405 Last updated on August 31, 2012 Authored by: Rackspace Support

	The MySQL root password allows full access to the MySQL database and allows for all actions to be undertaken including creating new users, new databases, setting access rules and so on.

	Losing one can be a difficult issue to encounter. Luckily, resetting the root password is easy as long as you have sudo access to the Server.

	Contents
	1 Not the Server root user

aldibier / How to Create a New User and Grant Permissions in MySQL

Last active December 19, 2015 12:59

How to Create a New User and Grant Permissions in MySQL


	How to Create a New User

	Let’s start by making a new user within the MySQL shell:

	CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

	Sadly, at this point newuser has no permissions to do anything with the databases. In fact, if newuser even tries to login (with the password, password), they will not be able to reach the MySQL shell.

	Therefore, the first thing to do is to provide the user with access to the information they will need.

aldibier / How to add a user to www-data (Ubuntu)

Last active November 24, 2022 13:06

How to add a user to www-data (Ubuntu)

	Add a new user to the www-data group

	In this example, add a new user called vivek to the www-data group, enter:


	sudo useradd -g www-data vivek

	### set the password for vivek user ###
	sudo passwd vivek

aldibier / Instalación de Servidor LAMP Optimizado para Drupal

Last active December 20, 2015 14:29

Pasos de instalación para un servidor LAMP con configuraciones optimizadas para Drupal

aldibier / setup_server_drupal.sh

Created August 3, 2013 15:13

	#! /bin/bash
	# script to configure a new Drupal Server

aldibier / Comandos en Git

Last active December 22, 2015 10:19

	=== Generate SSH Keys ===

	https://help.github.com/articles/generating-ssh-keys

	=== Force git to overwrite local files on pull ===

	git fetch --all
	git reset --hard origin/master

	git fetch downloads the latest from remote without trying to merge or rebase anything. Then the git reset resets the master branch to what you just fetched.

aldibier / Instalación de un servidor Nginx+PHP-FPM Optimizado para Drupal

Last active August 29, 2015 14:00

Instalación de un servidor Nginx+PHP-FPM Optimizado para Drupal

aldibier / Instalar Apache Solr con Tomcat

Created April 27, 2014 01:47

aldibier / Instalar Jenkins en Tomcat - Ubuntu 14

Last active August 29, 2015 14:05

	Para instalar Jenkins es tan sencillo como copiar el archivo .war descargado desde http://jenkins-ci.org/ a la carpeta weapps de Tomcat

	$ wget http://mirrors.jenkins-ci.org/war/latest/jenkins.war
	$ sudo mv jenkins.war /var/lib/tomcat7/webapps/

	Ingrese a la administración web de tomcat e inicie el servicio.

	-- Importante --

	Si al iniciar el servicio dice que fallò y catalina.out le arroja un error que dice algo como lo siguiente:

aldibier / Configurando Jenkins para entorno de Trabajo en Drupal

Created August 7, 2014 18:31

	La idea es montar un servidor en Jenkins que pueda automatizar las tareas que se realizan en SeeD.

	------- ESTO ES UN BORRADOR -------

	Instalamos git y clamav

	$ sudo aptitude install git-core clamav-daemon

Aldibier aldibier