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

Momchil Ivanov <[email protected]> Fri, 2 Mar 2007 16:06:00 +0100
Newsgroups gmane.os.freebsd.devel.database
Message-ID <[email protected]>
На 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
signature.asc (application/pgp-signature, 187 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (FreeBSD)

iD8DBQBF6D1c4D1W2jEYFosRAlAiAJ9Upo3FYhYnEn5ZpB2cCQgfWmrNHgCfT+I/
c34fIlvk1isBoKnPEQoMTOk=
=nNio
-----END PGP SIGNATURE-----