From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Message-ID: <41F41A44.2070905@ukr.net> Date: Sun, 23 Jan 2005 23:42:28 +0200 From: =?KOI8-R?Q?=ED=C1=D2=27=D1=CE_=F0=C5=D4=D2=C9=DB=C9=CE?= Organization: =?KOI8-R?Q?=D0=D2=C9=D7=C1=D4=CE=C1_=CF=D3=CF=C2=C1?= User-Agent: Mozilla/5.0 (X11; U; Linux i686; uk-UA; rv:1.7.2) Gecko/20040808 X-Accept-Language: uk, en MIME-Version: 1.0 To: community@altlinux.ru X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 8bit Subject: [Comm] MySQL Access denied for user: X-BeenThere: community@altlinux.ru X-Mailman-Version: 2.1.5 Precedence: list Reply-To: community@altlinux.ru List-Id: Mailing list for ALT Linux users List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 23 Jan 2005 21:42:47 -0000 Archived-At: List-Archive: List-Post: Привет. Никак не могу понять в чем дело. Вроде и пользователя создал. Вот листинг таблици mysql.user (mysql.db и mysql.host чистые): 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 | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | +-----------------------+------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ | localhost | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | | localhost.localdomain | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | | % | pmd | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | +-----------------------+------+----------+-------------+-------------+-------------+-------------+-------------+-----------+-------------+---------------+--------------+-----------+------------+-----------------+------------+------------+--------------+------------+-----------------------+------------------+--------------+-----------------+------------------+----------+------------+-------------+--------------+---------------+-------------+-----------------+ 3 rows in set (0.00 sec) Все время получаю сообщения вроде: [pmd@pmd Desktop]$ mysql probe -u pmd ERROR 1044: Access denied for user: '@localhost' to database 'probe' или [pmd@pmd Desktop]$ mysql probe -u pmd -p Enter password: ERROR 1045: Access denied for user: 'pmd@localhost' (Using password: YES) Я раньше Interbase пользовался из-под форточек. А тепер прямо в ступоре - сделал все как книжка пишет а войти могу только под root-ом. Что не так. Может какие-то нюансы есть. Большое спасибо за помощь. -------------------------- С уважением, Мар'ян Петришин