Blog: Settings


Add a new blog
April 17

Remove or revoke DB access or privileges from mysql user both local and remote

Remove or revoke DB access or privileges from mysql user both local and remote:

REVOKE ALL PRIVILEGES ON *.* FROM 'plugins_dbuser'@'localhost';

REVOKE ALL PRIVILEGES ON *.* FROM 'plugins_dbuser'@'%';

April 15

Update a column value, replacing part of a string

here is how we can replace partial of the string on all rows in MySQL: 

UPDATE my_table_name
SET my_field_name = REPLACE(my_field_name, 'unwanted-string', 'new-string');

March 9

Rsync (Remote Sync)

Basic syntax of rsync command

# rsync options source destination

Some common options used with rsync commands

-v : verbose

-r : copies data recursively (but don’t preserve timestamps and permission while transferring data

-a : archive mode, archive mode allows copying files recursively and it also preserves symbolic links, file permissions, user & group ownerships and timestamps

-z : compress file data

-h : human-readable, output

February 9

MySQL - Merge two user groups users into one current group, and delete the second group.

Merge two user groups users into one current group, and delete the second group.
Note: some users might be in both groups already.

# Show users in groupID 111 are also in groupID 222

SELECT user_id FROM user_group 
WHERE user_group_id={111} AND user_id IN (SELECT user_id FROM user_group WHERE user_group_id={222} ) 

# Change user_group_id 222 to 111. Use 'UPDATE IGNORE'  assume user_id & user_group_id are unique index

UPDATE IGNORE user_group 

December 27

Website loading speed tester

Test your website loading speed world wide:

December 6

Git tagging

To create a tag on your current branch, run this:

git tag 

If you want to include a description with your tag, add -a to create an annotated tag:

git tag -a

This will create a local tag with the current state of the branch you are on. When pushing to your remote repo, tags are NOT included by default. You will need

December 6

Git branch

You’ve decided that you’re going to work on feature_12 as an example. To create a new branch and switch to it at the same time, you can run the git checkout command with the -b switch:

$ git checkout -b feature_12
Switched to a new branch "feature_12"

This is shorthand for:

$ git branch feature_12
$ git checkout feature_12

After you are done with

November 7

Swift Basic Series

Swift 1 - Requirements

October 24

How to Manage File and Folder Permissions in Linux

Command line: File permissions

The commands for modifying file permissions and ownership are:

chmod – change permissions

chown – change ownership.

chmod – the command to modify permissions R – this modifies the permission of the parent folder and the child objects within ugo+rw – this gives User, Group, and Other read and write access.

The breakdown of permissions looks like this:

u – user g – group o –

Experteer's Scripting: Coding - Experts Only
Send us a message. We will reply as soon as we can.