ERROR 1045 (28000): Access denied for user 'zabbix'@'ritm' (using, password: YES)

[Rajen Jani (BT Yahoo! Broadband)]

Hello people,

               Thanks for helping me out last time. I am still having
the above problem. I did the following prior:

shell>> mysql

mysql> GRANT ALL PRIVILEGES ON zabbix TO .*  'zabbix'@'ritm' IDENTIFIED
BY 'password';

mysql> quit
bye

shell>> mysql  -h ritm -u zabbix -p
password: ********

ERROR 1045 (28000): Access denied for user 'zabbix'@'ritm.axigral'
(using,password: YES)

If I do it without password then it goes through ok. Any suggestions
appreciated.

If I go through the mysql documentation on the website they have nothing
on FreeBSD.

Regards,


Rajen
_______________________________________________
freebsd-database@... mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "freebsd-database-unsubscribe@..."

[Reinoud van Leeuwen]

On Fri, Mar 02, 2007 at 02:01:37PM +0000, Rajen Jani (BT Yahoo! Broadband) wrote:
> Hello people,
>
>                Thanks for helping me out last time. I am still having
> the above problem. I did the following prior:
>
> shell>> mysql
>
> mysql> GRANT ALL PRIVILEGES ON zabbix TO .*  'zabbix'@'ritm' IDENTIFIED
> BY 'password';

did you do a 'flush privileges'?
(took me a day to find out as well....)

--
__________________________________________________
"Nothing is as subjective as reality"
Reinoud van Leeuwen    reinoud.v@...
http://www.xs4all.nl/~reinoud
__________________________________________________
_______________________________________________
freebsd-database@... mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "freebsd-database-unsubscribe@..."

[Momchil Ivanov]

На 2.3.2007 15:01 Rajen Jani (BT Yahoo! Broadband) пише:
> Hello people,
>
>                Thanks for helping me out last time. I am still having
> the above problem. I did the following prior:
>
> shell>> mysql
>
> mysql> GRANT ALL PRIVILEGES ON zabbix TO .*  'zabbix'@'ritm' IDENTIFIED
> BY 'password';

Try using:
GRANT ALL ON zabbix.* TO 'zabbix'@'ritm' IDENTIFIED BY 'password';
I think your '.*' after TO makes it wrong

--
This correspondence is strictly confidential. Any screening, filtering
and/or production for the purpose of public or otherwise disclosure is
forbidden without written permission by the author signed above. If you are
not the intended recipient, please immediately notify the sender and
permanently delete any copies

PGP KeyID: 0x3118168B
Keyserver: pgp.mit.edu
Key fingerprint BB50 2983 0714 36DC D02E  158A E03D 56DA 3118 168B

[Miroslav Lachman]

Rajen Jani (BT Yahoo! Broadband) wrote:

> Hello people,
>
>                Thanks for helping me out last time. I am still having
> the above problem. I did the following prior:
>
> shell>> mysql
>
> mysql> GRANT ALL PRIVILEGES ON zabbix TO .*  'zabbix'@'ritm' IDENTIFIED
> BY 'password';

You have wrong syntax of GRANT command. Right is:

mysql> GRANT ALL PRIVILEGES ON zabbix.* TO zabbix@ritm IDENTIFIED
BY 'password';

where first "zabbix" is database name and asterisk wildcard means "all
tables in this database", second "zabbix" is username and "ritm" is
hostname (FQDN or IP adrress) of the machine from which the user zabbix
will connect from. If database server and zabbix user is on the same
machine, it should be localhost.

Miroslav Lachman
_______________________________________________
freebsd-database@... mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "freebsd-database-unsubscribe@..."