lemajes’s gists

lemajes / mysql-root-passwd-reset.md

Last active July 17, 2023 00:23

[Reset MySQL Root Passwd] Reset MySQL Root Password #linux #script #mysql #server #password #reset

Reset password for root user

service mysql stop
mysqld_safe --skip-grant-tables &
mysql
UPDATE mysql.user SET Password=PASSWORD('NEW-PASSWORD') WHERE User='root';
# if not working, try: ALTER USER 'root'@'localhost' IDENTIFIED BY '1234'; #without mysql on debug mode ;)
FLUSH PRIVILEGES;
exit;
mysqladmin -u root -p shutdown

lemajes / enable-root-passwordless-mysql.sh

Created July 27, 2018 12:30

[Root Passwordless Mysql] Enable Passwordless Authentication for root user on mysql-server #linux #script #mysql #server #root #passwordless

	#!/bin/bash
	echo -e "[client]\npassword = P4$$WORD" > /etc/my.cnf

lemajes / wordpress-database-healer.sh

Last active August 14, 2018 16:08

[Wordpress Database Healer] Heal wordpress database by changing all urls to a new one #linux #script #mysql #wordpress #migration #maintenance #database

	#!/bin/bash
	DATABASE=""
	DB_TO_INJECT=""
	URL1=""
	URL2=""

	mysql $DATABASE < $DB_TO_INJECT
	mysql $DATABASE -e "UPDATE wp_users set user_email=replace(user_email, '$URL1', '$URL2');"
	mysql $DATABASE -e "UPDATE wp_postmeta set meta_value=replace(meta_value, '$URL1', '$URL2');"
	mysql $DATABASE -e "UPDATE wp_posts set guid=replace(guid, '$URL1', '$URL2');"

lemajes / wordpress-create-database.sh

Last active July 27, 2018 14:05

[Wordpress Create Database] Create new Wordpress database #linux #script #bash #wordpress #database #create #new

	#!/bin/bash
	DBNAME=""
	USER=""
	PASS=""

	CREATE DATABASE $DBNAME CHARACTER SET 'utf8';
	GRANT ALL PRIVILEGES ON $DBNAME.* TO '$USER'@'localhost' IDENTIFIED BY '$PASS';

lemajes / wordpress-pass-changer.sh

Last active February 21, 2020 10:08

[Wordpress User Password Changer] Update a wordpress user's password #linux #script #mysql #wordpress #update #user #password

	#!/bin/bash
	DATABASE=""
	ID=""
	PASSWORD=""
	mysql $DATABASE -e "SELECT ID, user_login, user_pass FROM wp_users;"
	mysql $DATABASE -e "UPDATE wp_users SET user_pass=MD5('$PASSWORD') WHERE ID = $MYID;"

	# change passwords of admin en-masse
	```
	#!/bin/bash

lemajes / sage-wp-builder.sh

Created July 30, 2018 10:31

[Build Roots/Sage WP Theme] Builder script for the roots/sage wordpress starter theme #linux #script #wordpress #yarn #composer

	#!/bin/bash
	WPFOLDER=
	cd $WPFOLDER
	cd wp-content/themes
	composer create-project roots/sage mir
	cd mir
	composer install
	yarn && yarn build

lemajes / roots-sage-deployer.txt

Last active August 6, 2018 10:20

[Deploy Roots/Sage Wordpress Theme] deploy roots sage theme

	MIR Sage Wordpress/Woocommerce template
	MIR Wordpress Template is based on Sage 9.0.1 Boilerplate and customized for Woocommerce 3.4.X by Sage9-Woocommerce-Integration X Hivemind @mtx-z.

	Environment requirements

	Make sure all dependencies have been installed before moving on:



	PHP >= 7.1.3 (with php-mbstring enabled)

lemajes / wp-cli-password-updater.sh

Created July 31, 2018 10:04

[Change Wordpress User Password] Change Wordpress user password throught wp-cli utility #linux #script #wp-cli #user #password #wordpress

	#!/bin/bash
	USER_PASS=""
	wp --allow-root --path=/home/sites/site user update user --user_pass=$USER_PASS

lemajes / deb-package-creator.sh

Created August 2, 2018 09:17

[Deb Package Creator] Create Deb package from make #linux #script #make #compilation #packaging #checkinstall

	#!/bin/bash
	FOLDERPATH=""
	cd $FOLDERPATH
	./configure
	make
	checkinstall

lemajes / softether-client-connector.sh

Last active August 2, 2018 19:30

[Softether Client Account Creator] Create and connect a SoftEther VPN Client under Debian #linux #script #softether #client #connect

	#!/bin/bash
	SOFTETHERPATH=""
	ADAPTERNAME=""
	ACCOUNTNAME=""
	SERVER=""
	HUB=""
	USERNAME=""
	PASSWORD=""
	NICKNAME=""

Majes lemajes