ALT Linux Community general discussions
 help / color / mirror / Atom feed
* [Comm] MySQL Access denied for user:
@ 2005-01-23 21:42 Мар'ян Петришин
  2005-01-23 22:29 ` Мар'ян Петришин
  0 siblings, 1 reply; 5+ messages in thread
From: Мар'ян Петришин @ 2005-01-23 21:42 UTC (permalink / raw)
  To: community

Привет.

Никак не могу понять в чем дело. Вроде и пользователя создал. Вот листинг
таблици 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-ом. Что не так. Может какие-то нюансы есть.

Большое спасибо за помощь.
--------------------------
С уважением, Мар'ян Петришин





^ permalink raw reply	[flat|nested] 5+ messages in thread

end of thread, other threads:[~2005-01-24  8:01 UTC | newest]

Thread overview: 5+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2005-01-23 21:42 [Comm] MySQL Access denied for user: Мар'ян Петришин
2005-01-23 22:29 ` Мар'ян Петришин
2005-01-24  0:40   ` Voldar
2005-01-24  7:39     ` [Comm] " Michael Shigorin
2005-01-24  8:01       ` Мар'ян Петришин

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