composer require "dektrium/yii2-user:0.9.*@dev"

<?php

$params = require(__DIR__ . '/params.php');

$config = [
//...
'components' => [
 'user' => [
            //'identityClass' => 'app\models\User',
            'identityClass' => 'dektrium\user\models\User',
            'enableAutoLogin' => true,
 ],
 // ...
],
'modules' => [
    'user' => [
        'class' => 'dektrium\user\Module',
        'enableUnconfirmedLogin' => true,
        'confirmWithin' => 21600,
        'cost' => 12,
        'admins' => ['admin']
    ],
    //...
],

'<module:\w+>/<controller:\w+>/<action:\w+>' => '<module>/<controller>/<action>',

<?php

$params = require(__DIR__ . '/params.php');

$config = [
//...
     'urlManager' => [
               'class' => 'yii\web\UrlManager',
               // Disable index.php
               'showScriptName' => false,
               // Disable r= routes
               'enablePrettyUrl' => true,
               'rules' => [
                       '<controller:\w+>/<id:\d+>' => '<controller>/view',
                       '<controller:\w+>/<action:\w+>/<id:\d+>' => '<controller>/<action>',
                       '<controller:\w+>/<action:\w+>' => '<controller>/<action>',
                       ['class' => 'yii\rest\UrlRule', 'controller' => 'location', 'except' => ['delete','GET', 'HEAD','POST','OPTIONS'], 'pluralize'=>false],
                       '<module:\w+>/<controller:\w+>/<action:\w+>' => '<module>/<controller>/<action>',
               ],
    ],
//...
]

php yii migrate/up --migrationPath=@vendor/dektrium/yii2-user/migrations

Exception 'yii\db\Exception' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/Applications/MAMP/tmp/mysql/mysql.sock' (2)'

Yii Migration Tool (based on Yii v2.0.4)

Total 7 new migrations to be applied:
    m140209_132017_init
    m140403_174025_create_account_table
    m140504_113157_update_tables
    m140504_130429_create_token_table
    m140830_171933_fix_ip_field
    m140830_172703_change_account_table_name
    m141222_110026_update_ip_field

Apply the above migrations? (yes|no) [no]:

*** applying m140209_132017_init
    > create table  ... done (time: 0.056s)
    > create unique index user_unique_username on  (username) ... done (time: 0.047s)
    > create unique index user_unique_email on  (email) ... done (time: 0.035s)
    > create unique index user_confirmation on  (id, confirmation_token) ... done (time: 0.066s)
    > create unique index user_recovery on  (id, recovery_token) ... done (time: 0.033s)
    > create table  ... done (time: 0.023s)
    > add foreign key fk_user_profile:  (user_id) references  (id) ... done (time: 0.015s)
*** applied m140209_132017_init (time: 0.288s)

*** applying m140403_174025_create_account_table
    > create table  ... done (time: 0.028s)
    > create unique index account_unique on  (provider,client_id) ... done (time: 0.018s)
    > add foreign key fk_user_account:  (user_id) references  (id) ... done (time: 0.023s)
*** applied m140403_174025_create_account_table (time: 0.072s)

*** applying m140504_113157_update_tables
    > drop index user_confirmation ... done (time: 0.029s)
    > drop index user_recovery ... done (time: 0.010s)
    > drop column confirmation_token from table  ... done (time: 0.040s)
    > drop column confirmation_sent_at from table  ... done (time: 0.054s)
    > drop column recovery_token from table  ... done (time: 0.040s)
    > drop column recovery_sent_at from table  ... done (time: 0.036s)
    > drop column logged_in_from from table  ... done (time: 0.040s)
    > drop column logged_in_at from table  ... done (time: 0.040s)
    > rename column registered_from in table  to registration_ip ... done (time: 0.021s)
    > add column flags integer NOT NULL DEFAULT 0 to table  ... done (time: 0.043s)
    > rename column properties in table  to data ... done (time: 0.017s)
*** applied m140504_113157_update_tables (time: 0.373s)

*** applying m140504_130429_create_token_table
    > create table  ... done (time: 0.027s)
    > create unique index token_unique on  (user_id,code,type) ... done (time: 0.018s)
    > add foreign key fk_user_token:  (user_id) references  (id) ... done (time: 0.051s)
*** applied m140504_130429_create_token_table (time: 0.098s)

*** applying m140830_171933_fix_ip_field
    > alter column registration_ip in table  to bigint ... done (time: 0.033s)
*** applied m140830_171933_fix_ip_field (time: 0.038s)

*** applying m140830_172703_change_account_table_name
    > rename table  to  ... done (time: 0.024s)
*** applied m140830_172703_change_account_table_name (time: 0.027s)

*** applying m141222_110026_update_ip_field
    > alter column registration_ip in table  to string(45) ... done (time: 0.036s)
*** applied m141222_110026_update_ip_field (time: 0.041s)


Migrated up successfully.

Yii::$app->user->isGuest ?
['label' => 'Sign in', 'url' => ['/user/security/login']] :
['label' => 'Account(' . Yii::$app->user->identity->username . ')', 'items'=>[
    ['label' => 'Profile', 'url' => ['/user/settings/profile']],
    ['label' => 'Account', 'url' => ['/user/settings/account']],
    ['label' => 'Logout', 'url' => ['/user/security/logout'],'linkOptions' => ['data-method' => 'post']],
]],
['label' => 'Register', 'url' => ['/user/registration/register'], 'visible' => Yii::$app->user->isGuest],