On Sun, 2004-08-08 at 07:22, Kerry Frater wrote: > I am just going through some taching docs and it says that I can create a > new user with all authority on a new DB using the command > > GRANT ALL ON llcopy.* TO auser IDENTIFIED BY 'thepassword'; > > yet when I try and run 'mysql' using > mysql -uauser -pthepassword > > I get the error > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: > YES) > > Is there an easy way to GRANT priveleges to users no matter where they > logion from? > > Kerry
this is what you want. users are generally granted specific permissions depending on where they are logged in from. GRANT ALL ON llcopy.* TO auser.'%' IDENTIFIED BY 'thepassword'; -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
