Hello,
I am trying this security stuff out. Trial and error is the only way to
go.
I have logged in to mysql as root and then selected to use mysql table.
This is how I would grant priviledges to different users.
I used the commands successfully and typed:
insert into user
(Host,User,Password,Select_Priv,Insert_Priv,Update_Priv,Delete_Priv)
values ('localhost','lurustest',password('goblue'),'Y','Y','Y','Y');
This was added into the table.
So I log off as root and try to log in as lurustest
mysql -u lurustest -p
When I typed in the password, I got the following error message
ERROR 1045: Access denied for user: 'lurustest@localhost' (Using
password: YES)
I thought I gave lurustest access? Also, everything was run while being
on localhost. The IP address that I logged into.
Any comments?
Thanks.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
