From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <gbimobou@gmail.com>
X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on
 sa.local.altlinux.org
X-Spam-Level: 
X-Spam-Status: No, score=-2.0 required=5.0 tests=BAYES_00,DKIM_SIGNED,
 DKIM_VALID,DKIM_VALID_AU,FREEMAIL_FROM autolearn=ham autolearn_force=no
 version=3.4.1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025;
 h=from:subject:to:references:message-id:date:user-agent:mime-version
 :in-reply-to:content-transfer-encoding;
 bh=o5i/GVMw/oyEjgoXb4TU94cg7fMabPZew6Eg4t+cmhY=;
 b=c/4UtiYfpGH967CqAq+L5ENtSvO2v9mDYvCsa8FoSpcesRiGwZMq5umXerLnXGfOuP
 lo5VXP3GhXbv+TxXFsxhow7V8HDY0Vb1+zV+tpOI/iBeRpt6B7rb/qexvX5h5TuP4KRj
 ilkYjnHrAuNwMdri+ogmiX61xukd8Ghl526kqULRMCQT346l5dHZGeeDbfsVMIiOJwfL
 zmbNUUWp/Doo4sExb9C+sso6BnsrvwSpUZZ7O0Qw+IXzRlsegkTnoG7gLbWcdy/dN9Kr
 b6qqBdr42LsyUtPPeHBQpQEfxX6BEFSWGezf4a17K4+nYxyk1x4+V0hC0sQ9Czm2ukYL
 Oigg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20161025;
 h=x-gm-message-state:from:subject:to:references:message-id:date
 :user-agent:mime-version:in-reply-to:content-transfer-encoding;
 bh=o5i/GVMw/oyEjgoXb4TU94cg7fMabPZew6Eg4t+cmhY=;
 b=AT2fz0oGNXd4aOavRSiH8HrT8d0BCQo6sBK9P+3+Ci4nW1V7fhc2vwSCFd1Q6RbXXw
 8Hjflo2ZsaA8zPo/xwkbV6szgV0aXIxPqGUPaksAbb4KTEs15ej7Eq9257tcs6yJzNAz
 u1nai27AAFQKzD8ZHPinc5nTv6V1hcHUzrHjsh0sN4fUQcwz9iNyV0LUmISzQumNckz4
 yOqtTiAishrPweYAxyds/qsF01DFJ1jTfAjUaJyza5mNZ10zF2k+ffeIITr7LxO49axg
 /OPkwISH2OdooaVJd+o1wZvCsAVgd+/Dgmzta0ZjPlgc4uBIWQLtXaPYC24WhFey127y
 MaJg==
X-Gm-Message-State: AFeK/H3YM/ZdoKxUo6kGD31yPGD6TUWaafKgS9x/NCJ3FABu3O4wm6MUR7VCfCfMQcwO4g==
X-Received: by 10.25.15.41 with SMTP id e41mr7527218lfi.117.1489968631212;
 Sun, 19 Mar 2017 17:10:31 -0700 (PDT)
From: "=?UTF-8?B?0JLQsNC00LjQvCDQmNC70LvQsNGA0LjQvtC90L7Qsg==?="
 <gbimobou@gmail.com>
X-Google-Original-From: =?UTF-8?B?0JLQsNC00LjQvCDQmNC70LvQsNGA0LjQvtC90L7Qsg==?=
 <gbIMoBou@gmail.com>
To: ALT Linux sysadmins' discussion <sysadmins@lists.altlinux.org>
References: <73902f18-52af-d661-0710-05921a0a1625@tut.by>
Message-ID: <6aa50f93-ef33-4e86-3637-af447d510ea5@gmail.com>
Date: Mon, 20 Mar 2017 08:09:34 +0800
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.7.0
MIME-Version: 1.0
In-Reply-To: <73902f18-52af-d661-0710-05921a0a1625@tut.by>
Content-Type: text/plain; charset=koi8-r
Content-Transfer-Encoding: 8bit
Subject: Re: [Sysadmins] =?utf-8?b?UDggLSBNeVNRTCDQvdC1INC/0YPRgdC60LDQtdGC?=
 =?utf-8?q?_root=27a?=
X-BeenThere: sysadmins@lists.altlinux.org
X-Mailman-Version: 2.1.12
Precedence: list
Reply-To: ALT Linux sysadmins' discussion <sysadmins@lists.altlinux.org>
List-Id: ALT Linux sysadmins' discussion <sysadmins.lists.altlinux.org>
List-Unsubscribe: <https://lists.altlinux.org/mailman/options/sysadmins>,
 <mailto:sysadmins-request@lists.altlinux.org?subject=unsubscribe>
List-Archive: <http://lists.altlinux.org/pipermail/sysadmins>
List-Post: <mailto:sysadmins@lists.altlinux.org>
List-Help: <mailto:sysadmins-request@lists.altlinux.org?subject=help>
List-Subscribe: <https://lists.altlinux.org/mailman/listinfo/sysadmins>,
 <mailto:sysadmins-request@lists.altlinux.org?subject=subscribe>
X-List-Received-Date: Mon, 20 Mar 2017 00:10:33 -0000
Archived-At: <http://lore.altlinux.org/sysadmins/6aa50f93-ef33-4e86-3637-af447d510ea5@gmail.com/>
List-Archive: <http://lore.altlinux.org/sysadmins/>

20.03.2017 04:40, А. Куликовский пишет:
> Здравствуйте.
>
> Свежеустановленный P8 server, LAMP.
>
>  # mysql -u root -p
> Enter password:
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)
>
> Если skip-grant-tables в my.cnf, то пускает.
> В логах ничего необычного...
>

Так заведите юзера roundcube@% с паролем, отдайте права на базу шарокуба
ему и им же подключайтесь.

Ну, и для доступа рутом извне тоже надо завести root@%, а локальному
руту задать пароль.

-- 
Мимо крокодил.
WBR, rednex CIO.
JID = <mailto:>
Skype = $local_part@<mailto:>
Viber = +7(964)103-65-67

Опции rsync -aHAX --delete мозг автоматом переводит как "удалить к чёртовой матери!"