Battling with priviliges in mysql

[Mellegem]

Hi all

I'm using the following command in mysql 4.1.5 on a Gentoo box.

grant SELECT,INSERT,DELETE on trawler.* to 'machine'@'%' identified by 'zo14LI615';

But the following happens when I try log in.

mysql -umachine -higor -pzo14LI615 trawler
ERROR 1045 (28000): Access denied for user 'machine'@'igor' (using password: YES)
~

Here are some of the outputs i've been getting.

Any ideas?

[wayne@Igor] mysql -umachine -higor
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18 to server version: 4.1.5-gamma-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

~
[mellegem@Igor] mysql -umachine -higor trawler
ERROR 1044 (42000): Access denied for user ''@'Igor' to database 'trawler'
~
[mellegem@Igor] mysql -umachine -higor -pzo14LI615 trawler
ERROR 1045 (28000): Access denied for user 'machine'@'igor' (using password: YES)
~
[mellegem@Igor] mysql -umachine -higor -pzo14LI615
ERROR 1045 (28000): Access denied for user 'machine'@'igor' (using password: YES)

 

[Bastien]

try

grant SELECT,INSERT,DELETE on trawler.* to 'machine'@'%' identified by password('zo14LI615');

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...

 

[Mellegem]

Hi, when trying the suggestion I get the following output.

mysql> grant SELECT,INSERT,DELETE on trawler.* to 'machine'@'%' identified by password('zo14LI615');
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('zo14LI615')' at line 1