How to grant privileges to users in MySQL 8.0

It seems, that this is a question that regularly shows up in forums or stackoverflow.

To start, let’s highlight that with MySQL 8.0 it’s not any more possible to create a user directly from the GRANT command (ERROR 1410 (42000): You are not allowed to create a user with GRANT).

This means that to grant some privileges, the user must be created first.

Let’s create a user ‘user1‘ with ‘ChangeMe‘ as password that the user will have to change:

mysql> create user 'user1' identified by 'ChangeMe' password expire;
Query OK, 0 rows affected (1.35 sec)

Let’s try to connect to MySQL using that new created user:

 $ mysql -u user1 -pChangeMe -h localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 347
Server version: 8.0.13
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>

Nothing special, we are connected as expected… but didn’t I explecitely expired the password ?

Yes I did, let’s try any statement:

 mysql> select now();
ERROR 1820 (HY000): You must reset your password using ALTER USER
statement before executing this statement.

We must change the password as expected. Let’s change it to ‘MySQL8isGreat‘:

 mysql> set password='MySQL8isGreat';
Query OK, 0 rows affected (0.34 sec)

And now we can use MySQL and do any statement we are allowed to do (that we have the privileges for).

 mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2019-01-10 14:36:05 |
+---------------------+
1 row in set (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
+--------------------+
1 row in set (0.20 sec)

It seems I don’t have access to many databases…

The default privilege is very limited:

 mysql> show grants;
+-----------------------------------+
| Grants for user1@% |
+-----------------------------------+
| GRANT USAGE ON . TO user1@% |
+-----------------------------------+
1 row in set (0.00 sec)

It’s now time to grant more privileges to our user… but what are privileges available ?

In 8.0.13, they are currently 46 privileges !

To list them all, just run:

 mysql> show privileges; 
+----------------------------+---------------------------------------+-------------------------------------------------------+
| Privilege | Context | Comment |
+----------------------------+---------------------------------------+-------------------------------------------------------+
| Alter | Tables | To alter the table |
| Alter routine | Functions,Procedures | To alter or drop stored functions/procedures |
| Create | Databases,Tables,Indexes | To create new databases and tables |
| Create routine | Databases | To use CREATE FUNCTION/PROCEDURE |
| Create role | Server Admin | To create new roles |
| Create temporary tables | Databases | To use CREATE TEMPORARY TABLE |
| Create view | Tables | To create new views |
| Create user | Server Admin | To create new users |
| Delete | Tables | To delete existing rows |
| Drop | Databases,Tables | To drop databases, tables, and views |
| Drop role | Server Admin | To drop roles |
| Event | Server Admin | To create, alter, drop and execute events |
| Execute | Functions,Procedures | To execute stored routines |
| File | File access on server | To read and write files on the server |
| Grant option | Databases,Tables,Functions,Procedures | To give to other users those privileges you possess |
| Index | Tables | To create or drop indexes |
| Insert | Tables | To insert data into tables |
| Lock tables | Databases | To use LOCK TABLES (together with SELECT privilege) |
| Process | Server Admin | To view the plain text of currently executing queries |
| Proxy | Server Admin | To make proxy user possible |
| References | Databases,Tables | To have references on tables |
| Reload | Server Admin | To reload or refresh tables, logs and privileges |
| Replication client | Server Admin | To ask where the slave or master servers are |
| Replication slave | Server Admin | To read binary log events from the master |
| Select | Tables | To retrieve rows from table |
| Show databases | Server Admin | To see all databases with SHOW DATABASES |
| Show view | Tables | To see views with SHOW CREATE VIEW |
| Shutdown | Server Admin | To shut down the server |
| Super | Server Admin | To use KILL thread, SET GLOBAL, CHANGE MASTER, etc. |
| Trigger | Tables | To use triggers |
| Create tablespace | Server Admin | To create/alter/drop tablespaces |
| Update | Tables | To update existing rows |
| Usage | Server Admin | No privileges - allow connect only |
| XA_RECOVER_ADMIN | Server Admin | |
| SET_USER_ID | Server Admin | |
| ROLE_ADMIN | Server Admin | |
| RESOURCE_GROUP_USER | Server Admin | |
| RESOURCE_GROUP_ADMIN | Server Admin | |
| BINLOG_ADMIN | Server Admin | |
| SYSTEM_VARIABLES_ADMIN | Server Admin | |
| GROUP_REPLICATION_ADMIN | Server Admin | |
| CONNECTION_ADMIN | Server Admin | |
| REPLICATION_SLAVE_ADMIN | Server Admin | |
| ENCRYPTION_KEY_ADMIN | Server Admin | |
| BACKUP_ADMIN | Server Admin | |
| PERSIST_RO_VARIABLES_ADMIN | Server Admin | |
+----------------------------+---------------------------------------+-------------------------------------------------------+
46 rows in set (0.00 sec)

You can see that a new user doesn’t have access to the test database anymore:
mysql> use test;
ERROR 1044 (42000): Access denied for user ‘user1’@’%’ to database ‘test’

Let’s allow or user to create tables in the database users1 that we created for him and also allow him to

  • Alter
  • Create
  • Delete
  • Drop
  • Index
  • Insert
  • Select
  • Update
  • Trigger
  • Alter routine
  • Create routine
  • Execute
  • Create temporary tables
 mysql> grant alter,create,delete,drop,index,insert,select,update,trigger,alter routine,
create routine, execute, create temporary tables on user1.* to 'user1';
Query OK, 0 rows affected (0.23 sec)

NO NEED TO RUN FLUSH PRIVILEGES !

And in the session we have still open for user1, we can check the granted privileges:

 mysql> show grants\G
******************** 1. row ********************
Grants for user1@%: GRANT USAGE ON . TO user1@%
******************** 2. row ********************
Grants for user1@%: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP,
INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE, CREATE ROUTINE, ALTER
ROUTINE, TRIGGER ON user1.* TO user1@%
2 rows in set (0.00 sec)

Now let’s imagine we want to have multiple users that will have access to the same database (mydatabase), instead of specifying all the grants for each users, let’s use a common role for all of them. We will call it ‘developer_user‘:

mysql> grant alter,create,delete,drop,index,insert,select,update,trigger,alter
routine,create routine, execute, create temporary tables
on mydatabase.* to 'developer_user';
Query OK, 0 rows affected (0.12 sec)

Let’s grant the role to user1:

 mysql> grant 'developer_user' to 'user1';
Query OK, 0 rows affected (0.16 sec)

Now back again in user1‘s session and let’s verify:

 mysql> SELECT CURRENT_ROLE();
+----------------+
| CURRENT_ROLE() |
+----------------+
| NONE |
+----------------+
1 row in set (0.00 sec)

mysql> set role 'developer_user';
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT CURRENT_ROLE();
+----------------------+
| CURRENT_ROLE() |
+----------------------+
| developer_user@% |
+----------------------+
1 row in set (0.00 sec)

mysql> show grants\G
******************** 1. row ********************
Grants for user1@%: GRANT USAGE ON . TO user1@%
******************** 2. row ********************
Grants for user1@%: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE,
DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE,
CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON mydatabase.* TO user1@%
******************** 3. row ********************
Grants for user1@%: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE,
DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE,
CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON user1.* TO user1@%
******************** 4. row ********************
Grants for user1@%: GRANT developer_user@% TO user1@%
4 rows in set (0.00 sec)

Now we would like that every time user1 logs into MySQL, his new role will be set:

 mysql> set default role 'developer_user' to 'user1';
Query OK, 0 rows affected (0.22 sec)

Let’s also create a user2 having the default role:

 mysql> create user 'user2' identified by 'DontChangeMe' default role 'developer_user';
Query OK, 0 rows affected (0.18 sec)

And we can immediately test it:

 $ mysql -u user2 -pDontChangeMe -h localhost
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 352
Server version: 8.0.13 MySQL Community Server - GPL
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show grants\G
******************** 1. row ********************
Grants for user2@%: GRANT USAGE ON . TO user2@%
******************** 2. row ********************
Grants for user2@%: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE,
DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE,
CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON mydatabase.* TO user2@%
******************** 3. row ********************
Grants for user2@%: GRANT developer_user@% TO user2@%
3 rows in set (0.18 sec)

Summary

In summary, now in MySQL 8.0 you cannot create a user from GRANT, you don’t need to run FLUS PRIVILEGES command (this is effective for a long time already, please forget about it !), you can use ROLES and you have more password management options.

via Planet MySQL
How to grant privileges to users in MySQL 8.0

TFB Review: Bravo Concealment OWB BCA 3.0 Gun Holster

Who got a holster for Christmas this year? Who wanted a holster for Christmas? Even though I have a closet and gun safe overflowing with holsters for all of my firearms I constantly have this grass is greener mentality to holsters. Always searching and trying to find one that is a hair better than the last one. As we journey into colder winter months, we can all do a little more OWB (Outside-the-Waistband) carrying since we are presumably donning heavy coats. As a result, I found myself revisiting a company we have tried before with Bravo Concealment. In this TFB Review, we take a look at the NEW Bravo Concealment OWB BCA 3.0 Gun Holster, specifically for a Glock 19, to see how it measures up to the competition!

Bravo Concealment OWB BCA 3.0 Gun Holster – specifications

The NEW Bravo Concealment OWB BCA 3.0 Gun Holster might appear simple enough, but a lot of its finer points are in the subtle details. The complete specification listing for this holster, as presented by Bravo Concealment, can be read below:

  • NEW Solid Locking Adjustable Retention
  • NEW Minimalist Design for even more All Day Comfort
  • NEW Polymer Plastic provides Supreme Rigidity & Impact Strength assuring Protection of your Firearm
  • Designed for Outside-the-Waistband (OWB) Carry, but can easily be Converted to Inside-the-Waistband (IWB) by swapping out the Belt Loops w/ our IWB Belt Clips
  • 10° Cant enhances Concealment under Loose Garments

owb bca

  • Robust 1.50” or 1.75” Injection Molded Belt Loops prevent Breakage even under Rigorous Use
  • Belt Loops can be replaced w/ Belt Clips for Inside-the-Waistband (IWB) Carry
  • The BCA creates Adequate Room for a Positive Grip; thus, enabling a Smooth Draw w/ Solid Weapon Retention
  • All Edges on Holster are Rounded for Comfort
  • All Holsters are Curved to Fit the Contours of your Body

The nice thing about this holster is if you doctored up your pistol with a threaded barrel it will actually fit. That is pretty rare for most holsters. Typically they fit a perfect footprint of a stock firearm and nothing else. A short snapshot of this holster can also be watched below from Bravo Concealment‘s YouTube page.

If you are wondering what is different about this holster compared to previous ones, you are not the only person throwing out those questions. Bravo Concealment completely addresses what is new about the OWB BCA 3.0 Gun Holster in this public statement below.

The NEW BCA 3.0 Gun Holster still has the same features that made our BCA the BEST OWB gun holster in the industry. So how did we change something so iconic without taking away from it? Well, for starters, we made it personal. How? By adding a retention setting to it. Now you can take your desired retention and apply it to your gun holster. You can go from a medium light retention to a very heavy retention. Ideal for anyone who carries.

We have also taken away from its footprint by eliminating material from it’s bottom corners to make it smaller and lighter. This makes it a very comfortable OWB gun holster while still keeping it’s well known characteristic of staying close to your body.

owb bca

Finally, we now use a diversified Polymer plastic that is known for its ideal balance between rigidity, impact strength and hardness to protect your firearm at all times. Whether you are re holstering consecutively at the range or just carrying while protecting yourself and those around you on a daily basis, know that your firearm is secure and safeguarded. All this makes the NEW BCA 3.0 Gun Holster just as good as it’s predecessor while inheriting a little flair to it.

Bravo Concealment OWB BCA 3.0 Gun Holster – Fit

With the Bravo Concealment OWB BCA 3.0 Gun Holster getting an appropriate fit is very straight-forward. You have a retention screw that is though the center of the holster that you can screw down or back out to match up with your preferred resistance when drawing your weapon. Being a form-fit, friction-fit design there are no buttons, paddles, or straps that need to be manipulated to draw your carry pistol. Simply choose your desired tension, carry, and draw if the need should arise.

owb bca

As a right-handed person I found it easiest to simply draw and holster from my right hip. No big surprises there. It felt secure, my 5.11 pants have a belt loop on the point of the hip (so nestled in between the fixed belt loops on the holster), and while moving about my day it did not impede my ability to do anything.

Bravo Concealment OWB BCA 3.0 Gun Holster – carry time

I carried this holster with a Glock Gen4 19 for roughly a week. This was a full 7 days and I actively carried about 12-14 hours each day. One peculiar thing that happened twice to me is I popped my elbow on my gun in the holster right on my funny bone. Funny to talk about now, but it stung like heck each time it happened. The holster rides higher than others which I liked. I can easily dig in my pockets for change, my wallet, knife and/or pen, but the rear of the pistol is close to your elbow. I learned that twice.

owb bca

While carrying, even though I had those 2 notable “run-ins” with the holster, it felt very secure on the hip. My narrower dress belt which is 1 1/4″ worked great and the holster never felt loose or wobbly. The holster, as unassuming as it looks, contours really well to the body. I never felt like it was weighing me down or annoyingly rubbing against my body like some other holsters can.

owb bca

I attempted to draw my pistol (while unloaded in my family’s empty gun shop before store hours) repeatedly and from varying positions. I tried crouched down, bent over, sitting, kneeling, standing, and a few others. All of the positions I could think to draw from the pistol came out clean and fast. The draw was smooth every time which I truly appreciated. Hopefully I never need to utilize that positive attribute while the gun is loaded, but it is tremendous peace of mind having tested that.

owb bca

For most of my time carrying with the Bravo Concealment OWB BCA 3.0 Gun Holster, I was open carrying while working in a gun shop (not a big deal). Other times I was running mundane errands like buying gas at a gas station, getting a short grocery list, or doing bank deposits (slightly bigger deal). I genuinely believe that most of the general public is pretty oblivious to people who open carry. Most people are tied up in their phones or wrapped up in their own worlds. I only once had someone ask me about my gun and holster. They complimented me on it and asked what brand it was. That started a dialogue about open carry and they remarked that it “looked clean and classy” which I would have to agree.

Throughout those periods in public nobody glared disapprovingly at me or freaked out. I think a lot of that can be attributed to a good, professional looking holster and the demeanor of the person carrying. I would not say I am Mister Rogers packing some heat, but I always try to smile, dress clean (no dirty, gross clothes), and represent all gun owners well when I open carry.

Bravo Concealment OWB BCA 3.0 Gun Holster – final thoughts

Overall, I was very happy with the Bravo Concealment OWB BCA 3.0 Gun Holster for the week that I carried it. It was extremely easy to setup. It felt good on the hip. It was easy to draw from, and I actually caught a stranger peeping at it and they gave me a compliment. All in all, a terrific holster!

If I had to spin something negative about this holster because there is no such thing as a perfect (insert X, Y, Z product here), then I would have to say it might ride a little too high on the hip. I did have my 2 run-ins with the holster where my funny bone said hello. Other than that, it was a good and safe week of carrying.

For our readers out there, have you already tried one of the Bravo Concealment OWB BCA 3.0 Gun Holsters yourself? If so, what do you think? Have you tried a different product from Bravo Concealment? Let us know your thoughts in the Comments below! We always appreciate your feedback.

owb bca

via The Firearm Blog
TFB Review: Bravo Concealment OWB BCA 3.0 Gun Holster

Build a Beginner Knife Shop For $100


He built the knife in the middle using this stuff.

This guy decided to make a video showing that you don’t have to spend a pile of money and have a bunch of fancy tools to make a knife. And while we know that’s true — after all, the American Indians made plenty of sharp stuff without sanders and drills — it’s cool to see that mindset of using commonly-available tools and materials transformed to the reality of today’s environment of plentiful cheap tools.

To that end, he bought tools and materials from Harbor Freight Tools for $101 and change, to show that if you have a table or some other sort of work area, you too can make a knife.

The most questionable thing he does is chop a small dolly up to make the handle scales. This seems wasteful, but as he observes, you don’t have to throw away the rest of it.

For the blade, he uses a hunk he cuts from a circular-saw blade — also from Harbor Freight. Heat treatment is done in small fires built in his gravel driveway, along with a toaster oven.

He did have to hit the grocery store and drop $5 on other stuff… he had a hard time finding vegetable oil at Harbor Freight.

All in all, this shows how you can make a fairly decent knife without a bunch of fancy stuff… heck, most of us probably have everything we need out in the shed or garage. And it’s never a bad time to make something by hand… especially a useful tool that you can show off to your pals.

Enjoy.


via All Outdoor
Build a Beginner Knife Shop For $100

Daily Gun Deals: PSA 5.56 Nitride MPI Full-Auto Bolt Carrier Group (BCG) $49.99


Daily Gun Deals: PSA 5.56 Nitride MPI Full-Auto Bolt Carrier Group (BCG) $49.99

Disclosure: Some of the links below are affiliate links, meaning at no additional cost to you, Ammoland will earn a commission if you click through and make a purchase.

PSA 5.56 Nitride MPI Full-Auto Bolt Carrier Group Deal
PSA 5.56 Nitride MPI Full-Auto Bolt Carrier Group Deal

USA – -(Ammoland.com)- Buy Online Button ClearPalmetto State Armory is having a sale on their popular PSA 5.56 Nitride magnetic particle inspected Full-Auto Bolt Carrier Group for just $49.99. I a world were BCGs average $100 this is a bargain and why we bought 5 units.

The PSA Freedom Nitride BCG is made with a 9310 bolt with a full-auto profile, designed to be used in AR-15 & M-16 style rifles. Bolt is magnetic particle inspected for a uniform quality and operational reliability.

PSA BCG Bolts are well reviewed:

PSA 5.56 Nitride MPI Full-Auto Bolt Carrier Group (BCG) Cart Check 1/09/2018:

PSA 5.56 Nitride MPI Full-Auto Bolt Carrier Group Cart Check
PSA 5.56 Nitride MPI Full-Auto Bolt Carrier Group Cart Check

Daily Gun Deals are the short-term money saving deals AmmoLand News’ Editors search out each day on the world wide web. Be forewarned that many of these deals will sell quickly or expire by the time you read them, but hey we tried. When we find sweet deals on gun products, we need we will be passing along those tips to AmmoLand News readers so you can save cash too. We have your back. Click the product name link for more info and to buy online.

Daily Gun Deals Banner
Daily Gun Deals Banner

Ammoland Editors are scouring the web to find you the deal that will save you money. So good are these deals that they do not last long so pay attention to the publish date and do not delay, take advantage of this deal as soon as we publish it for our readers.

Consider checking our Gun Deals Coupon page and our past featured Daily GunDeals page for additional savings from your favorite industry partners. Thank you very much for your support and I hope we save you some money by highlighting these sweet daily deals. Enjoy!


via AmmoLand.com
Daily Gun Deals: PSA 5.56 Nitride MPI Full-Auto Bolt Carrier Group (BCG) $49.99

Husted to lead DeWine’s InnovateOhio office for tech, entrepreneurship

Lt. Gov.-elect Jon Husted will lead a new omnibus InnovateOhio office to coordinate streamlining of government technology operations and promote broadband internet access, tech education and entrepreneurship statewide.
Gov.-elect Mike DeWine proposed the office when campaigning in September and announced Husted’s leadership role in a Tuesday tweet. Costs or funding sources for the office were not immediately available. The Republican is to be sworn in Monday, and Ohio’s last two incoming governors…

via Columbus Business News – Local Columbus News | Business First of Columbus
Husted to lead DeWine’s InnovateOhio office for tech, entrepreneurship

[How To] Disassemble, Clean, & Lube a Remington 870


Remington 870 Shotguns are one of the definitive shotguns on the market in terms of reliability and ease of use, from civilian use to military and police – the 870 is simply one of the shotguns that almost everyone should own.

It takes a high position in our 5 Best Home Defense & Tactical Shotguns.

But if you’re new to the platform, you might be wondering how to field strip and clean your new scatter gat.

Don’t worry, we’ll cover that and more below…

We also have an awesome video that you can watch if you’d like to see how we clean our 870 directly!

If text and pictures are more your thing, read on!

Cleaning Supplies and Prep

Cleaning an 870 is much like cleaning any other firearm, you’ll need some brushes, patches, a microfiber cloth, solvents, and lubricants. Conveniently all of these tools (except the microfiber cloth), cleaners, and lube are found in the M-Pro 7 Cleaning Kit.

All Gun Cleaning Kits
All Tested Gun Cleaning Kits

If you want some more great gun cleaning options, take a look at our 4 Best Gun Cleaning Kits!

Now that you have your tools, find a decent place to work – a counter, table, or workbench all work great.

Ensure any and all ammunition is removed from the area before you start cleaning your firearm!

I like to lay down a towel or neoprene mat to soak up any spilled solvents and to catch the carbon, copper, and gunk that is cleaned from the weapon.

Field Stripping

The first step to cleaning any weapon is to double or triple check that the weapon is unloaded. For the 870, start with racking your slide to the rear and visually inspecting the chamber to make sure it is clear.

Shotgun Clear
Always make sure your firearm is clean before working on it!

Flip the shotgun over and ensure that the magazine follower is visible and the shotgun tube is empty of shells.

Shotgun Tube Clear
See where John is pointing? That’s the magazine follower.

Next, locate your magazine tube cap at the end of your magazine tube and rotate it counter-clockwise. You’ll see that our shotgun has an extended magazine tube, so your cap/tube might look a little different.

Unthread the magazine cap
Unthread your magazine cap

Make sure that you keep some pressure on the tube while removing the cap, once the cap is removed the tube will still be under some spring tension and can go flying across the room if you’re not careful.

Spring into magazine, tighten down
Careful, that spring might go sailing!

Once complete, the barrel of the shotgun should pull off with a simple tug.

Pull barrel off
Quick tug and the barrel comes off

The forend assembly will take a little fiddling – start with turning the shotgun over and depressing the two tabs you find on the inside of the receiver where the magazine tube meets.

Push the two tabs in
Push the two tabs in…you can see one here, the second one is on the other side.

You might need to press one tab in and then the other, sometimes these can be a bit stiff and hard to move.

Once released just pull the forend assembly off the rest of the shotgun, the bolt and bolt carrier will come out with this step as well.

This is the part that you’ll need your pin punch. Set the shotgun on it’s left side and using your punch and hammer, drive the two pins out the other side.

Punch to remove the two pins
You’ll want a punch to remove the two pins

These should come out fairly easy, but don’t feel shy about giving them a good wack to get them out. You’ll start with the forward most pin.

Pins, forward first
Out with the pins! Forward pin first

After the pins are removed, you can remove the trigger group from the receiver!

Remove Trigger Group
Remove Trigger Group

Cleaning

Give the inside of your now empty receiver a spray of cleaner and then set it aside while we work on the other parts.

Clean inside of receiver
Spray the inside of the receiver with cleaner

Starting with the bolt and bolt carrier. Give the bolt a thorough spray down with cleaner…

Spray bolt
This is your bolt and bolt carrier. Spray them down!

Followed by spraying the carrier itself – you’ll want to separate the two so you can get to all sides of each.

Take your barrel and spray some cleaner down both ends before setting it once again to the side.

Cleaner down both ends of barrel
Spray cleaner down both ends of the barrel

Inspect your forend assembly rails for any carbon build up. There likely won’t be much, so you can normally just wipe it down with a microfiber cloth – but if there is heavy build up, hit it with some cleaner!

Inspect and clean rails
Inspect and clean the rails

Our trigger group is next! Spray with cleaner and wipe down.

Spray Trigger Group
Spray the trigger group

If it is extra dirty you may want to clean it a bit deeper by lowering the hammer to get into the internals of the trigger group. While holding the hammer, gently depress the trigger and slowly lower the hammer down. Be careful as the hammer spring is stiff.

Hammer Forward
Trigger group with the hammer forward

Once clean, recock the hammer and set the trigger group aside.

Grab your bore brush, attach it to your cleaning rod, and run it down the barrel several times starting at the rear of the barrel (the chamber end is the rear).

Brush rear forward
Use your cleaning brush pushing from the rear of the shotgun forward

Attach a cleaning patch by wrapping it around your bore brush, then using the same push-forward method run the patch through your barrel.

Patch on brush
Wrap your brush with a clean patch

This will likely take a few patches before they start to come out mostly clean.

Dirty Brush
Ewwwwww

After the patches are coming out mostly clean, set the barrel aside and grab your receiver!

Using a microfiber cloth wipe down the inside of the receiver paying extra attention to the where the forend assembly rails interface with the receiver. The receiver is unlikely to be extra dirty so this should be easy. If there is buildup though, use a brush to scrub it away.

Clean inside of receiver
Clean the inside of the receiver

Inspect your magazine tube and make sure there isn’t any fowling, debris, or other stuff. If there is then use a dry cleaning patch to clean the inside of the tube. Do not use any lube or cleaning down it!

inside of magazine tube
A look down our magazine tube

Take your bolt and wipe it down with the microfiber cloth. If there is a heavy build-up, use a brush to scrub it!

Microfiber Bolt
Wipe down your bolt using a microfiber cloth

Make sure to inspect the bolt face and extractor claw of the bolt, cleaning those are critical.

Extractor Claw
Extractor Claw and Bolt Face

Repeat with your bolt carrier.

Wipe down bolt carrier
Wipe down the bolt carrier

Lubrication

There are only two parts you need to lubricate, so this is quick and easy.

We’ll start with the trigger group. Place a small amount of lube on the hammer face and the hammer spring.

Lube the hammer and trigger spring
Lube the hammer face and trigger spring

The rails of your forend assembly will also need some lube, but only a small amount and across the entire surface of the rails. Use your microfiber cloth to wipe up excess lube.

Lube rails
Lube the whole rail very lightly

Reassembly

Now that everything is clean and slick it’s time to put your shotgun back together.

Start with the trigger group, insert it into the body of the receiver and aline the pin holes.

Trigger pack back in
Trigger pack going back in

Replace the pins hammering them from the right to the left and starting with the forward pin.

Pins, forward first
Hammer time. Pins go in from the right to the left side of the receiver and forward pin first

Set your bolt carrier into the matching notches on your forend rails. Place the bolt on top of the bolt carrier with the bolt face facing forward toward the muzzle end of the shotgun.

Bolt into notches on rails
Bolt carrier into notches on rails

Place the bolt on top of the bolt carrier with the bolt face facing forward toward the muzzle end of the shotgun.

Bolt on carrier in rails
Bolt on the carrier on the rails

Slide the entire forend assembly over the magazine tube and into the receiver.

Rails and BCG into gun
Forend assembly goes back in

Once you feel resistance, push the internal tabs in the receiver and keep sliding the forend assembly into the receiver.

REsistance, push on tabs used for takedown, slide rail over
Feeling some resistance? Push on the tabs used for disassembly and slide the rails over the tabs

Cycle the pump and the bolt to the rear and then forward about halfway.

Rack to the rear and then forward by half
Rack to the rear and then forward by about half as shown

Grab your barrel again and give it one last inspection before reattaching it to the shotgun, the barrel should slide easily into place.

Replace barrel
Replace the barrel

Reinsert your magazine follower and spring assembly into the magazine tube. Note: the follower goes in first!

Spring into magazine, tighten down
Spring goes into the magazine tube and then tighten down your magazine cap.

Keep in mind that we have a magazine tube extension on our 870, but however your tube looks just tighten down your magazine cap to secure the tube in place.

Finally – rack the action of your shotgun to check that everything functions correctly!

One last step you might want to take is to clean the outside of the gun once it is reassembled. Just take some cleaner and a microfiber cloth and give it a good spray and rub down.

Clean outside of gun
Cleaning the outside of our dirty shotgun

And that’s it! You’re done!

Parting Shots

Now that you’re comfy with taking your shotgun apart and putting it back together again, maybe its time to make some upgrades to your trusty 870.

We recommend starting with some of the Best Shotgun Sights.

Need ammo? Take a look at our Best Shotgun Ammo for the Range & Home Defense article!

Clean your shotgun differently? Let us know about in the comments!


via Pew Pew Tactical
[How To] Disassemble, Clean, & Lube a Remington 870

New Captain Marvel Footage Has Skrulls, Photon Blasts and the Birth of the MCU


A binary Captain Marvel shines in a new IMAX poster.
Image: IMAX

For some, Monday night marked the end of the college football season. For others, like us, it marked the arrival of brand new footage from Captain Marvel and the news that tickets are now on sale.

The film opens March 8, giving you two months to figure out when you want to see the film but, based on this new extended TV spot, that’s probably going to be as soon as possible. Check it out.

That’s a great spot all around but, for me, the highlight is Coulson asking Nick Fury if he can find more heroes like Carol. The answer, as we know, is yes, he will. He’ll find Captain America, Iron Man, Thor, and the Marvel Cinematic Universe will be born. Plus there’s a lot of humor in the footage, more than we’ve seen so far. All of this is very encouraging.

Plus, with tickets now on sale, there are a few cool new posters specific to different formats. Here are three of them.

The Captain Marvel IMAX poster
Image: IMAX
The Captain Marvel Real D poster.
Image: Real D
The Captain Marvel Dolby Cinema poster.
Image: Dolby

Captain Marvel opens March 8. We’ll have much more Tuesday morning.


For more, make sure you’re following us on our new Instagram @io9dotcom.


via Gizmodo
New Captain Marvel Footage Has Skrulls, Photon Blasts and the Birth of the MCU

Sharpening 101: The Best Tips and Products for a Great Edge


Whether you’re running 440C or S90V, even the most super of steels will need to be sharpened eventually. This can be an intimidating task to some, but we’re going to take a look at three systems that make the job easy and achieve fantastic results.

The theory of sharpening is simple. Using something abrasive, usually a stone, material is removed from one side of the edge until you can feel a burr on the opposite side along the entire length of the edge. The process is duplicated on the opposite side.

 

It’s usually best to alternate the side you are working on every few strokes so that each has a similar amount of material removed, keeping the edge itself even and centered.

 

Once you are able to raise a consistent burr on each side, you’ll move to finer grit abrasives until you achieve the desired amount of refinement on the edge. The grit you start with will depend on how degraded the edge is.

 

You can go as high as you want with your grit, all the way up to a mirror polish if desired, but you’ll want to go up to something in the “fine” range…at least 1,000 grit (but often much higher).

 

This is by no means an exhaustive overview, but it’s plenty to get you started. There are myriad ways to achieve the results you need, and today we’re going to take a look at three of our favorite sharpening systems that are suitable for all levels of experience.

The first is the Spyderco Sharpmaker, an intuitive and easy-to-use device that can achieve hair-shaving results on almost any steel out there, as long as the edge isn’t so far gone that you need to reprofile it.

 

 

All of the elements come in a black plastic case that doubles as a stand, making this a very tidy package to store when not in use. There are two preset angles for the stones, meaning you don’t have to worry about maintaining the proper angle as you would when freehand sharpening on a flat stone.

 

One way to check and see if the preset angle is matching up to your knife is to color the sharpened edge in with a black marker. After a few strokes, if the marks have disappeared, you know you are lined up properly.

 

Once the brass guards are in place, you start with the corner of the triangular brown medium stones. All you have to do is hold the blade straight up and down and place the heel of your blade at the top of the stone. Bring the blade straight down, and draw it towards you as you do, so that you hit the whole edge by the time you reach the bottom of the stone.

 

Do this twenty times on each side of the blade, then rotate the stones and perform twenty strokes per side again, this time on the flat side.

 

Repeat the same steps as before, this time using fine white stones, starting with the corner, and then the flat side of the triangle. Once you are finished, your edge should be hair popping sharp. At this point, your blade should be able to cut paper, but we aren’t done yet. The stand also has a couple of other ways of holding the stones, allowing you to easily sharpen other tools such as chisels, scissors, and even straight razors.

 

The Sharpmaker is a truly versatile device that is a classic for a reason – it just plain works.

 

Another system worth checking out that offers even more control over angles than the Sharpmaker is the Lansky Universal Knife Sharpening System.

 

 

This set comes with a clamp that holds your blade steady and provides guide holes for the included stones so you can maintain the proper angle for your blade. Along with honing oil, the standard set comes with coarse, medium, and fine stones and is a great starting point. For a little extra money, higher-end sets come with more grits but they can also be purchased separately, as the standard set’s case comes with extra slots for storage if you choose to upgrade. The process here is simple. Clamp the spine of your blade into place and attach the guide rods to the stones you wish to use. Starting with the coarsest stone you need, choose your angle and insert the guide rod into the proper hole.

 

Sharpen as described earlier until you can raise a burr consistently on both sides, then move up to the next grit until your desired sharpness is achieved.

 

If you want to take your sharpening game to the next level, a powered unit from Work Sharp may be in order. Work Sharp has been raising the bar in the sharpening arena by thinking outside the box, and their Ken Onion Edition Knife & Tool Sharpener is one of our favorite units that they make, offering fast and accurate performance.

 

 

Unlike the previous units we showed you, the Ken Onion Work Sharp is driven by an electric motor, using abrasive belts and an adjustable angle guide to sharpen your edge.

After selecting your angle, set the heel of the blade on the belt, pull the trigger to start the motor, and pull the blade backward at a rate of one inch per second according to the manufacturer, stopping the motor before the tip of your knife passes the centerline of the belt. Then do the same for the opposite side. As with all the sharpening methods we’ve shown you, repeat these steps as necessary until the burr is consistent, then proceed to the next grit until desired sharpness is achieved.

 

 

One thing to keep in mind when using this unit: the motor speed is adjustable, but make sure you don’t overheat your edge and ruin the temper. Keep things nice and slow until you are comfortable with the system.

Further enhancing the versatility of the Ken Onion Work Sharp is its ability to accept add-ons sold separately, including a tool grinding attachment and a blade grinding attachment, offering a form factor similar to professional knife grinders in a much smaller footprint.

As you can see, there are certainly differences between these three systems, but you won’t go wrong with any of them. Friends don’t let friends carry a dull knife, and these are units that we believe in, and not just because we sell them. We actually own them. The units you saw in this blog are ones that came from the KnifeCenter staff’s personal collections, where they have all given years of reliable service.

What questions do you have about using these sharpening systems? Let us know your tried and true tips in the comments below!



via Knife Center News Blog – Latest News
Sharpening 101: The Best Tips and Products for a Great Edge

Scratch 3.0 is now available

The only kids programming language worth using, Scratch, just celebrated the launch of Scratch 3.0, an update that adds some interesting new functionality to the powerful open source tool.

Scratch, for those without school aged children, is a block-based programming language that lets you make little games and “cartoons” with sprites and animated figures. The system is surprisingly complex and kids have created things like Minecraft platformers, fun arcade games, and whatever this is.

The new version of scratch includes extensions that allow you to control hardware as well as new control blocks.

Scratch 3.0 is the next generation of Scratch – designed to expand how, what, and where you can create with Scratch. It includes dozens of new sprites, a totally new sound editor, and many new programming blocks. And with Scratch 3.0, you are able to create and play projects on your tablet, in addition to your laptop or desk computer.

Scratch is quite literally the only programming “game” my kids will use again and again and it’s an amazing introduction for kids as young as pre-school age. Check out the update and don’t forget to share your animations with the class!


via TechCrunch
Scratch 3.0 is now available