creating a new user with mysql on 4.0.20a
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
FW: creating a new user with mysql on 4.0.20a
Oops, used wrong email address -Original Message- Sent: 08 August 2004 12:23 To: [EMAIL PROTECTED] Subject: creating a new user with mysql on 4.0.20a 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
Re: creating a new user with mysql on 4.0.20a
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]