Alan Morey wrote:
>
> I connect to the mysql database, as root
>
> mysql> GRANT SELECT, INSERT, DELETE UPDATE ON mydatabase.* TO user@stripped
> IDENTIFIED BY 'blah' ;
>
> mysql> GRANT SELECT ON mydatabase.* TO user2@% IDENTIFIED BY 'bahh';
> But when i try to connect to the mydatabase i get access denied. Any ideas
> what i'm doing wrong
>
> I am trying to make a web interface to the database and i want two users,
> one user should be able to SELECT, INSERT, DELETE UPDATE and the should
> just be able to SELECT.
>
> thanks
> alan
Hi Alan
You are not specific enough.
Did you try the 'user' account from host '10.0.0.1' and is this _not_ equal to
'localhost'?
Did you give the password on connecting?
Example:
shell> mysql --user=user --password=blah --host=mysql.machine.com mydatabase
If you tried the 'user2' account from 'localhost', you probably collided with the user
enty for ''@localhost (read: everyone from localhost).
BTW:
It always is good to give at least some infos about your OS and the mysql version you use.
Tschau
Christian
PS: Sorry for the late answer, I was on vacation.
