Re: Grant priviliges.

[Jay Pipes]

You're getting the Linux user and the MySQL user mixed up. You need to specify a user and host in the grant statement, along with an optional password with the IDENTIFIED BY clause. It does not matter who you are logged into your shell as; what matters is who you're logged into the mysql client as.

log in as root to the mysql client:

#> mysql -uroot -p
Enter password:

mysql> GRANT SELECT ON database.table TO 'user1'@'localhost' IDENTIFIED BY 'some_password';
mysql> exit

then log in as user1 to the mysql client:

#> mysql -uuser1 -p
Enter password:

mysql> SELECT * FROM database.table;

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com