El Wed, 13 Aug 2003 12:24:58 -0700 (PDT) "Mark Healey" <[EMAIL PROTECTED]> escribio:
> I'm trying to learn to use mysql. I don't want to mess with the > system databases so I decided create a database and user to play > with but I can't seem to do it right. > > I logged in as root and created a database > > mysql> create database marksstuff; > Query OK, 1 row affected (0.00 sec) > > I then granted priveleges to mark > > mysql> grant all on marksstuff.* to mark identified by 'password'; not the real > password > Query OK, 0 rows affected (0.01 sec) I'm not sure about this, but try: grant all on marksstuff.* to mark identified by "password"; > > I then logged out and tried to login as mark > > [EMAIL PROTECTED] mark]$ mysql -u mark -ppassword > ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) > > What am I doing wrong? > > > > Mark Healey > [EMAIL PROTECTED] > > This account is only for lists to which I've subscribed. > Any spammers invite the worst revenge I think I can get away with. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- ________________________________________________________ One ping to rule them all, one ping to find them, one ping to bring them all and in the darkness bind them. (Lord of the windows) ============================================================================ This e-mail message and any attached files are intended SOLELY for the addressee/s identified herein. It may contain CONFIDENTIAL and/or LEGALLY PRIVILEGED information and may not necessarily represent the opinion of this company. If you receive this message in ERROR, please immediately notify the sender and DELETE it since you ARE NOT AUTHORIZED to use, disclose, distribute, print or copy all or part of the contained information. Thank you. ============================================================================ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
