Thanks James! The actual command that worked for me was as follows: mysql> GRANT SELECT ON db.* TO [EMAIL PROTECTED] IDENTIFIED BY '2user3'; Query OK, 0 rows affected (0.09 sec)
I receieved errors while trying to include the 'PASSWORD' option, as that seemed to be wanting a the password in hex format. Anyway, thanks again James! Lee --- James Weisensee <[EMAIL PROTECTED]> wrote: > Lee, > On the MySQL side: > > GRANT SELECT ON db.* TO user@'host' IDENTIFIED BY > PASSWORD 'password'; > > This will give 'user' from 'host' SELECT privileges > to > all tables on 'db' (db.*). > > http://dev.mysql.com/doc/mysql/en/GRANT.html > > HTH, > James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]