You need to flush privileges after you add a new user.
FYI... Paul DuBois' mySQL book covers this in great detail and should be
considered the Bible for mySQL
Check the manual for flushing priliges if you don't have available access to
this book...
-----Original Message-----
From: Carlos Corzo [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 10:39 AM
To: MySQL
Subject: Creating the database
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
---------------------------------------------------------------------
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
