On Thu, 14 Aug 2003 15:19:46 +0300, Victoria Reznichenko wrote:
>"Mark Healey" <[EMAIL PROTECTED]> wrote:
>> 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 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?
>
>Delete anonymous user('') from table user. Don't forget about FLUSH PRIVILEGES.
Thanks, that worked. Why?
Exactly what does 'flush privileges' do anyway? It isn't mentioned in the
O'reilly book.
And now an unrelated question.
Why isn't there a BOOL column type? As I was designing tables in my
head I figured that there would one. So many things in life are
boolean values.
Again, thanks.
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]
