UPDATE: we created the module that allows you to confirm customer emails from Magento admin.



Magento 2 gives us the ability to take more control of the customer account creation process. There is a special configuration setting located in admin under Stores → Configuration → Customers → Customer Configuration → Create New Account Options named Require Emails Confirmation (Yes/No)

Account confirmation setting

If you set this setting to Yes, a customer will not be able to log in without account confirmation. He needs to click the activation link in account confirmation email.

Account confirmation is required

By the way, this email template is defined in vendor/magento/module-customer/etc/email_templates.xml file:

<template id="customer_create_account_email_confirmation_template" label="New Account Confirmation Key"file="account_new_confirmation.html" type="html" module="Magento_Customer" area="frontend"/>


Unfortunately, there is no way to confirm user account from Magento 2 admin area.
If you are a developer and you are doing some local testing (assuming you don't receive emails from your local installation) you can confirm a customer account via the database.
There is a field `customer_entity`.`confirmation` which contains activation hash code.

MySQL field


All you need to do - is simply remove that hash value.
Here is SQL query that will help you to confirm customer by email:


UPDATE customer_entity SET confirmation = NULL WHERE email='[email protected]';



The easiest solution

We created a special module that gives you the ability to confirm customer emails from Magento admin.