From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: From: "Lenya L. Khachaturov" X-Mailer: The Bat! (v1.54 Beta/46) Personal Organization: =?koi8-r?B?7+/vICLx0snO1MXSy8/NLfPF0tfJ0yI=?= X-Priority: 3 (Normal) Message-ID: <39249097343.20020321124230@chemsell.yaroslavl.ru> To: Andrei Bulava Subject: Re[2]: [mdk-re] Re: MySQL question [Access denied] In-Reply-To: References: MIME-Version: 1.0 Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 8bit Sender: mandrake-russian-admin@altlinux.ru Errors-To: mandrake-russian-admin@altlinux.ru X-BeenThere: mandrake-russian@altlinux.ru X-Mailman-Version: 2.0 Precedence: bulk Reply-To: mandrake-russian@altlinux.ru X-Reply-To: "Lenya L. Khachaturov" List-Help: List-Post: List-Subscribe: , List-Id: Linux-Mandrake RE / ALT Linux discussion list List-Unsubscribe: , List-Archive: Date: Thu Mar 21 12:42:13 2002 X-Original-Date: Thu, 21 Mar 2002 12:42:30 +0300 Archived-At: List-Archive: List-Post: Hello Andrei, Thursday, March 21, 2002, 10:22:45 AM, you wrote: AB> Добрый день! AB> Заранее простите за пятикопеечникство ;-) AB> On Thu, 21 Mar 2002, Mikhail Zabaluev wrote: >> Hello Dmitry, >> >> On Wed, Mar 20, 2002 at 11:46:09PM +0600, Dmitry Solovyev wrote: >> > AB> >> > Не забудьте сказать flush privelegues после правки. >> >> Разве после GRANT это нужно? AB> Не нужно абсолютно. IMHO через GRANT действовать несколько более right AB> way AB> А вот надо ли root'у заходить откуда-нибудь кроме localhost - это уже AB> религиозный вопрос. И мой ответ на него - NO! Да у меня вообще никого не пускает. Мне рутом и не обязательно, хотя бы обычным юзером. Вот мои mysql.user, mysql.db: mysql> select * from db; +-----------+-----------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ | Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +-----------+-----------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ | % | test | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | % | test\_% | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | % | obltour | obltour | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | localhost | obltour | obltour | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | % | pinsource | pinsource | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | | localhost | sui | sui | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | +-----------+-----------+-----------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+ 6 rows in set (0.00 sec) mysql> select * from user -> ; +--------------------------+-----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +--------------------------+-----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ | % | root | 398dbca9067c3fb2 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | testbox.private.incap.ru | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | % | obltour | 0185eb015b98ad21 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | localhost | obltour | 3193dbb34a147624 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | % | pinsource | 1fc020066bdef3be | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | % | sui | 789d8fdb262f3c03 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | +--------------------------+-----------+------------------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+ 6 rows in set (0.00 sec) Посмотрите, пожалуйста, что не так! -- Best regards, Lenya L. Khachaturov mailto:lenya@chemsell.yaroslavl.ru