From: "Lenya L. Khachaturov" <lenya@chemsell.yaroslavl.ru> To: Andrei Bulava <mandrake-russian@altlinux.ru> Subject: Re[2]: [mdk-re] Re: MySQL question [Access denied] Date: Thu Mar 21 12:42:13 2002 Message-ID: <39249097343.20020321124230@chemsell.yaroslavl.ru> (raw) In-Reply-To: <Pine.BSF.4.44.0203210918190.88404-100000@elefant.dgtu.donetsk.ua> 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> <skip> >> > Не забудьте сказать 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) Посмотрите, пожалуйста, что не так! <skip> -- Best regards, Lenya L. Khachaturov mailto:lenya@chemsell.yaroslavl.ru
prev parent reply other threads:[~2002-03-21 12:42 UTC|newest] Thread overview: 8+ messages / expand[flat|nested] mbox.gz Atom feed top 2002-03-20 19:48 [mdk-re] " Lenya L. Khachaturov 2002-03-20 20:08 ` Sergey Degtyaryov 2002-03-20 20:16 ` Re[2]: " Lenya L. Khachaturov 2002-03-20 20:23 ` Любимов А.В. 2002-03-20 20:48 ` Dmitry Solovyev 2002-03-21 2:21 ` [mdk-re] " Mikhail Zabaluev 2002-03-21 10:23 ` Andrei Bulava 2002-03-21 12:42 ` Lenya L. Khachaturov [this message]
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=39249097343.20020321124230@chemsell.yaroslavl.ru \ --to=lenya@chemsell.yaroslavl.ru \ --cc=mandrake-russian@altlinux.ru \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
ALT Linux Community general discussions This inbox may be cloned and mirrored by anyone: git clone --mirror http://lore.altlinux.org/community/0 community/git/0.git # If you have public-inbox 1.1+ installed, you may # initialize and index your mirror using the following commands: public-inbox-init -V2 community community/ http://lore.altlinux.org/community \ mandrake-russian@linuxteam.iplabs.ru community@lists.altlinux.org community@lists.altlinux.ru community@lists.altlinux.com public-inbox-index community Example config snippet for mirrors. Newsgroup available over NNTP: nntp://lore.altlinux.org/org.altlinux.lists.community AGPL code for this site: git clone https://public-inbox.org/public-inbox.git